Articles on: Checklists

Bulk import and updating of checklists with Excel

CxPlanner provides seamless bi-directional synchronization with Excel spreadsheets. This makes it very easy to input data into the platform upfront and update it during the project.


For working with import/export functionality you just need to use CxPlanner's spreadsheet template - more info on that in this article.


Bulk import menu


To access the "Bulk-import" area and upload a file just follow the two (2) screenshots below. Be sure to read the whole article on the format requirements before uploading a file.


You must be either a Manager or Admin on the project


Access the menu

Access the import area


Upload the file

Bulk upload


The spreadsheet template


To import you need to use CxPlanner's spreadsheet template. You can download it during the import process (see the picture above) or just click on the Menu-button and select download overview.


This spreadsheet includes many different options and utilities for you. But the three (3) core items you must know are:

Column

Required

Must have data

Info

ID

True

False

The ID column holds a unique reference to the item inside CxPlanner. That means, if you update this row and re-import the spreadsheet we will update the item for you inside CxPlanner. If there's no value present in the ID-column we will create a new item inside CxPlanner. Be careful not to have duplicates!

Sub

True

False

The "sub"-column indicates the indentation level of the item - it is this field which is used to build up the tree structure. There must always be at least one (1) root-folder which is empty. Build the tree structure with simple "X"s; just put an additional X to create a sub-item.

Asset

True

True

This is the name of the equipment or system. This column must always have data.


Adding new items

Keep the ID-column empty


Updating existing items

The ID-column must include the ID reference (auto generated)


Deleting items

It is not possible to delete items using the import function.


Example of the spreadsheet template


If there's an ID-number i column A ("ID"), then when importing the spreadsheet, CxPlanner will try to find that checklist and update it with any changes.


When you insert an X in column B ("Sub"), the line will automatically be an indent to the checklist above - except if the line above has the same amount of X's.


You cannot delete checklists by deleting lines in the spreadsheet. Don't worry.


If you change some text, or move a row, then that will be reflected in CxPlanner.


Import spreadsheet




Updating existing data

To update existing data export the overview and start update the data. You can modify names, categories, assign templates etc. The only requirement is that you don't change the ID in the first column.


It is also possible to rearrange/move equipment around; just remember to align the X's in the Sub-column.



Updated on: 04/07/2025

Was this article helpful?

Share your feedback

Cancel

Thank you!