Split Excel Rows

Takes one sheet and writes each row out as its own .xlsx, with the header row on top of each one so the file still reads like a table. Formulas become their last saved result, because a formula moved to row 2 would quietly point at the wrong cells.

  • No upload
  • No account
  • No watermark
  • No file limit
Drop your files hereor click to chooseNo size limit and no count limit — only what your own computer can hold.

Your files

    Nothing chosen yet.

    Where your file goes

    Nowhere. This page downloads a small program into your browser, and that program reads the file straight from your disk. The program comes from this site like any image or stylesheet — but your file only ever travels from your disk into your own browser tab.

    Why this one

    What you get that the big converters cannot offer.

    The header comes along

    Each file gets row 1 on top and one data row under it, so the columns still have names. Turn it off if your sheet is plain data with no headings.

    Name the files after a column

    Point it at the invoice number or the customer name column and you get INV-2041.xlsx instead of row-0037.xlsx. Slashes, colons and the other characters Windows rejects are swapped out, and duplicates get -2, -3 after them.

    A real limit, said out loud

    2000 files in one run. Above 200 it asks first and shows you the size, because your browser has to hold every file in memory at once. Give it a row range and do a 10000-row sheet in batches.

    Everything past one file is a ZIP

    A page that fires 300 downloads in a row gets blocked by the browser. One ZIP always works.

    How to use it

    Choose an .xlsx, .xls or .csv file.

    Say which sheet, which rows, and which column should name the files. All three can be left blank.

    Press Start, confirm the count if it asks, and download the ZIP.

    When people use it

    A form that wants one record per file

    Some portals and imports take a single record at a time, and you have a sheet with four hundred of them.

    Mail merge that needs separate files

    One file per recipient, each one still carrying the column headings.

    Handing out rows without the rest of the sheet

    Each supplier gets their own line and nobody sees the other lines.

    Questions

    Does each file keep the header row?

    Yes by default — row 1 goes on top of every file, with the data row under it. Untick the box if your sheet starts straight into data with no headings, and each file will hold that one row only.

    What happens to formulas?

    They are replaced by the value the spreadsheet last saved. This is deliberate: a formula like =B7+C7 moved into row 2 of a new file would point at row 7 of that file, which is empty, and quietly give you the wrong number. If the file was written by a program rather than by Excel it may have no saved results, in which case those cells come out blank and the page tells you how many.

    How many files can it make?

    2000 in one run. Past 200 it stops and asks, because every file is held in your browser’s memory until the ZIP is built. For a bigger sheet, put something like 2-2000 in the row box, then 2001-4000, and so on.

    Can I choose the file names?

    Name them after any column — type the column letter or the heading text. Empty values, duplicates and characters Windows will not accept are handled: you get a numbered name, a -2 suffix, or an underscore in place of the character.

    Does it take CSV?

    Yes. A CSV is read as UTF-8 text and the files come out as .xlsx. Formatting is not a question there — a CSV has none.

    Other tools