How to use
- members.xlsxMixed full/half width
Pick columns
- Full-width → half, zero-padApplied top to bottom
Stack steps in order
- members_text.xlsxas Excel or CSV
Save the result
Drop an Excel (.xlsx) or CSV / TSV file, or click “Choose files”. “Try a sample” creates a practice member list.
Under “Target columns”, pick the columns to change. At first every column is picked.
Choose a step under “Add a step” and press “Add”. Steps run from top to bottom; use the up and down buttons to change the order.
In the “Result” table, check the yellow cells (changed) and blue cells (made by split or combine). Counts are shown for each step too.
Choose the format (Excel / CSV) and encoding, then download.
What it does
Steps stacked in order
Run full/half-width, kana, spaces, upper and lower case, zero-padding, cutting, replacing, splitting and combining in the order you need. Changing the order can change the result, and the preview shows it.
Pick the columns for each run
Only the picked columns change. Columns made by split or combine can also be included in later steps.
Letters, symbols and kana converted separately
Choose the direction for each kind: letters and digits, symbols, or katakana. Change only the kinds you need.
Zero-padding keeps the text
Digits-only cells are padded to the width you choose and saved as text, so “00123” keeps its leading zeros. Values are not turned into numbers.
Check the changes before saving
Changed cells are yellow, made columns are blue, and every step shows its count. Switch to the original data to check nothing unexpected changed.
Use cases
- Make letters and katakana consistent column by column in a list where “ＡＢＣ１２３” and “ﾔﾏﾀﾞ” are mixed
- Split “Taro Yamada” into a family-name and a given-name column, or join prefecture and city into one column
- Zero-pad “7” to “00007” so the codes match another system’s five-digit format
- Cut the first characters of a product code, add a prefix such as “ID-”, or replace text
- Convert a reading column to katakana or hiragana before sorting it
Supported formats
Input
Output
Capability matrix
| Feature | Support | Notes |
|---|---|---|
| Full ⇄ half-width (letters, symbols and katakana separately) | Supported | — |
| Hiragana ⇄ katakana | Supported | Applies to full-width kana |
| Upper and lower case | Supported | ASCII letters only |
| Trim spaces, collapse repeats, remove hidden characters | Supported | — |
| Split by a delimiter (up to 10 columns) | Supported | The rest goes into the last column |
| Combine several columns | Supported | The combined column is added at the right |
| Add text at start or end, cut by character count | Supported | — |
| Replace text (regular expressions too) | Supported | Regular expressions stop after 10 seconds |
| Zero-pad digits (saved as text) | Supported | — |
| Convert to numbers or dates | Not supported | Use “Excel Cleanup” to unify number and date formats |
| Several sheets in one run | Partial | One sheet at a time |
| Keep formulas, formatting, merged cells | Not supported | Only values are saved |
| Legacy Excel (.xls) | Not supported | Re-save as .xlsx in Excel first |
Limits & notes
- Works on smartphones too, but picking columns and working on large files is easier on a PC.
- Up to 100 MB per file. Large files take longer to process.
- Per step: find and replacement text up to 200 characters, prefix and suffix up to 100, cut counts and start positions up to 10,000, zero-pad width 1–30, split into 2–10 columns.
- A run stops after 10 seconds. If a regular expression is slow, shorten it or pick fewer columns.
- Only cell values are saved. Formatting, formulas, merged cells and data validation are not carried over.
Privacy & safety
Reading, processing and building the download all happen in your browser. Your data is never sent to or stored on a server.
FAQ
How do I convert full-width letters and digits to half-width in Excel?
How do I split text into columns by a delimiter in Excel?
How do I combine two columns into one in Excel?
How do I stop leading zeros from disappearing in Excel?
How do I convert hiragana to katakana for a reading column?
How do I clean up notation variations across a whole table?
Is my data uploaded?
Related tools
Excel Cleanup
Tick what to fix and clean up spaces, character widths, dates and numbers across a whole Excel or CSV file at once. Changed cells are highlighted, and you can save as Excel or CSV.
CSV Studio
Open CSV files that are slow or garbled in Excel and view, search and edit them right away in your browser. Combine, split and save as CSV (UTF-8 with BOM, Shift_JIS), Excel or JSON on one screen.
Excel Merge
Combine sheets from several Excel or CSV files: stack their rows into one table, or keep them as separate sheets in one workbook. Columns are aligned by header name automatically.
Excel Compare
Load an old and a new Excel or CSV file to see added, removed and changed rows, with every changed cell shown as “old → new”. Rows in a different order are matched by a key column such as a product code. Cell values are compared, not formatting or formulas. Save the result as a colour-coded Excel report or CSV.
Excel Deduplicate
Find duplicate rows in an Excel or CSV file by the columns you choose, ignoring the variations you choose, then remove them or merge each group into one row. Review every group, change which row survives, and save as Excel or CSV.
Excel Reshape
Swap the rows and columns of an Excel or CSV table (transpose), turn a wide table with a column per month into a long one (unpivot), or pivot long data back into a wide table. The result is built in your browser and saved as .xlsx or CSV.
Last updated: