Fix your first file
Upload a file, fix it, save it as a Template and download the result in a few minutes.
What you need
- A file to fix (.csv, .txt, .xls, .xlsx, .json, .yaml, .yml), or the “Try an example” button.
- About three minutes.
Steps
Upload a file or load sample data
Drop your file on the upload area, or press “Try an example” to try it without one.
No file? Copy a table from Excel or Google Sheets, or copy CSV, JSON or YAML text, and paste it on that screen. It opens like an uploaded file.
Press “Paste data” or use Ctrl+V to paste. If an Excel file has several sheets, tick the ones you want to open.
Fix a cell and map a column
Edit a wrong cell in the grid, then map a column to the name your destination expects.
shopify_orders.csvOrder IDTotalStatus#1001128.50Paid#100264,001Paid#1003212.75Refunded- 1 The 64,00 total uses a comma, so a destination reads it as text.
Save the template
Save what you did as a template, so the same steps run on your next file in seconds.
Open the Export Studio and pick the format
Choose the file format your destination expects and check the preview. The formats are listed in Export formats.
Download
Download the file once the preview looks right.