Exporting reports
You can export your reports to a different file format from your Shopify admin. Exported reports are saved in the default downloads folder on your device. After the download is complete, you can open the report using a spreadsheet program, such as Excel or Numbers, or a text editor.
You can export most reports in any of the following file formats:
- Comma Separated Values (CSV)
- Extensible Markup Language (XML)
- JSON Lines (JSONL)
- Apache Parquet (
.parquet
)
For some of the legacy Finances reports (Sales, Taxes, and Payments), the default file format is a CSV, but you can select the type of report to export:
- Current page exports data for the columns that are currently displayed.
- Full report exports data for all the displayed columns, but includes additional columns that aren't displayed by default.
If you want a PDF file of a report, then you can print the report instead of exporting.
On this page
Export a report
You can export a report to your device. Exported report files are saved in your default downloads folder.
Steps:
Desktop
From your Shopify admin, go to Analytics > Reports.
Click the report that you want to export.
Click … > ↥ Export.
If available, in the Export report dialog, select the file format that you want to use.
Click Export.
iPhone
- From the Shopify app, tap the … button, and then tap Analytics.
- Tap Reports.
- Tap the report that you want to export.
- Tap … > Export.
- If available, in the Export report dialog, select the file format that you want to use.
- Tap Export.
Android
- From the Shopify app, tap the ☰ button, and then tap Analytics.
- Tap Reports.
- Tap the report that you want to export.
- Tap ⋮ > Export.
- If available, in the Export report dialog, select the file format that you want to use.
- Tap Export.
Print a report
To export a report to a PDF file, you can print the report instead of exporting it.
On a device that uses Windows 10 or higher, or on a Mac, you can automatically save to PDF when printing. For earlier versions of Windows, you need to install a PDF printer or converter, such as Adobe Acrobat Reader.
Steps:
Desktop
From your Shopify admin, go to Analytics > Reports.
Click the report that you want to export.
Click … > Print.
In the Print dialog, set your preferred printing settings.
Click Save or Print.
iPhone
- From the Shopify app, tap the … button, and then tap Analytics.
- Tap Reports.
- Tap the report that you want to export.
- Tap … > Print.
- In the Print dialog, set your preferred printing settings.
- Tap Save or Print.
Android
- From the Shopify app, tap the ☰ button, and then tap Analytics.
- Tap Reports.
- Tap the report that you want to export.
- Tap ⋮ > Print.
- In the Print dialog, set your preferred printing settings.
- Tap Save or Print.