Import from Smartsheet

Online Help > Import from Smartsheet

If you started your project in Smartsheet but need to manage more complex schedules, resource sharing, and tracking, you’re probably ready to move your data into Project Plan 365. You can do this by using the Import from Smartsheet functionality.

The first step you should do is make sure you exported your work from Smartsheet into Excel or XML format. After this you can follow these easy steps to import your data into Project Plan 365.

  1. In Project, click File -> Import/Export
  2. In the Import/Export click Import Files and then select Import from Smartsheet
  3. In the Open dialog which appears you can either select Excel Workbook (.xlsx) or XML Format (.xml) depending on the format you have exported from Smartsheet.

If you chose to import an Excel file then an import wizard will appear. This wizard will guide you through the steps you need to make in order to import your data.

If you chose to import a XML file then the file will be automatically opened in Project Plan 365 so you can start to edit your project right away.

This wizard allows you to make some project related settings before mapping the Smartsheet fields to the ones in Project Plan and obtaining the final project.

In the first window you must:

  • Select if the import will be bringing the data in a new file or append to the existing open file.
    • If you select “As a New Project” a new file will be opened using default option settings and default blank project file.
    • If you select “Append the data to the active project” the imported data will be placed at the end of the currently opened file.
  • Select if you want Saturday and Sunday to be working days (Weekend days are working option).
  • Select if the data will be directed towards Tasks or Resources. (One or all may be selected)
  • Select if the imported file has column headers.
    • If there are column headers in the Excel file this information will be used to match field names from the import file to field names in the Project Plan file. The header row will not be considered valid content data and will not be imported.
    • If the imported data does not contain headers, column positioning will be matched with the fields on the import map.

After making these settings you can advance to the next step by pressing the Next button.

  • Select the source worksheet
    • By default, the data will be imported from the first sheet of the Excel file. If your data lies in another sheet you can select its name from the Source worksheet control;
  • The left side of the view will have the fields in the imported Excel file.  You can select field values on the right side of the view to map the Excel values to the Project Plan 365 fields on the right

After you are finished with the mapping of the fields you can press Finish to start the import and create your project.

During the import process data might have been imported to columns that are not being shown on the currently viewed table.  After the import is completed you can insert imported columns into any table to view the imported data.

Export to Excel

You can also export data from Project Plan 365 to Excel  for data analysis, visual reporting and viewing the project you created in tools like Smartsheet.