Import your MS Project plan into Office Timeline Online

Follow

MS-Project-Sample-for-Importing.png

Overview

Office Timeline Online lets you import your MS Project data and instantly turn it into a beautiful, easy-to understand visual that you can customize and update with just a few clicks. Here we'll show you exactly how it works. You'll find out:

 

A) How to bring your Project data into Office Timeline Online
B) How to map your data for importing
C) How to select specific tasks and milestones to import

 

Read the whole guide to learn the ins and outs of importing from Microsoft Project, or use the links above to go straight to the chapter you're interested in.

 

A) Bring your Project data into Office Timeline Online 

For a successful import, Office Timeline Online needs from your Project file your tasks' Titles (Names), Start Dates, End Dates and Duration (& Complete and Notes are also importable, but they are optional). Below you can see a plan sample in Microsoft Project, which we will use to demonstrate how importing works.

ms-project-example.png

Note: To properly identify your milestones both in Project and in Office Timeline Online, make sure that they are set to have a duration of 0 days or that they are specifically marked as Milestones in your .mpp file.

Once you have your plan all set up in Microsoft Project, it's time to upload it into the online timeline maker:

  1. From the New tab in Office Timeline online, click on Import data and then choose Import from Project from the window that pops up.

    import-from-ms-project-into-office-timeline-online.png

  2. Then, browse to your .mpp file or just drag it into the web tool to go to the next step.

    upload-project-file.png

 

B) Map your data for importing

  1. After loading your .mpp file, Office Timeline should automatically map the Title, Start Date and End Date columns detected in your data, which it will use to generate your graphic. In addition, it will also bring in your % Complete or Notes columns from Project.

    columns-mapped-automatically-project-import.png

  2. If, by any chance, your data wasn't labeled correctly or if you'd like to use other columns from your Project file, now is the time to re-map the data by dragging & dropping the green labels to the desired column headers.

    drag-to-remap-columns-project-import.gif

    Quick tip: If you'd like to leave the % Complete or the Notes column out, simply drag its label out of the table or click on the little X on it.  Office Timeline will ignore it when importing your data.
    remove-mapped-columns-project-import.gif

  3. Before moving forward, you can also choose to hide unmapped columns, switch between US and International date formats, or pick another file to import. Once done, click next to go to the next step.

    other-options-map-columns-tab-project-import.png

 

C) Select which rows to import

After you finish mapping columns, you'll get to the Select Rows view, where you'll see all importable rows from your original file already marked for import.

select-rows-view.png

Here you can double-check your data and choose exactly which tasks and milestones to import and which to leave behind. As you can see below, Office Timeline Online lets you select or deselect individual items or entire categories by clicking their corresponding checkboxes. In addition, you also have the option to import 1-day tasks as milestones.

check-uncheck-items-import-tasks-as-milestones.png

Quick tips:

  • If you have a complex plan in MS Project, we'd recommend importing only the most important tasks and milestones (or the summary tasks) to ensure you get a clean timeline that's easy to follow.

  • For plans that contain summary tasks with subtasks, you can quickly deselect a whole group by unchecking the summary task. If you wish to uncheck just the summary task but keep its subtasks, hold control while clicking its checkbox.

Once happy with the data you want to import, click the green Import button, and our web tool will instantly generate your timeline, which you can then edit and style as you wish.

timeline-made-from-imported-project-data.png

Quick tip: Whenever your MS Project data changes, you can easily synchronize your timeline with the source .mpp file. Just follow these simple steps.

If you encounter any issues or need assistance importing your Project data into Office Timeline Online, please submit a ticket by clicking the green button at the bottom of the page. We'll be happy to help!

Have more questions? Submit a request

Comments