Work through this in order
- Inspect the first header row and delimiter
- Keep a comma within a quoted cell together
- Interpret doubled quotes as literal quote characters
- Check whether rows have consistent column counts
- Export or edit in a tool that preserves identifiers as text
Use the matching tool
Inspect a local copy with CSV File Viewer. After the check, save or repair files only using trusted software that supports the format.