The CSV file: what it is and how to use it

You don't need it. Every approval in your digest is written out in full in the email itself, so you can work straight from your phone. The CSV is an extra for firms that want the same list in a form a computer can use.

What is a CSV?

A CSV is just a plain table saved as a file: one row per approval, one column for each detail (address, postcode, what the job is, the date it was approved). It is the format almost every spreadsheet, CRM and job-management system can read. Each digest has one attached, named like leads-2026-10-30.csv.

If you use a CRM or job-management system

If you use a CRM, quoting software or any system to manage your jobs, you may be able to import this file into it, so the new approvals appear as leads you can follow up and track. Look for a button called Import (often under Leads, Contacts, Customers or Jobs) and choose CSV. The system will ask you to match our columns to its own fields - address to address, postcode to postcode, and so on. Every system is a little different, so if you're unsure, your software's help pages will show the exact steps; the file itself is a standard one.

If you don't use anything like that

That's fine - plenty of firms don't. If you'd like to try the file anyway:

  • Open it in a spreadsheet. Excel, Google Sheets (free) and Apple Numbers all open a CSV by double-clicking it or through File → Open / Import.
  • Sort by postcode to plan a round: group the approvals that are near each other so a morning of door-knocking or leafleting covers as many as possible.
  • Keep a running list. Add a column for "called", "quoted" or "won", and you can see at a glance which approvals you've followed up.
  • Print it. A printed sheet in the van is perfectly good.

What's in each column

ColumnWhat it means
decided_dateThe date the council approved the application
start_dateWhen the application was first made
authorityThe council that decided it
address, postcodeThe site of the work
descriptionThe council's own description of the work
app_type, app_sizeThe kind of application (e.g. householder) and the council's size band
status, decisionWhere the application stands; the decision made
agent_companyThe agent or architect on the application, where the council lists one
tagsOur labels for the kind of work (extension, loft, roof works and so on), separated by |
confidenceHow sure our automatic checks are that it needs scaffold
council_urlA link back to the council's own record
lat, lngMap coordinates, handy for mapping tools

Remember the rules for using leads: door-knocking, letters and business calls are fine; unsolicited email or text messages to individuals are not (see our terms). Our classification is automatic and can be wrong, so check each approval before you quote.

Stuck, or want a column added? hello@scaffsignal.co.uk