Export formats
Pick the file format your destination system expects.
Formats
| Format | Use it for | Note |
|---|---|---|
| CSV | Almost any import screen | Comma-separated text. |
| JSON | APIs and data pipelines | Nested objects and arrays. |
| XML | Systems that expect a schema | Like a Google Merchant feed. |
| Excel (.xlsx) | Opening the file in Excel | Numbers and dates arrive typed, and IDs keep their leading zeros. Dates and numbers show their text as you see it in the app, and every Excel export has a frozen header, fitted widths and a Summary sheet when the Template has one: a second tab named Summary with the totals you added. |
Split into files
In Export Studio, choose Split into files to download several files instead of one: a file per value of a column, or files of up to a number of rows. The download is one .zip with one file per part, each with the header row. A file named Orders split by City holds Orders - Berlin.csv; split by rows it holds Orders - 1.csv, Orders - 2.csv. A name that repeats gets (2), (3) before the extension. One download holds up to 100 files; for more, Export Studio offers the parts in batches, or make the parts larger. When the split writes one part, you get that file plain, with no .zip. A split download has no Summary sheet. Save the choice with the Template and every download and Run of it splits the same way.
Change report
The Changes tab in Export Studio shows what each step did to your file, in counts only. Turn on its switch and the file you download carries the same report. An Excel file gets a last worksheet named Changes with one line per row under What changed. A CSV, JSON or XML download becomes one .zip holding your file, unchanged, and a text file named like it with - Changes.txt added. With the switch off, the download is exactly the file you see.
Presets
| Preset | Format | What it follows |
|---|---|---|
| Shopify CSV | CSV | The column order and headers Shopify's product importer expects. |
| Google Merchant XML | XML | The XML feed structure Google Merchant Center expects. |