Spreadsheet tools

Data profile

Understand a dataset in seconds: each column's type, blanks, distinct values, ranges, averages, most common values, and problems such as numbers stored as text.

FreeNo sign-upFiles deleted after processing

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

Most common values listed

Most common values listed per column

More options (7)

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

Data profile

1Choose a file

2Options

3Get your result

Choose a file

Options

Get your result