Orders5 min read

Download 200+ Shopify Orders to Excel Without an Email Link

Shopify emails any export of more than 50 orders. How to download 200+ orders straight to your computer: export page by page, or build the file in your browser.

In this guide
  1. Why does Shopify email my order export instead of downloading it?
  2. How do I download more than 50 orders without the email?
  3. How do I combine the page exports into one Excel sheet?
  4. Can I get all the orders in one file with one download?
  5. Which option should I use?
  6. FAQ
  7. Try Columna: Order Export & Sheets

Shopify downloads an order export straight away only when it holds up to 50 orders or the current page; anything larger is sent as an emailed link, and there is no setting to change that. To get 200 or more orders onto your computer without waiting for the email, either export the list one page at a time and combine the files in Excel, or use an app that builds the file in your browser, such as Columna: Order Export & Sheets.

The first route costs nothing and works in any store. The second gives you one CSV or XLSX file in a single download, with line-item properties such as engraving text, gift messages and upload links in their own columns.

Why does Shopify email my order export instead of downloading it?

Shopify’s help center, in Exporting orders, describes how the file reaches you:

You export What happens
Up to 50 orders, or the current page The CSV downloads to your device
A larger selection, or orders by date The CSV is emailed to you and the store owner
An export that fails You receive an email saying so

This is how the export works for every store, not a preference you can switch off. A merchant asked exactly that in the Shopify Community thread Export orders to downloads and avoid email links, and the answers point to the emailed file or the API, not to a setting.

For a back office that exports every day, the email adds a wait and an extra step: open the inbox, find the message, click the link, save the file.

How do I download more than 50 orders without the email?

Export one page of the order list at a time. Each page counts as “the current page”, so each export downloads directly.

  1. In Shopify admin, open Orders.
  2. Filter the list to the orders you need, for example by date, payment status, fulfillment status or tags.
  3. Click Export in the page header.
  4. In the Export orders window, choose Current page and click Export orders. The CSV downloads.
  5. Go to the next page of the list and repeat until every page is exported.
  6. Save all the CSV files into one empty folder, named in order, such as orders-p1.csv, orders-p2.csv.

For 200 orders that is a handful of exports instead of one email. Keep the same filters and sort order on every page, or orders can shift between pages while you work.

How do I combine the page exports into one Excel sheet?

Each page export is a separate CSV with its own header row. Excel’s Power Query can stack them into one table without copying and pasting:

  1. Open a blank workbook in Excel.
  2. Go to Data > Get Data > From File > From Folder and choose the folder with your CSV files.
  3. Click Combine > Combine & Transform Data. Excel uses the first file as the example and appends the rest below it, with one header row.
  4. In Power Query, set ZIP, phone, SKU and ID columns to Text so leading zeros and long numbers survive.
  5. Click Close & Load, then save the workbook as Excel Workbook (.xlsx).

If the columns land in a single column or names look garbled, our guide on a Shopify order CSV that opens in one column in Excel covers delimiters and UTF-8. For the full walkthrough of the built-in export, see how to export Shopify orders to Excel.

Can I get all the orders in one file with one download?

Yes, with an app that builds the export file itself. Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX with line-item properties (engraving, gift messages, upload links), processed in your browser. It is made for shops that hand orders to production, fulfilment or accounting.

  1. Open Columna: Order Export & Sheets in Shopify admin.
  2. Choose the orders: filter by payment status, fulfillment status, date range and tags.
  3. Pick a template with the columns you want, in the order you want. Choose one row per order or one row per line item.
  4. Download the file as CSV or XLSX. It is built in your browser and saved to your computer.

The Free plan covers up to 50 orders a month in exports. Exporting 200 or more orders needs the Pro plan, which has a 7-day free trial; current prices are on the app page.

Which option should I use?

Shopify export, page by page Shopify export, emailed Columna: Order Export & Sheets
How you get the file Direct download per page Link in an email Direct download
Files for 200 orders Several CSVs to combine One CSV One CSV or XLSX
File format CSV CSV CSV or XLSX
Line-item properties as columns No No Yes, one column per property
Your own column set and order No No Yes, saved as a template
Cost Included with Shopify Included with Shopify Free up to 50 orders a month; Pro for more

If you export a large range once a month, waiting for the email is often fine. If someone exports hundreds of orders every day for packing, production or bookkeeping, one download in the layout they need saves the most steps.

If the goal is a file that arrives without you opening anything, compare the routes in Shopify scheduled order export: your options.

FAQ

Is there a setting to make Shopify download large order exports directly?

No. Shopify downloads exports of up to 50 orders or the current page; larger exports are emailed to you and the store owner.

The export email never arrived. What should I do?

Check the spam folder first. Large exports can take time to process, so give it a while before exporting again. If you need the orders now, export the list one page at a time.

Will exporting page by page miss or duplicate orders?

Not if the filters and sort order stay the same while you work. New orders arriving during the export can shift the list, so filter to a closed date range, such as last month.

Does the Shopify export include engraving text or gift messages?

Line-item properties are not columns in Shopify’s standard order CSV. Columna: Order Export & Sheets puts each property in its own column; see export Shopify orders with line item properties.

Can I get an .xlsx file instead of a CSV?

Shopify’s order export is a CSV, which you can save as .xlsx in Excel. Columna: Order Export & Sheets downloads XLSX directly.

Try Columna: Order Export & Sheets

If your team exports more than 50 orders at a time for production, fulfilment or accounting, install Columna: Order Export & Sheets and download your orders as one CSV or XLSX file, with line-item properties in their own columns.