Skip to main content

Trim and deduplicate a CSV before import

Catch duplicates that differ only by surrounding spaces, with cleanup and comparison in the right order.

  1. Trim fields and remove empty rows

    CSV Cleaner

  2. Remove rows that match after cleanup

    Duplicate Row Remover

Run both steps

What to check in the example

One A17 row contains padded values and another does not. After trimming they match and appear once in the three-record output.

Download the source example

Working with your own file

Deduplication compares complete normalized rows. Records that share an SKU but disagree in another column remain separate.