Turns a column mixing “ＴＡＮＡＫＡ”, “ﾀﾅｶ”, “2021/4/1” and “2021年4月1日” into one consistent format — exactly what you need before a join or a system import.
No uploadNo sign-upWidth, dates and phones
Process your CSVRuns on your device
Drop a CSV here
or click to choose · Shift_JIS / UTF-8 detected
How to use
Drop a CSV or paste the table.
Tick the normalizations you want.
Press Run, review the changed-cell count, then download.
What this tool does not do
Japanese era dates are not converted to Western years, and addresses are not normalized. Hyphen removal applies to cells made up only of digits and hyphens.
FAQ
Which date formats are supported?
2026/1/5, 2026-01-05, 2026.1.5, 2026年1月5日 and 20260105 all become YYYY-MM-DD; anything unrecognised is left untouched.
Does it convert half-width kana?
Yes — with that option on, ﾃﾞｰﾀ becomes データ, including combined voicing marks.