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
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.
- In Shopify admin, open Orders.
- Filter the list to the orders you need, for example by date, payment status, fulfillment status or tags.
- Click Export in the page header.
- In the Export orders window, choose Current page and click Export orders. The CSV downloads.
- Go to the next page of the list and repeat until every page is exported.
- 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:
- Open a blank workbook in Excel.
- Go to Data > Get Data > From File > From Folder and choose the folder with your CSV files.
- Click Combine > Combine & Transform Data. Excel uses the first file as the example and appends the rest below it, with one header row.
- In Power Query, set ZIP, phone, SKU and ID columns to Text so leading zeros and long numbers survive.
- 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.
- Open Columna: Order Export & Sheets in Shopify admin.
- Choose the orders: filter by payment status, fulfillment status, date range and tags.
- Pick a template with the columns you want, in the order you want. Choose one row per order or one row per line item.
- 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.