Automate Excel & CSV data cleanup
Keep only the columns you need, reorder and rename them, transform values, and download a new file ready for work. Sign in to save your transformation rules.
Value mapping
Use Mapping to replace exact source values with the output values you define.
Load a file
Supports CSV, TSV, TXT, XLS, and XLSX files.
Sheet & header settings
Change the worksheet and header row
Conversion templates
If a saved conversion template matches this file, apply it here. You can also continue with your own column settings.
View setup steps
- Open the integrated order Excel menu in Cafe24 Admin.
- Create a new layout under export format management.
- Select fields for order identification, recipient, address/postal code/country, phone/email, product/SKU, quantity, order amount/currency, and shipping method.
- Example: BOMU shipping conversion and save it.
- Use files exported with the same layout in BOMU.
Actual Cafe24 field names may vary by store settings; the list above describes the types of data required.
Build output data
Drag to reorder columns. Use Add fixed-value column to create a column that does not exist in the source and fill every row with the same value.
Review result
Review the full result, then download it or save the transformation rules.
Send a source sample and an example of the result you want.