Skip to main content

Trim cell whitespace, remove empty rows and deduplicate by selected columns or full rows, then export.

Supports ordinary XLSX and UTF-8 CSV: up to 8 MiB per file and 16 MiB combined.

Ordinary data tables only: no formulas, macros, merged cells, external links or original styling. The first row is the header. Select one worksheet per file.

XLSX exports preserve cells as text. Potential formulas in CSV receive an apostrophe prefix. Check the preview and downloaded result.

Preview and results

After processing is complete, the results will be displayed here.

Instructions for use

  1. Select and read an ordinary data table. Its first row is the header.
  2. Choose trimming, empty-row removal or deduplication. Select key columns, or leave none selected to compare full rows.
  3. Clean, export and check the remaining records. The first occurrence of each duplicate is kept.

Input and output examples

Example input
id,name 1,Alice 1,Alice
Example output
id,name 1,Alice

These are demo inputs and sample results, and do not mean that your data has been processed.

Calculation basis and reference materials

The first row contains unique, nonempty headers. Deduplication keeps the first record. Up to 10000 data rows and 100 columns. No formulas, macros, merged cells or preservation of styling.

Content check: · About this site and content description

Related tools

Merge PDFOrganize PDF PagesExcel / CSV Converter