Fix garbled CSV text.Streamline your Excel and CSV spreadsheet work.
Unreadable garbled CSVs, merging multiple CSVs, opening and editing CSVs in Excel. Choose the right tools and procedures for your goals and get your work files organized.
What you can do with JIM-JIN
JIM-JIN is a collection of web tools for people who work with CSV, Excel, and text files. You can repair garbled CSVs, edit/merge/split/validate CSV and Excel files, and convert character encodings like UTF-8 and Shift_JIS. We also offer tools to assist with other office tasks, such as images, ZIP files, QR codes, and task management.
Select the task you want to perform and use each tool directly from your browser. You can check plans, usage limits, and file processing methods on each tool’s screen.
CSV and Excel spreadsheet tasks, sorted by purpose.
From fixing garbled CSV text to editing, merging, splitting, and validating spreadsheets. Choose the task you need.
CSV Garbled Text Repair Tool
When you need to fix a garbled CSV. Compare and check repair candidates for text made unreadable by encoding differences, and save in UTF-8.
Repair unreadable CSV Merge / SplitExcel & CSV Merge / Split Tool
For merging multiple CSVs, combining Excel tables, or splitting them into required units. Supports vertical/horizontal merging and splitting by row count or item.
Combine / Split tables Edit TableCSV Editor Tool
Open a CSV in a table format to modify cells, add rows or columns, and search & replace. You can edit while preserving leading zeros and long numbers.
Open and edit CSV Data ValidationExcel & CSV Data Check Tool
Check data against defined rules such as blanks, duplicates, and input formats. Fix found defects on the spot and save.
Validate before importing Encoding ConversionCSV & TXT Encoding Conversion Tool
Batch convert file character encodings such as UTF-8 and Shift_JIS. Align character encodings to match the recipient’s requirements.
Convert CSV / TXT encodingOrganize Writing and Text
Check text length and notation, and compare differences before and after edits.
Character Count Tool
Check the estimated character count, byte size, and reading time all at once.
Check text length Unify NotationFull-width / Half-width Conversion Tool
Specify and convert alphabets, numbers, and symbols individually. Also supports TXT and Word files.
Align alphanumeric notation CompareText & File Difference Comparison Tool
Color-codes additions, deletions, and changes. Compare differences in text, Word, PDF, CSV, and TXT files.
Compare before & after editsFrom Troubleshooting to Solutions.
Solve common CSV issues through both how-tos and our tools.
How to Fix Garbled CSV Text
Learn about encoding differences, the relationship between UTF-8, Shift_JIS, and BOM, and the steps to check when text is unreadable.
Read the garbled text solution guideBefore Merging Multiple CSVs
How to combine multiple tables into one by checking for duplicate headers and column order differences.
Read the CSV merging guideEdit CSVs Without Losing Leading Zeros
How to verify and keep the number of digits and leading zeros when handling postal codes and product codes in Excel.
Read how to keep leading zerosHow to Open a CSV in Excel and Save it as an Excel File
To perform a “CSV to Excel conversion”, select [From Text/CSV] from the [Data] tab in Excel to import the data, and save it as an Excel Workbook (.xlsx) if necessary. Please import columns where you want to keep leading zeros, such as postal codes and product codes, as “Text”.
Other Web Tools
We also offer tools for tasks other than CSV and Excel, such as images, ZIP files, QR codes, and task organization.
