If you run a store with real order volume, you already know the export button is the easy part. The hard part is that the file you get back answers a different question than the one you have. This guide covers the exact steps, then the gap every other walkthrough skips — turning an export into a profit number you can act on.
How to export a Shopify report (the exact steps)
The flow is the same for every standard report. Shopify saves the file to your device's default downloads folder, and there is no documented size cap or frequency limit, according to Shopify's export documentation.
On desktop
- From your Shopify admin, go to Analytics → Reports.
- Click the report you want (for example, Sales over time, or Sales by product).
- Click the Export button (on some reports it sits behind the "⋯" menu).
- In the Export dialog, choose your file format.
- Click Export and wait for the download.
For the legacy Sales, Taxes, and Payments reports, the dialog adds a choice between Current page (only the columns on screen) and Full report (every column, including ones hidden by default). Pick Full report — the hidden columns are usually the ones you need for reconciliation.
On mobile (Shopify app)
Tap the Menu icon, open the Analytics section, tap the down arrow, then Reports. Open your report, tap Export, choose a format, and tap Export again. The file saves through your phone's normal download handler.
Exporting a report to PDF
Shopify has no native PDF export. To get one, print the report and save to PDF instead — Windows and Mac both let you "print to PDF" straight from the browser, as Shopify's docs note. Use this for a clean snapshot to email an accountant, not for anything you plan to re-analyze.
What file format should you export?
Match the format to what you'll do next, not to habit:
- CSV — the default. Opens in Excel, Google Sheets, or Numbers. Right for almost everything a seller does by hand.
- XML / JSONL — structured formats for feeding another app or script.
- Apache Parquet (.parquet) — a compressed columnar format built for large datasets and data-warehouse tools, listed among Shopify's supported formats.
If you're going to open it in a spreadsheet and eyeball it, use CSV. The others only pay off when a tool is reading the file, not a person.
What the export actually contains — and what it leaves out
Here is where every generic tutorial stops and your real problem starts. A Shopify sales export gives you revenue, discounts, taxes, and order counts. It does not contain two numbers that decide whether you made money:
- Cost of goods. Your blank, print, and base fulfillment cost live in Printify, Printful, or Gelato — not in Shopify. The export has no idea what each shirt cost to make.
- Ad spend. Your Meta and Google spend lives in those ad platforms. Shopify's report shows the sale but not the dollars you paid to win it.
So the exported "Sales over time" report tells you the top line looks healthy while staying completely silent on the bottom line. For a deeper look at closing that gap inside Shopify's own tooling, see our guide to getting better reports out of Shopify.
A worked example: why the export hides your real profit
Say you run a POD apparel store doing 520 orders a month at a $38 average order value, with $4,100 in monthly Meta spend. Your exported sales report proudly shows $19,760 in revenue. Feels like a good month.
Now rebuild it per order with the numbers Shopify never exports:
| Line | Per order | Where it lives |
|---|---|---|
| Revenue | $38.00 | Shopify |
| − Product cost (blank + print) | −$15.50 | Printify / Printful |
| − Shipping | −$4.50 | Supplier invoice |
| − Payment processing (~3% + fee) | −$1.14 | Checkout |
| − Pick/pack | −$1.00 | Ops |
| = Contribution before ads | $15.86 | — |
| − Ad spend ($4,100 ÷ 520) | −$7.88 | Meta |
| = Profit per order | $7.98 | — |
That $7.98 per order is the number that matters, and nothing in your Shopify export shows it. Across 520 orders it's roughly $4,150 in contribution before fixed costs — a very different story than the $19,760 top line. The arithmetic is simple; the problem is that the inputs sit in four different tools, and the export only hands you one of them. To go further on turning raw exports into operating decisions, our primer on ecommerce business intelligence is the hub for this whole topic.
Exporting on a schedule (and the manual-export trap)
Shopify's native export is a one-off, manual download. There's no built-in "email me this CSV every Monday." For an operator, that creates a predictable failure mode: the export only happens when you remember to do it, and the analysis only happens when you have an hour free.
The workarounds people reach for are all partial:
- Third-party report apps can schedule CSV emails, but most still only read Shopify data — they don't pull your supplier costs or ad spend, so you're back to a revenue-only file.
- Manual spreadsheets combine the sources, but you re-stitch them by hand every week, and one wrong refund or a missed refunded line throws the whole sheet off. (Refunds are their own trap — see how Shopify reports handle refunded products.)
- Data-warehouse pipelines solve it properly but are overkill for most independent stores.
The real job isn't "export a file." It's "get the right numbers, joined together, on a cadence, without me babysitting it."
How Victor handles this for operators
PodVector AI's Victor is an AI employee that works across your live data — Shopify, Meta Ads, Google Ads, Printify, Printful, Gelato, and Klaviyo — so the four sources from the worked example above are already joined. Victor computes true per-order profit, which is the exact number the raw Shopify export leaves out.
When you want that as a file, Victor delivers reports straight to your Google Drive, so the "export" is already done and already profit-aware — no manual download, no re-stitching. Every write action Victor takes is approval-gated, so you stay in control of anything that changes. Victor is not a dashboard you log into; it's an employee that does the work and hands you the result.
If you want to see your real per-order profit instead of a revenue-only CSV, start with PodVector AI. For the bigger picture on measuring store health beyond a single export, read our guide to ecommerce performance analytics.
FAQs
Where do exported Shopify reports get saved?
They download to your device's default downloads folder, per Shopify's documentation. From there you open the CSV in a spreadsheet program like Excel, Google Sheets, or Numbers, or a text editor for the structured formats.
Can I export Shopify reports to Excel directly?
Not as a native .xlsx file. Export as CSV, then open or import that CSV into Excel or Google Sheets — the spreadsheet handles the conversion. CSV is the right choice any time a person, not a tool, will read the file.
Can I schedule Shopify report exports automatically?
Shopify's built-in export is manual only — there's no native scheduled export. You can approximate one with a third-party report app, but most of those read only Shopify data, so the scheduled file still won't include your supplier costs or ad spend.
Why doesn't my exported report show profit?
Because the two biggest cost lines don't live in Shopify. Your cost of goods sits with your print provider and your ad spend sits in Meta and Google, so a Shopify export can only ever show revenue and order-level fees. You have to join those sources yourself to get a real profit figure — which is exactly the gap covered in our walkthrough of visitors by landing page reports and the rest of the reporting cluster.
Which reports can I actually export?
Most standard reports support export, but which reports you can even see depends on your Shopify plan, as Shopify's reporting docs explain. Higher plans unlock more detailed and custom reports; lower plans expose a narrower set.
What's the difference between "Current page" and "Full report" on export?
On the legacy Sales, Taxes, and Payments reports, Current page exports only the columns currently on screen, while Full report includes additional columns hidden by default. Choose Full report when you're reconciling or doing profit math — the hidden columns are usually the ones you're missing.