Ever wondered how to separate a huge dataset in Google Sheets into smaller groups the easy way? Split Sheet is your formula-free answer! There are only 3 SIMPLE SETTINGS: 

1. SELECT SHEET – SIZE DOESN'T MATTER
No matter how big your table is, the tool will divide your Google sheet without any formulas.

2a. DIVIDE GOOGLE SHEET BY KEY COLUMNS even without headers ;)
This add-on splits your Google sheet into multiple sheets based on the contents in the selected columns. The more key columns you choose to consider, the more precise and narrowed down your groups of data will be. A special option will let the tool process your summary table even if it doesn't have headers.

2b. SPLIT Google sheet BY N ROWS
Alternatively, you can split data by the number of rows you specify. Cut the table into equal-sized parts or set up several ranges of different amounts of rows.

3. GET RESULT IN A CURRENT FILE / NEW FILE / MULTIPLE NEW SPREADSHEETS
Split Google sheet and place all outcome separate sheets to a current file or have the tool create a brand new spreadsheet and paste all sheets there.

AUTO-UPDATE SPLIT SHEETS
Make the add-on return split results with formulas so they update automatically as your source table changes.

EXTRA AUTOMATION
  - save your splitting settings into scenarios to reuse later in a click
  - share saved scenarios with other Split Sheet users

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions about the add-on, please post them here:
https://www.ablebits.com/docs/google-sheets-split-sheet/
We'll be happy to assist!

Split Sheet is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-add-ons/index.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:
***** V1.5 (18 Dec 2024) *****
★ New features ★
- Live updates are now available for splitting by rows! Formulas will ensure all newly added rows are reflected in each split sheet in real time.
- Scenarios. Save the options you use most often and give this set a name – this is your scenario. Once you run it, your data will be processed right away, and you won't need to go over the same steps again.
- Share saved scenarios. Export and import your saved scenarios to share with your teammates or just make their backups on your Drive or computer.

Improved:
- When splitting by groups of rows, you can enter ranges not only using colons (1:20), but also using hyphens (1-20).
- When splitting by groups of rows, skip the last number in the last range to take all remaining rows to the last sheet, e.g. 70:
- UX and UI improvements.

***** V1.4 (05 Sep 2024) *****
★ New features ★
Get your split data updated live – with a formula! Have the add-on build formulas for each split sheet so the result constantly auto-updates. The formulas are always connected to your original table. Hence, all source changes, all new cells, rows and columns will appear in the split tables automatically.

Improved:
You can now explore more Ablebits add-ons from the corresponding Extensions menu.
Minor UX and UI improvements.

Fixed:
Cut zeros and spaces from the names of the split sheets.

***** V1.3 (16 Dec 2022) *****
★ New features ★ 
- A new way to split – by the required number of rows.

Improved:
- Now treats matching records written in different text cases as the same.
- Minor UX and UI improvements.

***** V1.2 (29 Apr 2022) *****
Improved:
- The limit for total cells in a spreadsheet is expanded to 10 million cells.
- When you place results to a new spreadsheet & multiple separate spreadsheets, they are now created in your Drive right next to a file with your original table.
- Minor UX and UI improvements.

Fixed:
- Couldn't split sheets from files that belong to other users.
- Didn't process ranges selected as rows, e.g. 1:100.

***** V1.1 (5 May 2021) *****
★ New features ★
- A new way to split – to multiple new spreadsheets.

Improved:
- Auto-select the entire range by clicking the gray rectangle between column and row headers.
- Minor UX and UI improvements.

Fixed:
- Ignored the range you selected before running the add-on and picked up the entire used range anyway.
- Didn't process a new range selected before hitting 'Split'.
- Couldn't create a new sheet if it was named after the record with 100+ chars.
- Didn't work if you run the add-on from a sheet with its own separate chart.