How do I export Shopify orders for a date range?

Updated 2026-10-21. Checked against Shopify's own documentation; links are under Sources.

Go to Orders › Export, choose Orders by date, set the start and end dates, and click Export orders. For an export by date, Shopify emails you the CSV rather than downloading it straight away.

Step by step

1. In your Shopify admin, go to Orders.
2. Optional: sort and filter the list first. Shopify's help suggests this so the export includes just the orders you need.
3. Click Export.
4. Choose what to export:
   • Current page, or up to 50 orders: downloads straight away.
   • Orders by date: set a start date and an end date.
5. Choose the content:
   • Export orders: all order data. An order with several items takes several rows, one per line item.
   • Export transaction histories: the payment transactions, for reconciling payouts.
6. Choose the file format (CSV for Excel, Numbers and similar, or plain CSV) and click Export orders.

Why the file came by email

Shopify's help: "If you select to export more than 51 orders or to export orders by date, then the CSV file is emailed to you." The email goes to the account that requested the export. If it doesn't arrive, check spam and wait a few minutes, because large exports take longer.

Opening it in Excel without breaking it

Double-clicking a CSV lets Excel guess each column's type, and some guesses damage the data:

• Leading zeros disappear from postcodes, phone numbers and barcodes.
• Long numbers such as barcodes turn into scientific notation (3.6E+11), and the digits are lost once you save.
• Dates can switch between day-month and month-day order depending on your computer's region settings.

To avoid this, import the file rather than opening it: in Excel, use Data › From Text/CSV and set the sensitive columns to Text before loading. Google Sheets has a similar option under File › Import, where you turn off automatic conversion. Don't save over the original export, so you always have a clean copy. More on keeping leading zeros.

Check the numbers

• Order exports have one row per line item, so the row count is higher than the order count. Count unique order names to get the number of orders.
• An order with several items spans several rows, so to total sales or shipping, count each order once (by its order number) and don't add up every row.
• Dates follow your store's time zone settings. If a period looks off by a few orders, check orders placed near midnight.
• Compare with the Orders list filtered to the same dates before you send the file to anyone.

Picking useful date ranges

• Monthly bookkeeping: the first to the last day of the month, exported after the month ends, so late orders aren't missed.
• Weekly warehouse or partner reports: pick fixed weekdays (for example, Monday to Sunday) and stick with them, so no week overlaps or leaves a gap.
• Reconciling payouts: use Export transaction histories for the same dates. Payments, refunds and adjustments appear there as transactions, not as order lines.

Doing this every week or month

Shopify's help page on exporting orders doesn't describe a way to schedule the export, so a repeating export is a manual job. To take the clicks out of it, you can:

• Use Shopify Flow to email order details as text on a schedule. It can't attach a file, and each Get order data action returns up to 100 orders. How, and where it runs out.
• Use an app that builds the file and emails it on a schedule.