How do I change the CSV delimiter and date format of my exports?
Choose the CSV delimiter and the date format your spreadsheet software expects, for example when a CSV opens in a single column in Excel. The same page sets quoting and the .txt extension for systems such as ERPs that need them. All file formats and these settings are part of the Free plan.
Steps
- In the app, open Settings and pick File format.
- Choose the CSV delimiter: Comma (,) or Semicolon (;). Use semicolon for Excel in Germany, France, Netherlands, Poland and other countries where Excel expects it.
- Optionally tick Quote every field. CSV, TSV and pipe-separated files then put every value in double quotes,
such as
"#1001","Engraved mug","2". Some ERP and accounting imports need this. - Optionally tick Save delimited files as .txt. CSV and TSV files then end in
.txtinstead of.csvor.tsv. Pipe-separated files are always.txt. - Choose the Date format:
- 2025-01-31 (year-month-day)
- 31/01/2025 (day/month/year)
- 01/31/2025 (month/day/year)
- Click Save in the bar at the top of the page.
If you never changed these settings, the app uses Comma (,) and 2025-01-31 (year-month-day) and shows “These are the default settings. Keep them if they suit your spreadsheet software, or change them and save.” Click Keep these settings to keep them as they are.
Verify it worked
- After saving you see “Settings saved”.
- Export a few orders as CSV and open the file. The columns are split by the delimiter you chose, and dates use the
new format. With Quote every field every value is in double quotes; with Save delimited files as .txt the
file name ends in
.txt.
Where the settings apply
The settings are used by every export from the Orders and History pages and by scheduled exports. The
delimiter only matters for CSV files. Quoting and the .txt extension only matter for CSV, TSV and pipe-separated
files. The date format also sets how the Production list writes its dates.
A single template column can use its own date format or decimal separator instead. See “How do I add calculated columns and format numbers and dates per column?”.
Order dates use your store’s time zone from Settings › General in Shopify admin.
File formats
When you export, or in a scheduled export, choose the File format:
| Format | File | Columns separated by |
|---|---|---|
| CSV | .csv (or .txt) |
the CSV delimiter above |
| Excel (XLSX) | .xlsx |
(a workbook) |
| TSV (tab-separated) | .tsv (or .txt) |
a tab |
| Pipe-separated (|) | .txt |
| |
| JSON | .json |
(see below) |
| XML | .xml |
(see below) |
CSV, TSV and pipe-separated files are UTF-8 with a byte order mark, so Excel reads accents and other characters correctly. A value that contains the separator, a double quote or a line break is put in double quotes.
JSON is a list with one object per row of the export. Each key is a column header of your template, in the same
order. Number columns, such as quantities and amounts, are numbers (an empty one is null); every other value is text:
[
{"Order":"#1001","Product":"Engraved mug","Quantity":2},
{"Order":"#1001","Product":"Gift box","Quantity":1}
]
A column without a header is named Column 1, Column 2 and so on, and a header used twice gets (2), as in
SKU (2).
XML has one element per row, with one child element per column, in column order:
<?xml version="1.0" encoding="UTF-8"?>
<orders>
<order>
<Order>#1001</Order>
<Total>68.00</Total>
</order>
</orders>
- The outer element is
<orders>. Each row is<order>, or<lineItem>when the template has one row per line item. Reports, such as payout reports, sales journals, the EU VAT report and the production list, use<report>and<row>; products, customers and draft orders use<products>and<product>,<customers>and<customer>,<draftOrders>and<draftOrder>. - Element names come from the column headers. Spaces and characters XML does not allow become
_, such asShipping_countryfor “Shipping country”. A name that would start with a digit, a dash orxmlgets a leading_. A header used twice gets_2, as inSKU_2. - An empty value is an empty element, such as
<Note/>. The characters&,<and>are written as&,<and>.
Troubleshooting
My CSV opens in a single column in Excel. Excel in many European languages expects semicolons. Set CSV delimiter to Semicolon (;), or export as Excel (XLSX) instead.
You see “Could not save export settings”. Click Try again.
You see “Could not load export settings”. Click Try again. If it keeps happening, use Open support chat in the app.