Ecom Store Pro

How do you export orders from Shopify to CSV or Excel?

Published ·
At a glance
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

  1. Sort and filter the Orders list to the orders you want.
  2. Click Export.
In Shopify adminOpen in your store
  1. Orders
Steps 1 and 2: filter the list, then click Export at the top of the Orders page.
  1. 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).
  2. Under Export as, choose CSV for Excel, Numbers, or other spreadsheet programs or Plain CSV file.
  3. Click Export orders for all order information, or Export transaction histories for transactions only.
In Shopify adminOpen in your store
  1. Orders
  2. Export
Steps 3 to 5: pick the orders, the file format, then one of the two export buttons.

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.
About This Article

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

Related questions

Products & inventory
Can you export a Shopify purchase order to CSV or Excel?

Not from the order itself — Shopify documents a PDF export; for a spreadsheet, export a purchase order report in Analytics, where available.

October 17, 2026

Orders & customers
What happens to past Shopify orders when you delete or rename a variant?

Deleting a variant removes its data from your sales reports — unpublish instead to stop selling it; renaming leaves the order's locked snapshot.

Updated October 5, 2026

Products & inventory
What is the Vendor field on a Shopify product, and where does Shopify use it?

The Vendor field names a product's origin or source: one per product, your store name by default, and not a Bill Pay vendor.

October 15, 2026

Stay updated

Get notified about new articles

Subscribe to receive updates when we publish new Shopify guides and insights.