1.  [Documentation](/en/docs)
2.  [Guides](/en/docs/guides/data-profiling)
3.  Export formats

# 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.
