Private CSV cleanup

Remove exact duplicate rows from CSV.

Keep the first matching row, preview what changes, and make a clean copy. Your spreadsheet stays in your browser.

No account needed to inspect a file or preview changes. Full cleaned-file downloads require sign-in and an export allowance. See free and paid exports.

See the difference

One repeated row removed. A different status kept.

Here are four illustrative order records. The second row repeats the first exactly. The refunded order shares an ID and email with them, but its status differs, so it stays.

Original rows
4
Exact duplicate removed
1
Rows kept
3
Before cleanup
order_idemailstatus
A1001alex@example.compaid
A1001alex@example.compaid
A1001alex@example.comrefunded
A1002lea@example.compaid
After exact-row deduplication
order_idemailstatus
A1001alex@example.compaid
A1001alex@example.comrefunded
A1002lea@example.compaid
Second identical paid row: removedDifferent refunded status: kept

These are fictional records with example email addresses. Download this CSV, then open it in the workspace to try the same cleanup.

A reviewable workflow

How to remove duplicate CSV rows

  1. Open your file in the workspace

    Choose a CSV from your device. TidyExport inspects it locally and reports issues in the source file, including exact duplicate rows.

  2. Review the cleanup recipe

    The default recipe trims whitespace before removing exact duplicates. This can make rows with stray leading or trailing spaces match. Disable trimming if those spaces carry meaning in your data.

  3. Check the cleaned preview

    Compare the remaining records and check the “duplicates removed” count. Source issue counts describe the original file; removal counts reflect the steps and order in your recipe. Rows with different values should remain.

  4. Save a separate clean copy

    Sign in when you are ready to download the full cleaned CSV. Previewing is free; a successful cleaned-file download uses an export allowance. Your original file is not overwritten.

Know what stays

Exact rows, not guessed matches

Removed: a later identical row

Every column has the same value after the preceding cleanup steps. The first matching row is kept; later copies are removed.

Kept: any different value

A different amount, date, status, or letter case makes a separate row. Sharing an order number or customer email alone is not enough.

TidyExport does not deduplicate by a selected key, merge near matches, or choose the newest or “correct” conflicting record. Review those cases separately before removing anything.

Before you start

CSV duplicate removal questions

Is my CSV uploaded to a server?

No. Parsing, cleaning, and creating the cleaned file happen in your browser. Account and export-access checks use online services, but your spreadsheet contents are not uploaded for processing. Read how local processing works.

Do extra spaces affect duplicate detection?

Yes. If trimming runs before duplicate removal, leading and trailing whitespace in text cells is removed first. Two otherwise identical rows can then match. You can disable trimming or change the recipe order when reviewing your file.

Will it delete every repeated order number or email?

No. All values in the row must match. Different line items, refunds, or status updates remain when any column differs. This avoids treating every repeated customer or order ID as a duplicate.

Can I preview the result for free?

Yes, inspecting and previewing need no account. Full cleaned-file downloads require sign-in. Each account gets one free successful export per UTC month; further exports require an available paid allowance. Review current export options.

What file sizes and formats are supported?

CSV files are supported up to 25 MB and 100,000 data rows. XLSX files are supported up to 15 MB and 50,000 data rows, using the first worksheet. The workspace checks these limits before processing.

Does cleanup change my original file?

No. TidyExport creates a separate cleaned copy when you download. Keep your source file and review the preview before using the result in another system.

Check your next export before sharing it.

Start with the example or a CSV from your own device.

Open the CSV cleaner