App Icon
Split Google sheet into multiple sheets by columns.
Works with:
50,554
Overview
Ever wondered how to separate a huge dataset in Google Sheets to smaller groups of related records the easy way? Split Sheet is your formula-free answer. There's just 1 STEP with only 3 SIMPLE SETTINGS: 

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

2. 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.

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.

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-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:

***** 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.
Additional information
PricingNot available
Privacy policy
Terms of service
Split Sheet will ask for the permissions shown below. Learn more
Split Sheet will need access to your Google account
This will allow Split Sheet to :
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Lauren Whidden
October 7, 2021
Works great!
Is this review helpful?
Yes
No
Profile Picture
A User of Split Sheet
May 5, 2020
Amazing. I've been waiting for this tool for almost 2 years! Finally! Thank you!
Is this review helpful?
Yes
No
Profile Picture
Emilia Urban
January 19, 2021
Love split file! It does just what I need easily while still being completely affordable! Not to mention, they have more features in the works for this add-on. Definitely better than competitors available as google add-ons.
Is this review helpful?
Yes
No
1-3 of 3
Search
Clear search
Close search
Google apps
Main menu