Skip to main content

How do I import sites from a spreadsheet?

Create many sites at once by filling in the Site Import template, uploading the completed file, and checking Import History.

You can add many sites in one go by filling in a spreadsheet and uploading it on the Site Import page. Colobbo records the result in Import History.

Open Site Import from the side menu.

The Site Import page, with Step 1 Download template and Step 2 Choose file circled

The Site Import page. Download the template first, then choose your completed file. Nothing in this picture was uploaded.

Download the template

Select Download template. The template is made for the project you are working in, so it includes every custom field set up for that project.

Download a fresh copy each time. If the custom fields change, an older template can be rejected.

Fill in one row for each site, then save the file.

Choose what happens to existing sites

Before you upload, choose what to do with sites that already exist.

The two options under When a site already exists: Only add new sites, and Add new and update existing

The two options under When a site already exists.

  • Only add new sites is the safe choice. A row whose name already exists in the project is skipped, and nothing is changed.

  • Add new and update existing changes the sites whose names match a row. Only the fields you filled in change. A blank cell leaves the current value alone. This cannot be undone, so check the file first.

Upload the completed file

  1. Select Choose file and pick your completed .xlsx file.

  2. Select Import. The button shows how many sites will be imported.

Select Clear to remove the file and start again.

Check the result in Import History

Each import appears in Import History at the bottom of the page, with its file name, the date it was submitted and its status. The status shows whether the import completed or failed. Select Refresh to update the list.

Each finished import shows its counts, for example "Processed 1 row(s): 0 created, 0 skipped, 0 failed".

Frequently asked questions

Why was my file rejected?

The most common reason is an older template. Download a fresh template and copy your rows into it.

Why were some sites skipped?

Under Only add new sites, any row whose name already exists in the project is skipped.

Related articles

Did this answer your question?