Export Reports to CSV
How to export any report to a CSV file for offline analysis, accountant reviews, or archival purposes.
How to export any report to a CSV file for offline analysis, accountant reviews, or archival purposes.
This guide walks you through exporting report data to CSV files. You will learn how to set filters before exporting, where the file downloads to, and how to use the exported data in spreadsheet applications.
Before exporting, configure the report to show exactly the data you need:
Screenshot: A report page with date range set to Last Month and a status filter applied, ready for export.
The file is named with the report type and date range, for example
revenue-report-2026-03-01-to-2026-03-31.csv.
Open the downloaded file in Excel, Google Sheets, Numbers, or any spreadsheet application. The CSV includes column headers matching the report table.
Animation: Opening the exported CSV in Google Sheets showing columns for invoice number, customer, amount, status, and date.
A spreadsheet treats a cell that starts with =, +, - or @ as a
formula. Some of your data can start that way, for example a customer name
typed as =Acme or a phone number written as +1 (512) 555-0100.
To keep that text from running as a formula, the export puts an apostrophe
in front of it. Excel and Google Sheets show the text and hide the
apostrophe. Numbers are not changed: a negative amount such as -142.50
stays a number you can sum.
This applies to every CSV you download from JobsiteOn.
Tip: Schedule a monthly routine to export the previous month's data. This creates a financial archive you can reference during tax season or business reviews.
The active filters have no matching data. Widen the date range or remove filters and try again.
Some versions of Excel treat CSV values as text. Use Excel's Text to Columns feature or import the file using the Data Import wizard to set the correct column types.
Did this answer your question?