Better Sheets All add-ons

Split Tabs

A free Google Sheets™ add-on

Built by Better Sheets · Free on the Google Workspace Marketplace · No account needed

What Split Tabs does

A free Google Sheets™ add-on that turns each tab of a spreadsheet into its own Google Sheets file. Pick the tabs, press Split, and get one file per tab in a new Drive folder.

  • ✅ Pick any tabs, or all of them, from a checklist.
  • ✅ Name the new files after the tab, or after the file and the tab.
  • ✅ Formulas that point at other tabs keep their values instead of turning into #REF!.
  • ✅ Formatting, column widths, frozen rows and charts come along with each tab.
Split Tabs sidebar in Google Sheets with four tabs ticked, ready to split into separate files

How Split Tabs uses your Google data

  • Lists the tabs of the spreadsheet you open it in, so you can pick which ones to split.
  • Copies each tab you pick into a new Google Sheets file in your own Google Drive. It never changes your original spreadsheet.
  • Can create one new Drive folder to hold those files. It can only see files and folders it created, not the rest of your Drive.
  • Runs entirely inside Google Sheets. It does not send your spreadsheet data to Better Sheets or anyone else.

Google permissions it asks for

Read the tabs you pick and create the new spreadsheets https://www.googleapis.com/auth/spreadsheets
Create the folder and move the new files into it (only files it creates) https://www.googleapis.com/auth/drive.file
Show its menu and sidebar inside Google Sheets https://www.googleapis.com/auth/script.container.ui

Full details: Split Tabs Privacy Policy · Terms of Service