DocTransform

Export formats

Pick the file format your destination system expects.

Formats

FormatUse it forNote
CSVAlmost any import screenComma-separated text.
JSONAPIs and data pipelinesNested objects and arrays.
XMLSystems that expect a schemaLike a Google Merchant feed.
Excel (.xlsx)Opening the file in ExcelNumbers 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

PresetFormatWhat it follows
Shopify CSVCSVThe column order and headers Shopify's product importer expects.
Google Merchant XMLXMLThe XML feed structure Google Merchant Center expects.