Import your Smartsheet data into Office Timeline online

Follow

Overview

We do not currently support importing data from Smartsheet directly into Office Timeline Online. However, there is a simple workaround you can use to quickly turn your Smartsheet plan into an impressive Gantt chart: first export the data to Excel, and then import it from Excel into the online timeline maker. Here’s how:

Steps

  1. Export your data from Smartsheet to Excel.

    Screenshot_1.png

  2. Open the resulting Excel file, enable editing if prompted, and save it. This is an essential step to ensure the data is read correctly when importing into Office Timeline.

    Screenshot_2.png

    Note: If your Smartsheet plan contains any milestones, you will want to delete their Start Dates or End Dates from the exported Excel sheet. Otherwise, Office Timeline Online will import them as 1-day tasks because, in the online timeline maker, milestones have only a single date attached to them.Screenshot_3.png

  3. Import the Excel file into Office Timeline Online to turn your Smartsheet plan into an impressive timeline.

    import-smartsheet-data-office-timeline-online.png

If you need any assistance when importing Smartsheet data into our online timeline maker, please don’t hesitate to contact us by clicking the “Submit a ticket” button at the bottom of the page. Our responsive support team will come to your aid ASAP.

 

Have more questions? Submit a request

Comments