Spreadsheet tools

Split spreadsheet

Split a spreadsheet into several files: every N rows, one per value of a column (say, one per region), or one per sheet.

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

Mode

rows: a file every N rows; column: a file per distinct value of a column; sheets: a file per sheet

Rows

rows mode: data rows per file (each file repeats the header)

Column

column mode: the column whose values name the files

More options (11)

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

Format

keep: the input's format (other workbooks become xlsx)

Split spreadsheet

1Choose a file

2Options

3Get your result

Choose a file

Options

Get your result