How to split a Google Sheet into separate files
By Jake Marsh · Updated
To split a Google Sheet into separate files, open Extensions, Rowsplit, Open Rowsplit, click New split, pick the tab and the column to split by, and under Results go to choose A separate spreadsheet per value. Pick a Drive folder, click Preview to see the files it will make, then Save and run. Each value gets its own spreadsheet with the header row and only its rows.
One file per value or one file with a tab per value
| Choose | You get | Good for |
|---|---|---|
| A separate spreadsheet per value | One file for each value, in one folder | Sending or sharing each group on its own |
| One new spreadsheet, a tab per value | One new file, a tab for each value | A tidy copy to hand on without touching the original |
| New tabs in this spreadsheet | Tabs next to the source | Working with the groups yourself |
Steps
- Open Rowsplit from the Extensions menu and click New split.
- Pick the Tab to split and the number of Header rows.
- Under Split by, choose Values in a column and tick the column, such as Client. For a fixed size instead, choose Blocks of rows and type the rows per file.
- Under Results go to, choose A separate spreadsheet per value.
- Set the File name. The default is
{value} - {spreadsheet}, such as "Hill Farms - Orders 2026". Add{date}to stamp each run's date, or{rows}for the row count. - Pick the Folder. Use a new folder lets Rowsplit make one in your Drive; Choose a folder puts the files in a folder you already have.
- Leave Keep an index tab here with a link to every output ticked to get a tab in your source spreadsheet listing every file with a link.
- Click Preview, check the list of files and row counts, then Save and run.
What goes into each file
Each file gets the header rows and that value's rows, with number formats, colors, bold and italic, alignment, column widths and frozen rows. Formulas arrive as their results, so a file shows the numbers without depending on the source. Conditional formatting, data validation, merged cells, borders and notes stay behind.
To leave columns out, such as internal notes or cost prices, open More options and tick only the columns to copy.
Running it again
Click Run now on the saved split after the source changes. Rowsplit writes into the same files rather than making new ones, so links people have bookmarked keep working. A file for a value that no longer appears in the data is moved to your Drive trash. Set a schedule under Schedule (every day, week or month, around an hour you pick) to keep the files current without opening the sheet.
To give each person access to their own file as part of the same run, see how to share only part of a Google Sheet.
What it costs
Rowsplit is $4.99 a month or $39 a year per Google account. Free trial: 30 days or 50 runs, whichever comes first. No card needed. Every plan and the install link are on the Rowsplit page.
Rowsplit: Split Sheets into Tabs & Files
Split a Google Sheet into tabs or separate spreadsheets by column value, shared and refreshed automatically $4.99 a month or $39 a year per Google account.
Questions
How many files can one split make?
Up to 200. A run that takes longer than a few minutes keeps going in a second step on its own.
Can I split by two columns into files?
Yes. Tick both columns under Values in a column and each combination, such as "East, March", becomes a file.
Does Rowsplit see the rest of my Drive?
No. It can open only the files and folder it creates or that you pick, and the spreadsheet you're in.
Can I send the files to the people they're about?
Yes. Rowsplit can share each file with the emails in its rows or in a lookup tab, as part of the same run.
More Rowsplit guides
More Google guides
- How to show dotted-line reporting on an org chart from Google Sheets (Rowtree)
- How to create barcodes in Google Sheets (Rowcode)
- How to email each person only their rows from a Google Sheet (Scheduled Sheet Reports)
- How to export more than 1,000 rows from Search Console (Queryledger)