Skip the manual navigation

Export analytics data to CSV

Download any report in the library, the dashboard's breakdown tables, and the Landed costs report as CSV files for spreadsheets or accounting.

3 min read · Updated October 2, 2026 · Screenshots use demonstration accounts

On this page
  1. 1. Set the date range first
  2. 2. Export a report from the library
  3. 3. Export a dashboard breakdown table
  4. 4. Export the Landed costs report
  5. 5. Know what's left out of a money report
  6. 6. Open the file
  7. Completion checklist
  8. Troubleshooting
Before you start

Every live report page under Analytics > Reports has its own Export CSV button, and so do the Analytics dashboard's breakdown tables.

On a phone? Open the admin menu to find the same section. Screenshots below show the desktop view; tap “Open full size” for a closer look.
STEP 1

Set the date range first

A report page's Export CSV button uses whatever date range its own selector is showing — Today, Last 7 days, Last 30 days or Last 90 days. The Analytics dashboard's own exports use the dashboard's separate date picker (Today, Last 7/30/90 days, Last 12 months, or a custom range). Days are counted in your store's configured time zone (Settings > General), not UTC. Cancelled orders are left out of every export.

  • Today
  • Last 7 days
  • Last 30 days
  • Last 90 days
STEP 2

Export a report from the library

Open any of the 33 reports under Analytics > Reports and click Export CSV at the top of the page. It downloads the same rows the table on screen is showing, for the date range you've selected — not capped at 10 rows the way the dashboard's breakdown cards are.

STEP 3

Export a dashboard breakdown table

On Analytics, each breakdown card (Top products, Top collections, Sales by channel, Top discounts, New vs returning customers) has an Export CSV button. It downloads that table for the dashboard's current date range, up to the 10 rows shown on screen. Money columns come as a whole-cents value plus a decimal value: for example, Revenue (cents) and Revenue ($). The decimal column holds the amount in your store's currency, even though its heading shows $.

STEP 4

Export the Landed costs report

On Analytics > Reports > Landed costs by destination, click Export CSV at the top right. It downloads the data for the country you've selected, or all countries if you haven't picked one.

STEP 5

Know what's left out of a money report

An order placed in another currency without a saved exchange rate is left out of a money report rather than added at face value — the page tells you under the table how many orders were excluded and why. A report that doesn't read order money (for example a sessions report) never shows this note.

STEP 6

Open the file

Downloaded CSVs open directly in Excel, Google Sheets, or Numbers. Money values export as plain numbers (not pre-formatted currency) so they can be used directly in spreadsheet formulas.

CHECK YOUR WORK

You’re ready when…

  • Set the date range (or country filter, for Landed costs) you want before exporting
  • Downloaded the CSV and confirmed the row count matches what you expected
  • Checked the excluded-orders note on a money report before trusting its total

IF SOMETHING DOESN’T LOOK RIGHT

Troubleshooting

Can I export the full Reports catalog, or just the dashboard breakdowns?

Both. Every report under Analytics > Reports that shows live data — all 33 on the generic report page, plus Landed costs by destination — has its own Export CSV button today, as well as the dashboard's breakdown tables.

Can I schedule a CSV to be emailed to me automatically?

No — every export in Lulu is an on-demand download; there's no scheduled or emailed export.

Why does my exported file only have 10 rows?

That's only true of the Analytics dashboard's breakdown cards, which are capped at the 10 rows shown on screen. A report opened under Analytics > Reports exports every row for the date range you picked, not just what's visible. The Landed costs export isn't row-limited either.

A report's export seems to be missing some orders.

Check the note under the table — an order placed in a currency the store has no saved exchange rate for is left out of money reports rather than guessed at. It's counted in the note, not silently dropped.

In this section: Reports

Still need help?

Tell us your store address and what you’re trying to do. Leave out passwords and payment details.

Contact support