To export all your Simpro data, connect Simpro to TradieBridge and choose an export: CSV for spreadsheets, JSON for developers, or Postgres for a database. You get one zip with every job, quote, invoice, customer, site, stock item and timesheet that TradieBridge holds.
Why Simpro is hard to export in full
Simpro’s own exports are lists and reports, one at a time. Each is a snapshot of one screen, and many leave out the detail inside a job, such as cost centres, labour and notes. The Simpro API has all of it, but you must page through each endpoint, follow every job into its sections and cost centres, and stay under the rate limits.
How the export works
- Connect Simpro to TradieBridge with an API key from your Simpro administrator. TradieBridge only reads.
- TradieBridge copies 88 Simpro resources and keeps them current.
- Open the Simpro connection, choose Spreadsheets, Documents or Postgres, and press Email me the zip. The emailed link works for 7 days.
TradieBridge reads every table from one snapshot, so the files agree with each other. A job never points at a cost centre that the export missed.
Three formats
- Spreadsheets: one .csv file for each resource, with the searchable columns of each record. Open them in Excel or Google Sheets.
- Documents: every record exactly as Simpro sent it, in .ndjson files, for developers.
- Postgres: one .sql file that loads into any Postgres database or Supabase, in a
simpro_backupschema.
Query Simpro with SQL
The ten completed jobs that made the least money:
SELECT data ->> 'Name' AS job,
data -> 'Customer' ->> 'CompanyName' AS customer,
NULLIF(data -> 'Totals' -> 'GrossProfitLoss' ->> 'Actual', '')::numeric AS profit
FROM simpro_backup.simpro_jobs
WHERE data ->> 'Stage' = 'Complete'
ORDER BY profit
LIMIT 10; If you would rather ask than write SQL, connect Claude, ChatGPT or Copilot to the same copy and ask in plain English.
Keep it after you leave
The copy stays browsable and exportable even after you cancel TradieBridge. If you are moving off Simpro, read what happens to your data if you leave Simpro, and see Simpro backup for how deleted records stay in your copy.
Docs Every Simpro resource TradieBridge holds