Choose a file

Excel (.xlsx, .xls, .xlsb), OpenDocument, CSV, TSV or JSON

Drop a file here or choose a fileCSV, Excel (.xlsx), Excel 97-2003 (.xls), Excel binary (.xlsb), JSON, OpenDocument spreadsheet, TSV · up to 25 MB each

Options

TrimRemove spaces around text, and non-breaking and invisible characters

Fix numbersTurn numbers and dates stored as text ("1,200", " 350") into real values

Remove duplicatesKeep only the first of rows that repeat

More options (17)

CSV delimiter

CSV output: the character between values

Encoding

CSV/TSV output encoding; 'utf-8-bom' makes Excel read accents correctly

Protect against formula injectionCSV/TSV output: prefix text starting with = + - @ with an apostrophe, so a spreadsheet never runs it as a formula

Sheets

Workbooks: empty for the first visible sheet, 'all' for every visible sheet, or sheet names or numbers separated by commas

HeaderThe first row holds the column names

Header row number

Row number of the column names, when there is a title above the table

Include hidden sheetsWith sheets = 'all', also read hidden sheets

Fill merged cellsRepeat a merged cell's value in every cell it covers

Detect numbers and datesCSV, TSV and JSON: read numbers, dates and TRUE/FALSE written as text as real values, when every value in the column fits

Delimiter

CSV input: the character between values

Collapse spacesReplace runs of spaces inside text with a single space

Numbers use a decimal commaNumbers are written 1.234,56 (decimal comma)

Remove empty rows

Remove empty columns

Columns that define a duplicate

Compare only these columns (comma-separated) to find repeats

Column name style

Rewrite column names: Title Case, lower, UPPER or snake_case

Format

Clean spreadsheet

Choose a file

Options

Get your result

Clean spreadsheet

1Choose a file

2Options

3Get your result

Choose a file

Options

Get your result