Fix garbled characters in a CSV export
Use an encoding preview and UTF-8 output instead of guessing from the filename.
2 min read · Open guideData & spreadsheets
Inspect first. Transform with confidence.
Preview CSV files, check encoding, merge tables and convert CSV or JSON while keeping identifiers and column meaning in mind.
A useful place to start
Preview the delimiter, header and a few representative records.
Check encoding and column names before merging, cleaning or converting.
Verify the output row count and identifiers before importing it elsewhere.
THE TOOLKIT
6 tools · Local processingChoose the right tool for the job.
Inspect
CSV Viewer & Validator
Preview CSV tables and inspect parsing errors.
Open tool ConvertCSV Encoding Converter
Convert text exports to UTF-8 with an optional Excel BOM.
Open tool OrganizeMerge CSV Files
Combine exports by matching column headers.
Open tool OrganizeSplit CSV
Split a table into smaller files by row count.
Open tool CleanRemove CSV Duplicates
Remove repeated rows using selected key columns.
Open tool ConvertCSV ↔ JSON
Convert CSV tables and arrays of JSON records.
Open toolConnect the steps.
An account ID such as 00123 is text, even when it contains only digits. Check how your spreadsheet imports it so its leading zeros are preserved.
GO A LITTLE DEEPER
All guides ↗Guides for the next step.
Know the limits.
CSV cannot preserve spreadsheet formatting or formulas as a workbook does. Nested JSON flattening and arbitrary encodings are outside current scope.
How we explain methods and sources →