Login
Book a demo

Split CSV, Excel, or Google Sheets by Column Value

One file per group, or one tab per group — your choice

Break a single spreadsheet into multiple files (or tabs) based on a column’s unique values. Pick a column like “region” or “email”, and get one file per distinct value. CSV, Excel, Google Sheets, BigQuery, or REST API — free, in-browser, no signup.

Use the tool

How it works

Step 1
Connect your data
Upload CSV, Excel, or TSV, pick a Sheet from Google Drive, run a BigQuery query, or pull from a REST API.
Step 2
Pick the split column
The column whose unique values define the split.
Step 3
Choose output format
One file per value, or one tab per value inside a single Excel file.

Want to schedule this, not just run it once?

Splitting the same master report every week for different teams? Sheetgo can schedule this split, generate fresh per-team files automatically, and email them to each owner — no copy-paste.

Get Sheetgo on Google Workspace Marketplace

Frequently Asked Question

Dive deeper into splitting spreadsheets by value

Get the answers to your questions about splitting data by column

Can I split into one file per value, or one tab per value?

L
K

Both. Choose file-per-value (e.g., 10 separate Excel files) or tab-per-value (one Excel file with 10 tabs).

What if a value appears in only one row?

L
K

Each unique value produces its own subset, even if it contains just a single row.

Does the header row get copied to each split?

L
K

Yes. Every split file or tab gets its own copy of the header row.

Can I split data from BigQuery or an API?

L
K

Yes. Connect a BigQuery query or a REST API response and split the returned rows by any column.

What else can I do with the Sheetgo add-on?

L
K

Beyond scheduled automation, the Sheetgo add-on — powered by Sheetgo Workflows — can send personalized emails from spreadsheet rows, generate Google Docs or PDFs as mail-merge outputs, chain multiple processing steps into one flow (for example: filter → merge → dedupe → email), and orchestrate approvals across teams. Everything runs unattended once set up. One-click install from Google Workspace Marketplace.

Which data sources can I connect to with Sheetgo?

L
K

With the Sheetgo add-on, your automated flows can pull from Google Sheets, Excel, CSV files in Google Drive, BigQuery (with live SQL queries), and any REST API using Bearer Token, API Key, or Basic authentication. The output can land back in a spreadsheet, a generated Google Doc or PDF, an email, or any combination chained in a Workflow.

FAQ image