Tidy a CSV in one drop
- No upload
- Free
- Works offline
Drop a CSV or Excel file hereThe tool that fits it opens
Most used
- AI Mask a tableBefore ChatGPT: names become 【Person 1】, put back later
- Mask personal data090-****-5678
- Fix garbled textOpens right in Excel
- Remove duplicatesKeep the first
- Compare two filesAdded, removed, changed, in colour
- Look upLike VLOOKUP
Masking text, not a table? AI Mask on orihako.com
All tools (17)
- Fix garbled textOpens right in Excel
- Convert formatsJSON, XML, contacts, calendars to CSV and Excel
- Compare two filesAdded, removed, changed, in colour
- View and editA spreadsheet in your browser
- Unify widthsHalf-width letters, full-width kana
- Split addressesPrefecture, city, street
- Put lost zeros backPostcodes and phone numbers
- Japanese era dates令和6年 ⇄ 2024
- MergeMany files into one
- Remove duplicatesKeep the first
- ColumnsKeep, drop, reorder
- Mask personal data090-****-5678
- Put back an AI's table【Person 1】 → the name
- SplitEvery N rows
- TotalsSum, count, pivot
- Look upLike VLOOKUP
- Invoices into accounting softwarefreee, Money Forward, Yayoi
Pick from common jobs (23)
- Shift_JIS to UTF-8
- UTF-8 to Shift_JIS
- Add a BOM to a CSV
- Convert JSON to CSV
- Convert CSV to JSON
- Convert XML to CSV
- Contacts (VCF) to Excel
- Calendar (ICS) to Excel
- Convert CSV to Excel (xlsx)
- Convert Excel to CSV
- Convert TSV to CSV
- CSV to a Markdown table
- Compare two Excel files
- View a CSV in your browser
- Half-width katakana to full-width
- Remove extra spaces
- Extract the prefecture from addresses
- Format postcodes as 123-4567
- Restore phone numbers' leading 0
- Western dates to Japanese era dates
- Mask phone numbers
- Mask e-mail addresses
- AI Mask a table
How-to articles (14)
- Fix a CSV that Excel garbles
- Mask a customer list before handing it over
- Clean a mailing list of duplicates
- Merge monthly CSV exports into one file
- Split a large CSV for an upload limit
- Pick CSV columns to match an import template
- Find the differences between two tables
- Turn phone contacts into an Excel list
- List calendar events in Excel
- Open JSON in Excel
- Edit a CSV without Excel
- Unify full-width and half-width characters
- Split addresses into prefecture and city
- When postcodes and phone numbers lose their 0