How do I split data into separate sheets by column value in Excel?

Without an add-in you can use the PivotTable 'Show Report Filter Pages' trick (which makes PivotTables, not raw rows) or a VBA macro. Tellsheet's Split to Sheets groups your table by a key column and writes each distinct value to its own worksheet with the header repeated, leaving the original untouched.

Does splitting change my original data?

With Tellsheet's Split to Sheets, no — it reads your table and creates new worksheets; your source data stays exactly as it was.

What's the reverse — combining sheets back?

Use Combine Sheets, which stacks every worksheet into one table with a column marking each row's source sheet. It's the inverse of Split to Sheets.

Home › Excel Guides › Split Data into Multiple Sheets in Excel

How to Split Data into Multiple Sheets in Excel

One big table, and you need a separate tab per region, per rep, or per month. Excel has no "split to sheets" button — here's the PivotTable workaround, the VBA route, and a one-click way.

Last updated: August 2026

One table by Region		Sheets
West, East, North rows	→	“West” sheet
		“East” sheet
		“North” sheet

Method 1 — PivotTable "Show Report Filter Pages"

Build a PivotTable from your data.
Drag your key field (e.g. Region) into the Filters area.
PivotTable Analyze > Options > Show Report Filter Pages → one sheet per value.

Clever, but each sheet is a PivotTable summary, not a copy of your original rows — often not what you want.

Method 2 — a VBA macro

A loop that filters the key column and copies each group to a fresh sheet gives you real rows, but means writing/maintaining macro code and saving as .xlsm. It also can't run in Excel on the web.

The 1-click way — Tellsheet

Split to Sheets groups your table by a key column and writes each distinct value to its own worksheet, header repeated — real rows, not a PivotTable. Your original data isn't touched. Works on Windows, Mac, and Excel on the web (no macros). The exact inverse is Combine Sheets, which stacks them back into one table.

Frequently asked questions

How do I split by a column into separate sheets?

PivotTable "Show Report Filter Pages" (makes PivotTables) or VBA (real rows), or Tellsheet's Split to Sheets in one click for real rows with no macro.

Does it change my original data?

No — Split to Sheets creates new worksheets and leaves your source table as-is.

How do I combine the sheets back?

Combine Sheets stacks every sheet into one, with a column marking each row's source — the inverse operation.

Will it work on Excel for the web?

Yes — Tellsheet runs on Windows, Mac, and the web; VBA macros don't run on the web.

Related Excel guides

Split to sheets in one click

Split to Sheets turns a key column into one worksheet per value — real rows, your original untouched.

Get Tellsheet free See pricing