Shopify does not export orders to Excel. It exports them to CSV (including an option labelled for use with spreadsheet programs), and a CSV is a plain text file, not a workbook. For a lot of tasks that distinction does not matter. For anything involving postal codes, SKUs, phone numbers, or dates, it matters a great deal.
What the built-in export gives you
From your Shopify admin, go to Orders, use the filters or search to narrow the list, then click Export. You choose which orders to include (the current page, all orders, the ones you have selected, or everything matching your current filter) and Shopify produces a CSV. Larger exports arrive as an emailed download link rather than an immediate download.
The result is one file with a fixed set of columns, in a fixed order, using Shopify’s header names. Orders with several line items span several rows. That is the whole feature: it is reliable, it is free, and it is not configurable.
Why the CSV looks wrong when you open it
Excel does not read a CSV so much as guess at it. Every value is untyped text, and Excel applies its own interpretation on open. The usual casualties:
- Leading zeros vanish. A postal code of
02134becomes2134. SKUs like00451lose their padding and stop matching your warehouse system. - Dates get rewritten into your machine’s local format, so the same file opened in Halifax and in Berlin produces two different spreadsheets.
- Long numbers go scientific. Order references and barcodes turn into
1.23457E+11. - Accented characters break. Depending on how Excel is configured, a UTF-8 file
opened directly can render
MüllerasMüller. (If you are seeing this with an Exportify CSV, Characters look wrong in Excel has the fix.)
None of this is Shopify’s fault, and none of it is recoverable after the fact: once Excel has stripped a leading zero and you have saved, the original value is gone.
Opening a Shopify CSV safely in Excel
If you are staying with the native export, do not double-click the file. Import it instead, so you control how each column is typed:
- Open a blank workbook in Excel.
- Go to Data -> From Text/CSV and pick the downloaded file.
-
Set File Origin to
65001: Unicode (UTF-8)so accented characters survive. - Choose Transform Data rather than Load, and set every column that should keep its exact characters (postal codes, SKUs, phone numbers, order references) to Text.
- Load, then save as
.xlsxso the typing sticks.
This works. The problem is that it is five careful steps performed by a human, every single time, and one distracted double-click undoes it.
If you export orders once a quarter to eyeball them, the import wizard is the right answer and you do not need an app. The case for anything else starts when the export is a recurring job someone has to get right.
Getting a real .xlsx file instead
The alternative is to have the export produced as a genuine Excel workbook, with types already
correct, so there is nothing to interpret on open. That is what
Exportify does: you pick Excel (.xlsx) as the output format
and the file arrives as a workbook rather than a text file Excel has to parse. It is a single
setting; see Choose a file format in the Exportify help centre.
Alongside the format, you get control over what is in it:
- Choose which of the order, line item, customer, tax, and financial fields appear.
- Drag columns into the order your spreadsheet or pivot table expects.
- Rename headers, so
Lineitem quantitycan just beQty. - Save it as a reusable template, so next month’s export is identical to this one.
Exportify is a paid app, from $19.99 per 30 days, with a 15-day free trial. See the plan breakdown for what is included at each tier.
How do I connect Shopify to Excel so the numbers stay current?
This is the question behind most searches for “Shopify to Excel”, and it is worth answering plainly: there is no live connection. Shopify does not publish an ODBC driver and Excel has no built-in Shopify connector, so nothing refreshes a sheet straight from your store the way it would from a database.
What people actually do falls into three patterns:
- Re-export by hand. Fine weekly, tedious daily, and the step everyone eventually wants to stop doing.
- Have the file delivered on a schedule. The export runs on its own and the fresh file lands in the same place each morning. If that place is somewhere Excel can reach, such as a synced folder or a network share, Power Query can point at it once and you refresh the workbook instead of rebuilding it.
- Build against the Admin API. Full control, and you own the pipeline: API version upgrades, retries, alerting, someone to fix it when it breaks.
Exportify does the middle one. Scheduled exports run daily, weekly, or on the schedule you need, and deliver to your own SFTP or FTP server on the Standard and Advanced plans. The layout is the template you already built, so the file that arrives each morning has the same columns in the same order as the one you set up. See Scheduled exports and Deliver exports to your SFTP or FTP server.
Which approach fits
| If you are… | Use |
|---|---|
| Pulling orders occasionally to read them | Native CSV export, opened via Data -> From Text/CSV |
| Sending the same report to the same people every week | A saved template producing .xlsx directly |
| Feeding a pivot table or an accounting import | A template with the exact columns and headers that import expects |
| Wanting a spreadsheet you refresh rather than rebuild | A scheduled export delivered to a location Excel can read |
| Handing the file to someone outside your team | .xlsx, so their Excel cannot reinterpret it either |
