Split Google Spreadsheet Data into Multiple sheets

Data Splitter is a Google Sheet add-on which splits your Google sheet data into multiple sheet based on the contents in the selected column.


  • Get output sheets on current spreadsheet or on a new spreadsheet
  • Give you option to Select number of columns you want to have on the output data sheet.
  • Apply colors and borders on the output data generated.
  • Apply subtotal on a numeric column selected.

This is an example sheet with data on first sheet which is splitted on multiple tabs on the basis of contents in column 'Title'

Data Split

Let us know for any issue, query or suggestions