Importing or updating data using MS Excel

Download the template

Adding new work items

To add a new work item:

  1. In the Work Plan, via the gear, add the Parent field to the Work Plan.
  2. Export the Work Plan to MS Excel in Work Plan > Utilities > Download to Excel.
  3. Update the data as necessary. For new work items, specify a parent for the new work item.
  4. Import the data back to Clarizen. To learn more how to import data and make inline data updates, refer to Import from Excel.

Updating existing work items

To update an existing work item:

  1. In the Work Plan, via the gear, add the ID field to the Work Plan.
    Note: If the ID field is not added prior to export, work items without an ID are added as new work items.
  2. Export the Work Plan to MS Excel in Work Plan > Utilities > Download to Excel.
  3. Update the data as necessary.
  4. Import the data back to Clarizen. To learn more how to import data and make inline data updates, refer to Import from Excel.

Start the import

  1. In the desired module, click Utilities > the Import
  2. In the Import from Excel pop-up window, click the Upload file button and navigate to the location of your Excel spreadsheet. The data is loaded into the Import from Excel window.

Review and correct invalid data inline

In the Import from Excel window, you can:

  1. View all data. Color-coding is used to identify new vs. updated data. The yellow icon in the Operation column indicates updated records, while the blue icon indicates new records. Use the drop-down list at the top to filter data.



  2. View invalid data and a corresponding error message.



  3. Correct invalid data inline by choosing a value from the drop-down list. Use pagination to review all records.



    Once updated, the data is highlighted in yellow.

 

Have more questions? Submit a request

Comments

  • Avatar
    Chris S.

    Hi, this manual says twice "To learn more how to import data and make inline data updates, refer to Import from Excel." However the link provided doesn't include any instruction. Reading through the manual I experience difficulties to understand how to import a brand new project from Excel and I have the feeling the features works only for the case of an update.

  • Avatar
    Michelle Orellana

    Agreed with Chris. The Import from Excel link is useless as it is of no use. It only takes you to a table of the items you can import to and references to the Clarizen Lab which is no longer applicable. The newest release already includes the ability to import excel spreadsheets. More information is needed to import a new excel sheet to a new project.

Powered by Zendesk