Importing and Exporting Excel Data with Office Timeline

In both Office Timeline Plus and in Office Timeline Free edition you can export your project timelines or Gantt templates from PowerPoint into Excel data tables.  Also, in Office Timeline Plus Edition you can quickly create a PowerPoint timeline or Gantt chart by importing your project schedule from Excel.


Exporting project schedules back to Excel is an easy two-step process that uses the Chronology Template which is built into the product.  Here’s how:

  1. From your timeline click on the Change button on the Office Timeline ribbon and select the Chronology Table. This will insert a new PowerPoint slide with Milestone and Task data in table format. From there cut and paste the tables into Excel.
  2. From there cut and paste the tables from PowerPoint to Excel.

Importing (requires Office Timeline Plus edition)

If you built your project in Excel or have exported from Office Timeline to Excel, it is simple to paste your project schedule into Office Timeline Plus Edition. Make sure your Excel table columns are formatted to:

  • Milestone Table = Date, Milestone Title
  • Task Table = Start Date, End Date, Task Description

If you need to create space between your milestones after pasting your table please see Re-position Project Milestones To Create Space.

As Office Timeline iterates quickly, expect to see significant data integration enhancements with Excel and other project tools.

Are you running the latest version?  Check our Release Update site here.

blog comments powered by Disqus