Quick Answer
Most CSV problems show up during import: extra columns, blank rows, duplicate records, wrong delimiters, hidden whitespace, and inconsistent headers.
Step-by-Step
- Open the file in a CSV viewer or editor and confirm the delimiter, headers, and row count.
- Remove blank rows, trim whitespace, normalize headers, and deduplicate repeated records.
- Profile columns to find empty values, suspicious formats, and inconsistent data types.
- Convert or export to the format your next tool needs, such as JSON, table, Excel, or YAML.
Recommended Workflow
Open the most relevant calculator or utility first, enter a realistic starting point, then use the supporting tools to check assumptions, clean inputs, or prepare the final output.
FAQs
Should I edit CSV files in a spreadsheet app?
You can, but spreadsheet apps may change dates, IDs, and long numbers. A browser CSV tool is safer for quick cleanup.
What should I check first?
Check the delimiter, headers, row count, blank rows, and duplicate key fields before importing.