Step-by-step approach
- Check whether the file was saved as UTF-8, UTF-8 with BOM or a legacy single-byte encoding.
- If you see replacement characters, avoid saving over the source because lost bytes may be unrecoverable.
- Export afresh from the original software as UTF-8 when possible.
- Use your spreadsheet importer’s text/CSV wizard and select the correct encoding.
- Review accented characters, emoji and non-Latin scripts in sample records before using the data.
Try the matching tool
Open CSV Cleaner to work on a local copy. Review the result before importing it elsewhere.
Open CSV Cleaner ↗What this does not solve
Browser tools can validate known structures and transform available data, but cannot restore deleted or corrupted bytes, infer unknown business facts, or guarantee that a target system will import every field as intended.