It is not absolutely necessary to include a header – if you arrange your Excel data as shown above, Office Timeline will automatically detect your milestones and tasks without it.You can also add a Percent Complete column for tasks or a Notes column, but these are not mandatory details for a successful Excel Import.They can be arranged in any order you wish (even interlaced), in separate tables or in a single table, as long as they are in the same spreadsheet and their dates and titles are stacked up onto each other in the same column. Below you can see an example of how your data should be organized in Excel to load it into Office Timeline Online successfully:ĭownload an Excel schedule formatting sample from here.Īs you can see in our example, tasks should have a Start Date, End Date and Title (description), while milestones come with a Title and only a Start Date or End Date. For a quick summary of how importing from Excel works, see our short video tutorial below:īefore importing your data, we recommend to first ensure your spreadsheet is set up properly.
Read the whole step-by-step guide or click on any of the links above to jump to the section you’re most interested in. You will learn to:Ī) Set up your Excel data and bring it into Office Timeline
The following guide will show you how to quickly turn your spreadsheet into a beautiful, easy-to-understand timeline using the web tool’s Excel Import functionality.
To save time and effort, users can import their project data from Excel straight into Office Timeline Online.
0 kommentar(er)
