Download your records and files
How do I get my records or files out as a spreadsheet or a ZIP?
- For
- Owners, admins and accounts
- Where to find it
- Reports for recordsPlan & billing for files
- Takes
- A few minutes
- You need
- Permission to see what you are exporting
What it is for
Reports export records as a spreadsheet or PDF. The file export downloads job and quote attachments. They cover different things, so a file ZIP is not a backup of all your customer and accounting records.
After this you can
- Download any report as CSV, Excel or PDF
- Download materials, items or timesheets
- Download your job and quote files as a ZIP
Downloading from the report builder
- 1What to report onThe kind of record: quotes, jobs, invoices and the rest.
- 2Fields to showTick the columns you want in the download.
- 3Download CSV, Excel and PDFDownloads what the report shows, in the format you pick.
Step by step
- 1
For records
Go to Reports and press New report. Choose the source, fields, dates and filters, and check the results.
- 2
Download it
Press Download CSV, Excel or PDF.
- 3
For materials or items
Open the list under Catalogue, tick the rows and press Download CSV.
- 4
For files
Go to Settings, then Plan & billing, and press Export files under Your data.
- 5
Collect the ZIP
Come back when it says Ready and press Download ZIP.
In a report
| Part | What it does |
|---|---|
| Download CSV, Excel, PDF | Downloads every matching row, not just the 500 on screen: up to 100,000 in CSV or Excel, or the first 2,000 in a PDF. A file that hit the limit says so in its name; narrow the dates or filters to get the rest. |
| Left out because your permissions hide them | Cost, margin and buy-price fields you can't see are left out of the screen and the download. |
On the Items and Materials lists
| Part | What it does |
|---|---|
| Tick rows, Download CSV | Tick the rows you want and a bar appears above the list with Download CSV. |
Your data, on Plan & billing
| Part | What it does |
|---|---|
| Export files | Starts a ZIP of every job and quote file, up to 500 MB. Needs File sync on your plan and shop admin or Sign OS Sync permission; without it you can see past exports but not start one. |
| Queued, Building ZIP…, Ready, Export failed, Expired | Where the export is up to. You can leave and come back; an email with a link back here is also tried. |
| Download ZIP | Shown when it's Ready. Once the link expires, request a new export. |
Watch out
The screen shows 500 rows. CSV and Excel hold up to 100,000, and a PDF the first 2,000. Split a bigger report by dates or filters.
The file ZIP is up to 500 MB.
Your permissions control which records and money fields you can export.
