Importing Data into a Clarinspect Work Package

Importing Data into a Clarinspect Work Package

Any images displayed are representative only and may differ depending on the version being used.

Preparing the data in a spreadsheet

You will need to set up a spreadsheet with the right headers. Specifying text for text fields is easy, but if you want to load a specific value into a drop down you will need to know the lookup used. Ask Clarinspect for the lookups for drop down lists etc.


To get the headers, create a dummy inspection in the Hub of the type you want to load, then export it as xlsx. (For more information on how to export data please read Exporting Data from the Hub).


When you open this you will see two two rows of headers - one for humans to read and one for computers. Row 2 are the field names the software uses.


This is what the output will look like:









1. DELETE ROW 1

2. You can also safely delete columns A → J (unless you are planning on doing a bulk edit, in which case please read Bulk Editing through Importing).

3. Add in the data to the relevant columns that you are wanting to import.



GPS Fields : when loading GPS data from excel you need to ensure it is in the format shown below; "latitude,longitude". No spaces and only decimal numbers separated by a comma. There is a single comma in the middle separating the latitude and longitude coordinates. It can have a negative at the front of a number and the decimal point is fine too.


For example: -38.337244,176.391744


Date and Time Fields: These needed to be loaded as YYYY-MM-DD and HH:MM:SS

Save in a format for loading

Save the file as an .xlsx (for your records) and also as a CSV UTF-8 (this is what you will be importing back into the hub). 


Importing the data

You can pre-load your Workpackage with data about the items that are being assessed.



  1. Click on the 'Workpackages' link in the Left Menu to show the Workpackage List.

  2. Then click on the Workpackage name to open it.


Now choose the file to import, go to the “Import inspections from csv” on the lower right side of the screen.


If you have more than one type of inspection on your Work Package you will need to choose which type you are loading the data into. Click on the drop down list (for example,  “Bridge Inspection v0.1” in the image below) to select the template format you want to import. The CSV file and the assessment template need to be appropriate for the target template you are trying to load.



  1. Click on the 'Choose File' button and browse to a file with the data for the specified system to load.

  2. Click on the 'Import' button only when you have chosen a file to load.


Note: The loading of data is done in the background, and you will be notified by email when it has finished. The 'Import' button is only enabled if you have chosen a File.You can repeat this for each template on the workpackage if you have many assigned.


    • Related Articles

    • Bulk Editing Through Importing

      Any images displayed are representative only and may differ depending on the version being used. You may want to bulk edit a number of inspections within a Work Package. You will first need to export your data. Instructions can be found here: ...

    • Exporting Data from the Hub

      Any images displayed are representative only and may differ depending on the version being used. This brief guide is to step you through exporting data out of the hub. You can export your data as a .zip file with all photos and data, or as a .xlsx ...

    • Importing Data into Sub Forms

      Any images displayed are representative only and may differ depending on the version being used. To add a new sub-form into an inspection from Excel you need to follow the following steps. Preparing the data in a spreadsheet To get a spreadsheet with ...

    • Different Branding on a Work Package

      Any images displayed are representative only and may differ depending on the version being used. For special projects or key clients, you can swap out your usual logo and load in a different one—right inside the work package. It’s a simple way to ...

    • Work Package Summary Reports

      Any images displayed are representative only and may differ depending on the version being used. Work Package Summary Reports are intended to produce a report for a collection of inspections in a Work Package. You could use these reports to meet ...