FMFM Tools

PRACTICAL GUIDE

Clean CSV files before importing

Practical steps to trim extra spaces, review duplicate rows and avoid common CSV import mistakes.

Step-by-step checklist

  1. Save a backup of the original CSV or TSV file before making changes.
  2. Check the expected columns and whether the first row contains headers.
  3. Review whitespace and duplicate rows carefully. Two similar rows may represent different legitimate records.
  4. Open the cleaned file in your destination software and check character encoding, dates, leading zeros and row counts.

Try the tool

TidyCSV is a separate site. Review its current features and privacy notice before uploading anything.

Open TidyCSV ↗

Frequently asked questions

Should I keep a backup?

Yes. Keep the untouched source file until you have checked the result.

Can I use sensitive documents?

Read the linked tool’s privacy information first. For confidential or personal data, follow your organisation’s rules and avoid uploading files unnecessarily.

Guide updated 24 October 2026.

See all guides