How to automatically split an excel sales report into one sheet per region
- Step 1Export the consolidated sales data to one sheet — Pull the roll-up from your CRM, BI tool, or ERP into a single
.xlsxor.csvwith all regions in one flat sheet. The tool reads the first sheet only, so make sure the data — not a cover or summary tab — is the first sheet. - Step 2Drop the file onto the Conditional Splitter — Drag the file onto the upload zone. SheetJS parses it in your browser; no revenue data is uploaded.
.xlsx,.xls,.ods, and.csvare all accepted. - Step 3Type the region column header exactly — Enter the region column's header into the Split column box — for example
RegionorTerritory. It is free text, so it must match your header precisely (case- and space-sensitive). A mismatch sends every row to one__blank__tab. - Step 4Run the split on Pro tier — The splitter is Pro-and-up. With a Pro account you can split files up to 50 MB / 100,000 rows; Pro-media handles 200 MB / 500,000 rows. Click run to bucket rows by region and assemble the workbook.
- Step 5Reconcile the per-region counts — The summary shows
N sheets createdplus a badge per region with its row count. Sum the badges and confirm the total equals your input row count. An unexpected tab —EMEAandemeaboth present, or a stray__blank__— flags inconsistent region values to clean up. - Step 6Download and distribute split-output.xlsx — Download the workbook. Forward it whole, or extract a single region's tab in Excel (right-click → Move or Copy → new book) to send one manager only their territory.
How the regional split behaves
The tool has one control. Below is the fixed behaviour relevant to a regional sales split — there is no multi-region grouping, no aggregation, and no totalling.
| Aspect | Behaviour | What it means for a sales report |
|---|---|---|
| Grouping | One tab per unique value of the region column | EMEA, AMER, APAC each become a tab — exactly the distinct values present |
| Aggregation | None — rows are bucketed, not summed | It distributes rows; it does not compute regional totals. Add a SUM in each tab afterward, or use the pivot generator for totals |
| Region spelling | Exact, case-sensitive match | EMEA and emea produce two separate tabs — normalise spellings first |
| Empty region cell | Grouped under __blank__ | Rows missing a region are pooled in one tab so you can spot and assign them |
| Header row | Copied to every regional tab | Each manager opens a self-describing sheet |
| Output | One split-output.xlsx workbook | Not a ZIP, not one file per region — a single multi-tab workbook |
Tier limits for regional sales files
Limits apply to the input file. Region count is unbounded by the tool; the practical ceiling is browser memory and Excel.
| Tier | Max file size | Max rows | Typical fit |
|---|---|---|---|
| Free | 5 MB | 10,000 | Blocked — Pro required |
| Pro | 50 MB | 100,000 | Monthly multi-region roll-ups |
| Pro-media | 200 MB | 500,000 | Year-to-date transaction-level data |
| Developer | 500 MB | Unlimited | Multi-year line-item exports |
Cookbook
A worked regional split with the reconciliation step that catches dirty region values. Figures anonymised.
Split a monthly sales roll-up by region
One flat export with every territory becomes a tab per region. Each manager gets only their rows, headers included.
Input (Sales sheet): Account | Region | Revenue Acme | EMEA | 12000 Globex | AMER | 4500 Initech | EMEA | 8000 Umbrella| APAC | 22000 Split column: Region Output: split-output.xlsx Tab "EMEA": Acme (12000), Initech (8000) Tab "AMER": Globex (4500) Tab "APAC": Umbrella (22000) Results: 3 sheets created — EMEA (2), AMER (1), APAC (1)
Catch inconsistent region spellings
Exact matching means casing and abbreviation differences split into separate tabs. The badge summary makes this obvious so you can normalise and re-run.
Input region values seen: EMEA, emea, E.M.E.A. Results panel: EMEA (140) emea (12) E.M.E.A. (3) Three tabs for one region. Fix: normalise the Region column to a single spelling first (case converter for casing), then re-split so EMEA = one tab (155).
Reconcile slices to the company total
Before forwarding, confirm the per-region row counts sum to the input total. A shortfall usually hides in __blank__.
Input rows: 1,000 Results: EMEA (412), AMER (388), APAC (193), __blank__ (7) Check: 412 + 388 + 193 + 7 = 1,000 ✓ The 7 __blank__ rows have no region — open that tab, assign each to a territory, then re-split for a clean set.
Add a regional total after splitting
The splitter distributes rows but does not total them. Drop a SUM into each tab, or run a pivot for a one-shot summary.
After splitting on Region:
In each tab, add below the data:
=SUM(C2:C9999) <- regional revenue total
For an all-in-one summary instead of per-tab sums, run
the pivot generator on the original flat file with:
rows = Region, values = Revenue, aggFn = sumSend one region as a standalone file
The output is one workbook. Extract a single region's tab in Excel for one-manager delivery.
1. Split on Region -> split-output.xlsx (4 tabs) 2. Open in Excel 3. Right-click "APAC" tab -> Move or Copy... 4. To book: (new book), tick Create a copy -> OK 5. Save as apac-sales.xlsx and send to the APAC lead
Edge cases and what actually happens
Region column typed with wrong case or a typo
All rows go to __blank__The split column is matched exactly. Typing region when the header is Region, or Territory with a trailing space, matches no column — every row reads as missing and pools into one __blank__ tab. A single all-rows __blank__ tab is the tell-tale sign; fix the header text and re-run.
Same region spelled inconsistently
Splits into multiple tabsEMEA, emea, and E.M.E.A. are three distinct values, so they produce three tabs. The tool does no normalisation. Standardise the region column first (the case converter handles casing) so each territory collapses into one tab.
You expected regional totals
By design — no aggregationThe splitter distributes rows; it never sums or counts revenue. Each tab holds raw rows. Add a SUM in each tab, or use the pivot generator for a totalled regional summary in one step.
Rows with a blank region
Grouped under __blank__Sales rows with no region land in a __blank__ tab by design, so unassigned revenue is visible rather than dropped. Reconcile and backfill these before final distribution to a regional manager.
Data on a later sheet
Only the first sheet is splitMany sales workbooks lead with a summary or cover tab. The splitter reads only the first sheet, so if the raw data is on tab 2, the output won't contain it. Move the data sheet to the front before uploading.
Very long region or market names
Truncated to 31 charsA market name longer than 31 characters is truncated in the tab name (the row data is untouched). Two long names sharing their first 31 characters collide and the second gets a _2 suffix. Check the badge labels to map tabs back to full market names.
Free-tier account
Pro tier requiredFree accounts are blocked with Conditional Splitter requires Pro tier. Upgrade to Pro (50 MB / 100,000 rows) or higher to split regional data.
Transaction-level file exceeds the row limit
Rejected at uploadA line-item export over your tier's row cap (100,000 on Pro, 500,000 on Pro-media) is rejected before processing. Either pre-aggregate to one row per account-region, or step up to Developer for unlimited rows.
Currency and revenue formatting
Preserved as displayedRevenue and margin columns are copied into each tab as the reader formats them. Currency symbols stored as part of the cell text carry through; values stored as raw numbers stay numeric. The split inspects only the region column, leaving every financial column intact.
Hundreds of micro-territories
Supported but unwieldySplitting on a high-cardinality field like postal code or rep ID produces hundreds of tiny tabs that are slow to open. For sales distribution, split on a coarse dimension (region, country, or named territory) — there is no tool-side cap, but Excel and your browser have practical limits.
Frequently asked questions
Does this total the revenue per region?
No. The tool distributes rows into one tab per region; it does not sum or aggregate. Each tab holds the raw rows for that region. To add totals, drop a SUM into each tab after splitting, or use the pivot generator with rows = Region and aggFn = sum for a totalled summary.
Why did one region split into two or three tabs?
Because the region values aren't spelled identically. EMEA, emea, and E.M.E.A. are three distinct strings, so each becomes its own tab. Normalise the region column first — the case converter fixes casing — then re-split for one tab per territory.
Which column should I name for a regional split?
Type the exact header of the column holding the territory value — often Region, Territory, or Market. The box is free text and case-sensitive, so spelling must match your header exactly. If every row lands in __blank__, the column name didn't match.
Do regional managers get a usable header on their tab?
Yes. The header row is copied onto every tab, so each manager opens a self-describing sheet ready to filter and sort — no need to add column titles manually.
How do I make sure no territory got dropped?
Add up the per-region row-count badges in the results panel and confirm the sum equals your input row count. If it falls short, check for a __blank__ tab capturing rows with no region — those are the gaps.
Is the output one file per region?
No — it's a single split-output.xlsx workbook with one tab per region. To send one region as its own file, split here, then right-click that tab in Excel → Move or Copy → (new book) and save it.
Can I split by region and then by product?
Not in one pass — the tool groups by a single column. Either split on Region first and then run each regional tab through the splitter again on Product, or build a combined Region|Product helper column and split on that.
Does it read every sheet in my sales workbook?
No, only the first sheet. If your workbook opens with a cover or pivot summary, move the raw data sheet to the front (or save it standalone) before uploading, or the split will run against the wrong sheet.
How big a sales file can I split?
Pro handles 50 MB / 100,000 rows, Pro-media 200 MB / 500,000 rows, Developer 500 MB / unlimited. Free tier is blocked. The number of regional tabs has no fixed cap; it's limited by browser memory and Excel.
Will my revenue figures be uploaded?
No. The split runs entirely in your browser via SheetJS. Account names, revenue, and margin never reach a server. Only an anonymous, content-free usage counter is recorded for dashboard stats, which you can opt out of.
Can I clean the data before splitting?
Yes, in sequence. Standardise region spellings or dates first — for dates use the date standardiser — then split. For deduplicating overlapping account rows, run the fuzzy deduplicator first.
What if a region name is longer than a tab can hold?
Excel caps tab names at 31 characters, so longer market names are truncated in the label only — the row data is intact. If two long names share their first 31 characters, the second tab gets a _2 suffix. Use the badge labels to map tabs back to full names.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.