- Short answer
- From Orders, click Export: up to 50 orders or the current page download as a CSV; larger or by-date exports arrive by email.
- File formats
- CSV for Excel, Numbers, or other spreadsheet programs, or Plain CSV file
- Rows
- Each extra line item gets its own row, with many order fields left blank
- Transaction history in exports
- Captured payments only, without authorization data, per Shopify's export page
- Scheduled CSV export
- Not described in the export or Flow pages we read, November 2026
Export orders from the Orders page
- Sort and filter the Orders list to the orders you want.
- Click Export.
- Orders
- Under Export, pick the orders. As the dialog showed in November 2026: Current page, All orders, Selected, the orders matching your search, or Orders by date (start and end dates).
- Under Export as, choose CSV for Excel, Numbers, or other spreadsheet programs or Plain CSV file.
- Click Export orders for all order information, or Export transaction histories for transactions only.
- Orders
- Export
Export up to 50 orders or the current page and the CSV downloads to your device. Choose more orders or Orders by date, and Shopify emails the file to you and the store owner; a failed export also sends an email.
Staff need the Export permission under Orders in their store permissions.
What the order CSV file contains
Each line item gets its own row, and many order fields stay blank on the extra rows. The columns Shopify documents include:
- Order and status: Name, Email, Financial Status, Fulfillment Status
- Money: Subtotal, Shipping, Taxes, Total, Discount Code
- Line items: Lineitem quantity, name, price, SKU
- Addresses and notes: Billing and Shipping fields, Notes, Note Attributes, Tags
Discount Code leaves out automatic discounts, and Lineitem compare-at price is historical, from when each order was created.
Shopify says the transaction history in an export holds captured payments only, without authorization data; Export transaction histories gives a separate CSV with columns such as Kind, Gateway, Status and Amount.
Beyond the built-in export
Where to go instead:
- Sales totals for your accountant: the Total sales by order report.
- One payout's transactions: export the payout, not the orders.
- Scheduled exports: Shopify Flow has a Scheduled time trigger, and its page offers a template that emails a daily summary of online-store orders, but as of November 2026 neither Shopify's order-export page nor the Flow trigger and action references we read describe a scheduled CSV export of orders. Matrixify's App Store listing describes scheduled jobs with auto-repeat.
This page was written by AI. Separate AI agents that did not write it check its figures and claims against official sources and test its links and interactive tools. A human editor sets the site's editorial direction, topics and rules and checks that pages are complete and display correctly, but does not check their facts or edit their text. Details may change — always confirm critical data at shopify.com.
Editorial Policy