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.
Conversion templates
Choose a source platform and target format to apply a registered conversion template to the current file.
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.
- 예: BOMU shipping conversion으로 저장합니다.
- 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.
Load a file
Supports CSV, TSV, TXT, XLS, and XLSX files.
File settings
Output columns
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.
| 순서 | 출력 | Required-value check | Source column | Output column name | Prefix | Suffix | 고정값 | Format cleanup | Value mapping | Conditional transform | Remove column |
|---|
Result preview
Changes are reflected in the preview automatically.
The screen shows up to 30 rows; downloads include the full result.