BOMU Convert
한국어 English 日本語
Log in Sign up free
Automate repetitive spreadsheet work in your browser

Automate Excel & CSV data cleanup

Clean the source file manually or add the Excel/CSV result you want to generate reusable rules automatically. Edit and save the rules, then reuse them on future files.

Your source file is not stored on our server.
Selected task

Add a fixed-value column

Choose where to insert the new column and fill every row with the same value.

1

Load a file

Supports CSV, TSV, TXT, XLS, and XLSX files.

Quick start Choose a file, then configure only the steps you need.
Choose a file Load an Excel, CSV, TSV, or TXT file.
Set the needed steps Configure only the column cleanup, value changes, conditions, merging, or other steps you need.
Download the result Download the result as CSV, XLSX, or a MySQL INSERT (.sql) file. Members can save a rule and reuse it with the next file.
Privacy protection Your source work file is processed in the browser and is not stored on our server.
Quick settings Open only the settings you need and keep the output workspace in view.
2

Build output data

Check each output column and open only the settings you need to adjust.

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.

3

Review result

Review the full result, then download it or save the transformation rules.

Need a different conversion? Request one bomu-@naver.com

Send a source sample and an example of the result you want.

Will you use the same cleanup rules on another file? Create a free account to save the current column and value settings as a reusable rule.

Generate rules automatically

Add your result Excel/CSV and BOMU will analyze it and generate the rules automatically. Complex rule sets can take longer to analyze, but once saved they can be reused immediately.

You can add the rules you need yourself using the rule settings below.

Sheet & header settings

Change the worksheet and header row

Settings preview
Shows 3 sample rows. Enter 0 for files without a header row.

Basic output rules

Choose a basic output rule from common platforms or any private platform assigned to your account. If none fits, generate rules automatically or configure them yourself.

Set up your Cafe24 export format first. Cafe24 lets store operators customize Excel export fields and order. Create and save a BOMU export layout once, then reuse the same structure for future conversions.
View setup steps
  1. Open the integrated order Excel menu in Cafe24 Admin.
  2. Create a new layout under export format management.
  3. Select fields for order identification, recipient, address/postal code/country, phone/email, product/SKU, quantity, order amount/currency, and shipping method.
  4. Example: BOMU shipping conversion and save it.
  5. 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.

Full result preview

Review the full result 20 rows at a time.

Create MySQL INSERT file

Convert the current result into MySQL INSERT statements and download a .sql file. No database connection details are required.

SQL columns Choose columns to include and edit SQL column names if needed.
SQL preview

Combine multiple values into one column

Add source columns and fixed values in the order you want, then choose separators between values.

Values and order

No separator is applied before the first value.\n From the second value onward, choose no separator, a space, or a custom separator.

Value mapping

When a source value matches exactly, replace it with the specified result.

Selected column Values that do not match remain unchanged.
Source value Replacement value

No mappings yet. Select Add mapping to create a rule.

Conditional transform

If a source-column value matches the condition, set this output column to the specified result.

Selected column Only the first matching rule from the top is applied.
Source column Condition Compare value Result value

No conditions yet. Select Add condition to create a rule.

Row filter

Keep only rows that match a condition, or exclude matching rows from the result.

Filter rules All filter rules are applied from top to bottom.
Action Source column Condition Compare value
Automatically generated row rules Row rules created by automatic analysis are locked to preserve the generated result. Use Reset rules to remove them all.

No filters configured. All source rows will be output.

Merge rows with matching values

Merge rows whose selected key columns all match, and sum the column chosen for each rule.

Grouping rules Choose the grouping and sum columns.
Choose Not used for the key column and apply to clear the manually configured matching-row merge. Choose Not used for the sum column to group only by the key column.\n With multiple key columns, rows merge only when all key values match. Other columns keep the first row's value, and rows with empty key values remain separate.

Add fixed-value column

Choose which column the new fixed-value column should be inserted after.

Change column positions

Swap the positions of the two selected columns.
Feature help

How to use

Example
BOMU Convert Make repetitive spreadsheet work simpler

Clean recurring Excel and CSV work in your browser, then save transformation rules for reuse.

010-9405-1988 bomu-@naver.com

Support: Mon-Fri, 10:00 AM-6:00 PM KST

Business Information

Company
보무 (BOMU)
Representative
박봉우
Business Registration No.
660-03-03270 Verify business
E-commerce Registration No.
2026-경기파주-3317
Business Address
경기도 파주시 경의로 1050, 1412호 (센트럴파크리움)
© 2026 BOMU Convert. All rights reserved.