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 Work Package with data about the items that are being assessed.



  1. Click on the 'Work Packages' link in the Left Menu to show the Work Package List.

  2. Then click on the Work Package name to open it.


Now choose the file to import, go to the “Import inspections from csv”. This is located in the Dashboard as shown below.



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

    • The Work Package Dashboard

      The Dashboard provides a central view of multiple different aspects of the Work Package. Click here to go to Dashboard page Keeps track of inspection that have been completed in the last 14 days Keeps track of how many inspections are in the various ...

    • 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 ...