Example

Clean a Messy CSV Export Before Import

A realistic CSV cleanup example covering blank rows, duplicated records, extra spaces, and import review.

The situation

A product manager exports a small list of support tickets from a help desk tool. The file has blank rows at the end, accidental spaces around names, repeated rows from a failed export, and one empty column that would confuse the destination spreadsheet.

Messy CSV sample

ticket_id, customer, status, , updated_at
1001, Alice Lee , open, , 2026-07-18
1002, Bob Chen, closed, , 2026-07-18
1002, Bob Chen, closed, , 2026-07-18
, , , ,
1003,  Dana Park , pending, , 2026-07-19

Workflow

1. Open the file in CSV Cleaner and confirm the first row contains the real headers.
2. Keep Trim whitespace enabled so names such as "Alice Lee " and " Dana Park " become consistent.
3. Remove empty rows because the blank line at the end is an export artifact.
4. Remove empty columns because the fourth column has no header or data.
5. Use duplicate removal only after confirming ticket 1002 is truly repeated.

Cleaned CSV result

ticket_id,customer,status,updated_at
1001,Alice Lee,open,2026-07-18
1002,Bob Chen,closed,2026-07-18
1003,Dana Park,pending,2026-07-19

Review checks

• Row count changed from five data rows to three valid ticket rows.
• Column count changed from five columns to four meaningful fields.
• Names no longer contain leading or trailing spaces.
• The duplicate was removed only because the complete row matched.

Open CSV Cleaner Back to examples