One file per region, customer or month, equal parts of N rows, or one file per sheet. Every part keeps the header row, and huge CSV files are split into pieces that fit in Excel.
No file at hand? (an order list to split by region).
Each sheet of the workbook becomes its own file, named after the sheet.
The file is read and split by JavaScript in your browser, in a background worker. It is never uploaded, so it is safe to split customer lists, payroll or sales data. The page only downloads its own code and the open-source SheetJS, PapaParse and fflate libraries from this site, and keeps working if you go offline after it loads.
Excel opens at most 1,048,576 rows per sheet, and it silently drops the rest of a bigger CSV. This tool reads CSV files as a stream, in blocks of a few megabytes, so the whole file never has to fit in memory at once. Choose “Every N rows” and the “Excel maximum” preset to get parts of 1,048,575 rows plus the header, each of which opens completely in Excel. CSV output is the fastest and lightest; Excel output of such large parts works but needs much more memory.
The text of a CSV is copied exactly into CSV parts, with the same separator, and saved as UTF-8 so accents open correctly in Excel. When you choose Excel output, values that are clearly numbers become numbers, while codes with leading zeros, such as 00123, stay as text.
When you split by a column, each file is named after the value, for example North.xlsx or Acme Ltd.csv. Characters that are not allowed in file names (\ / : * ? " < > |) are replaced with an underscore, names are shortened to 100 characters, reserved Windows names such as CON are prefixed, and values that differ only in upper or lower case get a number so no file overwrites another. Rows with an empty value go to (empty).xlsx. In a single workbook, sheet names are limited to 31 characters, as Excel requires.
Excel has no “split” button. The usual ways are filtering by each value and copying the visible rows to a new workbook, which is slow with dozens of values, or a VBA macro, which needs a desktop version of Excel and a macro-enabled file. Power Query can load a filtered copy per value, but you have to build one query for each output. This tool does the whole loop in one click.
Yes. It is 100% free, with no usage limits, no account, no sign-up and no paid plan. Splitting by column value and Excel output are included, not paid extras.
No. The file is processed in your browser. The page only downloads its own code and libraries from this site. If you accept analytics cookies, Google Analytics receives anonymous usage data such as page views, never the contents or names of your files.
Choose the file, keep “By column value” selected and pick the column, for example Region. You get one file per distinct value, named after it, each with the header row and only its rows.
Yes. Choose “One workbook, one sheet each” as the output. You get a single .xlsx with one tab per value or per part, with names shortened to 31 characters as Excel requires.
Choose “Every N rows” and the “Excel maximum” preset. The CSV is read in streaming, so it does not have to fit in memory, and each part has 1,048,575 rows plus the header, so it opens completely in Excel.
Values, dates and number formats are kept. “One file per sheet” also keeps column widths and merged cells. Fonts and colours are not copied, and formulas are replaced by their calculated values.
There is no fixed limit or quota. CSV files are streamed and can be several gigabytes when splitting by rows into CSV parts. Workbooks are loaded in memory, so the practical limit is your device: keep them under about 20 MB on phones.
Analytics: only if you accept cookies, the page loads Google Analytics (through Google Tag Manager) to count visits and see which tools are used. It never receives the contents or names of your files. You can change your choice at any time with “Cookie settings” at the bottom of the page.