Skip to content
Cleanup & Conversion Toolkit

Table cleanup and column shaping

CSV / Excel Cleaner

Open a CSV, TSV or Excel file in the browser, remove blank rows, trim extra spaces, delete exact duplicate rows, keep only needed columns, and download the cleaned result without sending the file to a server.

In-browser processing

Supported formats

csvtsvxlsxxls

File setup and cleanup controls

Upload one table file, choose the sheet and cleanup options on the left, then review counts and previews on the right before downloading the result.

CSV / Excel file

Choose one CSV, TSV, XLSX or XLS file, or drag and drop it here.

Source settings

Turn the header option on when the first row contains column names instead of normal data.

Columns to keep

Pick only the columns you want to keep in the exported file.

Cleanup options

The selected file is read and cleaned inside the browser. The site does not include a mechanism that sends this tool input for AI training.

Export settings

When text output is selected, you can export as normal CSV or tab-separated TSV.

Output format

Cleanup summary and preview

Preview ready

No file selected yet

Add one CSV or Excel file first and the sheet summary and table preview will appear here.

What you can do

  • Load one CSV, TSV, XLSX or XLS file directly in the browser
  • Choose a sheet for Excel files and preview the table before and after cleanup
  • Remove blank rows, trim surrounding spaces, delete exact duplicate rows and drop empty columns
  • Keep only selected columns and export the cleaned result as CSV, TSV-style text or XLSX

Who this is for

  • People tidying exported customer lists, order data or survey results
  • Teams removing blank rows and repeated records before sharing a spreadsheet
  • Anyone who wants a quick local cleanup tool instead of opening a full spreadsheet workflow

How to use it

  1. 01

    Add the file

    Choose one CSV, TSV, XLSX or XLS file, or drag and drop it into the upload area.

  2. 02

    Pick the sheet and cleanup options

    For Excel files, choose the sheet to work on, then turn header, trimming and cleanup options on or off.

  3. 03

    Review counts and previews

    Check the before-and-after row and column counts, then compare the original and cleaned previews.

  4. 04

    Download the cleaned file

    Export the selected sheet as CSV or XLSX once the result looks ready.

Examples

Remove blank rows and repeated entries from a mailing list

Before

Name,Email
Alice,alice@example.com

Bob,bob@example.com
Bob,bob@example.com

After

Name,Email
Alice,alice@example.com
Bob,bob@example.com

Note: Blank rows are removed and an exact duplicate row is deleted.

Trim spaces and keep only the columns needed for handoff

Before

 Order ID , Customer , Notes , Internal Memo 
1001, A Corp , urgent , draft
1002, B Corp, , keep inside team

After

Order ID,Customer,Notes
1001,A Corp,urgent
1002,B Corp,

Note: Spaces are trimmed and only the selected columns are kept in the output.

Things to watch

  • The exported file keeps the cleaned values, but it does not preserve original Excel styling, formulas, merged cells or hidden-sheet settings.
  • Very large spreadsheets may take longer to parse and preview in the browser.
  • The header-row setting changes how the first row is treated, so confirm it before downloading.

FAQ

Does this upload my spreadsheet anywhere?

No. The tool is designed to parse, clean and export the file locally in the browser.

Can old XLS files be opened?

Yes, basic XLS support is included. Some older files with uncommon encodings or unusual structures may still fail to load.

Will the original Excel formatting stay the same?

No. The export focuses on cleaned table values. Formatting, formulas, merged cells and workbook-level layout are not preserved.

Related tools

Text Cleanup Tool

Use it when you also need to clean copied notes or list text after fixing spreadsheet rows.

Batch File Rename Tool

Helpful when cleaned exports need clearer filenames before sharing.

Related articles

How to remove blank lines and duplicates from CSV

Read the cleanup order for blank rows, whitespace, duplicates and column selection before exporting a cleaner file.

Guide library

Browse step-by-step guides for common cleanup and conversion tasks.

FAQ

Check how input data is handled, supported formats and common usage questions.

Update history

  1. Added the CSV / Excel Cleaner tool with local parsing, sheet selection and before-and-after table preview.

  2. Added cleanup controls for blank rows, trim, duplicate removal, empty-column removal, column selection and CSV/XLSX export.