Can I bulk-import lots of certificates at once?

Getting Started & On-Boarding

Yes, you can bulk import properties and their certificate data using our CSV template. This is the fastest way to add multiple properties and their compliance records to CertNudge.

How the Two-Stage Import Process Works

Important Distinction

The import process is in two stages. First, you import the data (property names, addresses, certificate dates) from the spreadsheet. Afterwards, you can optionally upload the actual files (PDFs, images) to the certificate records that were created.

Stage 1: Importing Your Property & Certificate Data

1
Download the Template

From the "My Properties" page, click the "Import Properties" button and download the official CSV template.

2
Fill in Your Data

Open the template in a spreadsheet program (like Excel or Google Sheets) and fill in the details for your properties and their certificates.

3
Upload the File

Return to the "Import Properties" page, select your completed CSV file, and begin the import. The system will validate your data.

Stage 2: Attaching Certificate Documents (Optional)

4
Navigate to a Certificate

After the import, find one of the newly created certificates on your dashboard or its property details page.

5
Upload the Document

On the certificate's "Edit" page, use the "Document Management" section to upload the corresponding PDF or image file.

Template Column Guide

Required Fields
Property Name

A unique, easy-to-remember name for the property.

Address Line 1

The first line of the property's street address.

City

The city or town where the property is located.

Postcode

The property's full postcode.

Certificate Name

The name of the certificate (e.g., "Annual Gas Safety Check").

Certificate Type

The type of certificate. Must match an existing type in CertNudge (e.g., "Gas Safety", "EPC").

Issue Date

The date the certificate was issued, in dd/mm/yyyy format.

Expiry Date

The date the certificate expires, in dd/mm/yyyy format.

Optional Fields
Address Line 2

The second line of the address (e.g., apartment number).

Supplier Name

The name of the contractor or company who issued the certificate.

Reference Number

Any unique reference number on the certificate.

Next:

Pro Tips for a Smooth Import

  • Do not change the column headers in the template file.
  • Ensure all dates are in the required `dd/mm/yyyy` format.
  • If a `PropertyName` in your file does not already exist, a new property will be created.
  • For your first import, try uploading a file with just 2-3 rows to ensure your data is formatted correctly.
Was this helpful?
Share this FAQ