How to Export Orders from Shopify (2026 Guide)

Open your browser and go to your Shopify admin panel at your-store.myshopify.com/admin. Enter your credentials to sign in. You need to have at least the Orders permission to access the export feature.

From the left-hand sidebar in your Shopify admin, click on Orders. This opens the full list of your store's orders sorted by most recent. You will see the Export button in the upper-right area of the page.

If you only need a subset of orders, use the filter bar at the top of the orders list before exporting. You can filter by date range, fulfillment status, payment status, sales channel, and more. Only the filtered orders will be included when you select the matching export option.

Tip: If you need orders for a specific accounting period, use the date filter to set your start and end dates before exporting.

Click the Export button to open the export dialog. You will see several scope options: export the current page of orders, all orders matching your filters, all orders in your store, or orders by date range. Select the option that fits your needs.

Under the 'Export as' section in the dialog, choose 'CSV for Excel, Numbers, or other spreadsheet programs' if you plan to open the file in a spreadsheet app. Choose 'Plain CSV file' if you intend to import it into another system or database. The spreadsheet-friendly format includes a BOM header for better compatibility with Excel.

Tip: For use with our converter tool, either CSV format works. The 'CSV for Excel' option is recommended if you want to preview the file first.

The dialog offers two export actions: 'Export orders' and 'Export transaction histories'. Click 'Export orders' to get the full order data with line items, customer information, shipping addresses, and financial details. The transaction histories option exports Shopify Payments data instead, which is a different dataset.

Warning: Do not click 'Export transaction histories' if you need order details. That option exports payment processing data (charges, fees, payouts) and does not include order line items or customer addresses.

If your export contains 50 or fewer orders, the CSV file will download directly to your browser. For larger exports, Shopify processes the file in the background and emails a download link to the store owner's email address. The email typically arrives within a few minutes but may take longer for very large datasets.

Tip: Check your spam or junk folder if the email does not arrive within 10 minutes. The sender is usually noreply@shopify.com.

Open the downloaded CSV file in your spreadsheet application. Verify that the data looks correct: each row represents a single line item, so multi-item orders will span multiple rows. The first row of each order group contains the order-level details (totals, customer info, addresses), while subsequent rows for the same order contain only the line item fields.

Tip: Look at the 'Name' column (order number like #1001) to identify which rows belong to the same order. Order-level fields such as Total, Shipping, and Billing Name appear only on the first row of each order group.