Split Spreadsheet

Add a big spreadsheet and split it into smaller files, by row count or by the values in a column.

Drop a spreadsheet here, or click to choose

XLSX, XLS, ODS or CSV. Nothing is uploaded.

Private: everything happens in your browser. Nothing you add is uploaded.

  1. Add a spreadsheetExcel or CSV.
  2. Choose how to splitevery N rows, or by a column.
  3. Downloada ZIP of the smaller files.

Split a large spreadsheet into smaller files

Many systems limit uploads to a few thousand rows, and huge spreadsheets are slow to share. This spreadsheet splitter breaks a big Excel or CSV file into smaller ones: every N rows (for example 1,000 contacts per file), into equal parts, or one file per value in a column, such as one file per region, store, teacher or salesperson. The heading row is repeated at the top of every file.

How to split a spreadsheet
  1. Drop the file onto the box. If it has several sheets, choose one.
  2. Choose a way to split: Every few rows (type how many), Into equal parts (type how many files), or By a column's values (pick the column).
  3. Choose the format. One Excel file, many sheets keeps everything in one workbook with a tab for each part.
  4. Click Split and download. The files come together in a ZIP.

Questions

Is the heading row copied into each file?

Yes, as long as “First row is headings” is ticked.

How are files named when splitting by a column?

Each file is named after its value, for example “Sales - North.xlsx”. Empty cells go into a file called “(blank)”.

More spreadsheet tools

Excel to CSVSave any sheet as a CSV file. CSV to ExcelTurn CSV files into proper spreadsheets. Merge SpreadsheetsCombine sheets or files into one. Remove Duplicate RowsFind and remove repeated rows. CSV ViewerOpen and search big CSV files instantly.