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
| Column | What it means |
|---|---|
| decided_date | The date the council approved the application |
| start_date | When the application was first made |
| authority | The council that decided it |
| address, postcode | The site of the work |
| description | The council's own description of the work |
| app_type, app_size | The kind of application (e.g. householder) and the council's size band |
| status, decision | Where the application stands; the decision made |
| agent_company | The agent or architect on the application, where the council lists one |
| tags | Our labels for the kind of work (extension, loft, roof works and so on), separated by | |
| confidence | How sure our automatic checks are that it needs scaffold |
| council_url | A link back to the council's own record |
| lat, lng | Map 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