Use a source file and the result you want to generate reusable rules automatically

Compare the source and desired result files to generate rules automatically

Members can add a desired result Excel/CSV and review the automatic analysis. After upgrading, they can apply the analyzed rules to the workspace, save them, and reuse them on the next file.

1. 1
   Upload the source Excel/CSV
2. 2
   Add the desired result Excel/CSV
3. 3
   Review analysis → apply & save after upgrading

After applying generated rules, you can still add or edit column, value, and row-processing rules in the Excel-style workspace.

Apply a ready-made workflow rule, or request a format you cannot build yourself

In Tool, you can choose workflow rules from common platforms published by BOMU or from private platforms assigned specifically to your account.

• Common platforms: choose a published source platform and one of its ready-made workflow rules.
• My platforms: private or client-specific platforms assigned by an administrator appear only for authorized accounts.
• If no rule fits, try source + result automatic generation first. If the workflow is still difficult to build, open Request to see the email address and required sample attachments.

Not every request can be implemented. When it is feasible with BOMU, it may be added as a common platform or as a platform available only to designated users.

Configure column rules across an Excel-like horizontal workspace

Instead of separate vertical cards, columns are arranged horizontally like a spreadsheet. Output, output name, format, mapping, and condition controls are organized by rows.

• Drag the top column area or use Change position to reorder output columns.
• Use Column Navigator to jump directly to a column in wide files.
• Review sample rows while you configure transformations.

Keep only the columns needed in the result

Turn Output off to remove a column from the result. The source data itself is not deleted.

• The same setting applies to preview, CSV, and XLSX output.
• Required-value checks can be configured separately from Output.

Match the output column order to the required format

Drag columns or use Change position to move a column to the exact output position.

Rename headers used in the downloaded result

Keep the original source header while changing the output name used in the result file.

Create a new column and fill every row with the same value

Useful for repeating values such as data source, country code, department, or processing type.

Replace existing values or change results based on conditions

Value mapping replaces exact source values with defined output values. Conditional transforms change the current output based on conditions in another source column.

• Value mapping is useful for repeated code or status replacements.
• Conditional transforms support conditions such as equals, contains, and empty.
• Multiple rules are evaluated in the configured order.

Apply one format rule to an entire column

Choose per-column rules such as special-character removal, email cleanup, or phone formatting.

Insert the current date or time into every row

Choose a format under Current date / time. Even when the source cell is blank, BOMU generates the browser-local date and time at execution.

• Korean UI: YYYY-MM-DD HH:mm:ss · YYYY-MM-DD · MM-DD
• English UI: MMM-DD-YYYY HH:mm:ss · MM-DD-YYYY HH:mm:ss · MMM-DD-YYYY · MM-DD-YYYY · MMM-DD · MM-DD
• Saved rules store the transform type, not a literal date, so running the rule on another day uses that day's date.

Keep the rows you need and check required-value gaps

Use row filters to include or exclude matching records, and required-value checks to catch blank fields before download.

Combine source columns and fixed text into one output column

Create a new output column by combining fields such as address parts or product descriptions in a defined order.

Merge multiple rows that share the same key

Choose a key such as order number, then sum numeric columns or join text values with a separator.

Review samples and full preview, then download the result

Use the 5-row workspace for fast checks, and Full preview to review up to 20 rows in a wider view. Required-value issues are surfaced before download.

• CSV download: useful for upload systems and data exchange.
• XLSX download: useful for opening the result directly in Excel.
• MySQL INSERT download: generates INSERT statements from the current result as a .sql file without asking for database connection credentials.
• Preview and every download format use the same transformation rules.

Save a rule once and apply it to the next file

After signing in, save output columns, order, names, value and format transformations, column combining, row merging, and supported settings as a reusable rule.