Work with multi-tab workbooks
Multi-tab workbooks are first-class: pick the tab a tool reads, combine tabs into one list, use a tab as the second file in a match, or split back into tabs.
By Operelio team · Updated October 13, 2026
On this page7
How Operelio reads a workbook
To combine the tabs of one workbook into a single list, upload it to Merge Files on its own: it opens on the workbook's tabs, all checked, and stacks the ones you keep, matching columns by name. Check Add a Source Tab column to record which tab each row came from.
Every tool works on one grid of rows and columns at a time. When you upload an Excel workbook with several tabs, the tool reads the first tab by default and says so before anything runs. To work on a different tab, pick it beside the file name: most tools have a Sheet menu there. Excel to CSV lists the tabs under Tab, Match & Pull Columns, Compare Files and Merge Files have a Tab menu for each file. Nothing depends on which tab happened to be open when the file was saved.
That covers the everyday case: dedupe the tab you care about, fix its headers, filter it, download the result. The rest of this guide covers the workbook-level moves: treating every tab as one list, matching between tabs, and rebuilding a workbook after cleaning.
Legacy .xls workbooks work the same way: you pick the tab as you would on an .xlsx.
Every tool lets you pick the tab, on every plan. If a preview names a tab you didn't mean, that is the moment to change the pick, before a job credit is spent.
Combine tabs into one list
A workbook where each tab is the same kind of list (one tab per month, per region, per rep) is really one dataset in disguise. Merge Files can stack the tabs of a single workbook into one list: upload the workbook on its own and check the tabs to stack. The preview shows the combined rows and where each tab starts before you run, and its counts come from the same rules the job runs, so the preview and the result agree.
Columns are matched by name, exactly like merging separate files: a column missing from one tab is blank on that tab's rows, and new columns are appended in first-seen order. Check Add a Source Tab column to record which tab each row came from. That column is what lets you split the list back into tabs later, and it powers per-tab breakdowns in the meantime.
If two tabs store the same field under two names (say Country on most tabs and Prospect Location on one), the preview warns you: both are kept as separate columns, blank where a tab lacks them, and Column Manager can merge them into one after you combine. Combining tabs is available on every plan.
Pick a tab for each file
The multi-file tools (Merge Files, Match & Pull Columns, Compare Files) read the first tab of each workbook by default, and every file card has its own tab picker. A merge can read one tab from one workbook and a different tab from another, with no exporting to separate files first.
Use a tab as the second file
Matching and comparing usually take two files. When both lists live in one workbook (2024 on one tab, 2025 on another), you do not need to save a tab out as its own file. In Compare Files, upload the workbook as the original, then pick it again from Recent files as the updated file and choose its other tab. In Match & Pull Columns, upload the workbook as your list, then pick it again from Recent files as the file to pull from and choose its other tab. Pick two different tabs and the tools treat them exactly like two separate files.
Split a list back into tabs
Split File's One Excel workbook output is the mirror of combining: group a list by a column's values and write one Excel workbook with a tab per group, instead of a ZIP of separate files. Each tab keeps only the columns that hold data for its rows, and the grouping column itself can be dropped, since the tab name now carries that information.
Split by the Source Tab column a combine added, and the workbook comes back in its original shape, minus whatever your cleaning removed. One Excel workbook with a tab for each value writes an Excel file, which every plan can download.
Or ask Bridgeant
The whole loop (combine the tabs, clean the combined list, split it back into tabs) is one ask to Bridgeant on Starter and up: "remove duplicates across all the tabs and keep the workbook's shape". Bridgeant shows the plan with real numbers and the cost in jobs before anything runs (a combine, clean, and rebuild is 2 jobs, not one per tab), and your original file is never changed.
Related
Frequently asked questions
Which tab does a tool read by default?
The first tab in the workbook. The tool shows which tab it is reading before the run, and the tab picker beside the file name (Sheet on most tools) changes it. One exception: Merge Files with a single workbook opens on all its tabs, checked, to combine them. Nothing depends on which tab was open when the file was saved.
Do I need a paid plan to work with tabs?
No. Everything in this guide is on every plan, including Free: picking which tab a tool reads, combining tabs into one list, and splitting a list back into tabs.
Can I dedupe across every tab at once?
Yes: combine the tabs into one list first with a Source Tab column, run Deduplicate on the combined list, then split by Source Tab to rebuild the workbook. Or describe the outcome to Bridgeant and it plans the whole thing.
What happens to columns that only exist on some tabs?
Combining matches columns by name. A column missing from a tab is blank on that tab's rows. When you split back into tabs, each tab keeps only the columns that hold data for its rows, so the blanks do not follow the data around.
What about running a tool over many workbooks at once?
Batch reads one tab per file, the first by default, and warns you before the run if any of your files has more than one. You can name a tab there and it applies to every file in the batch. A file without a tab by that name fails on its own, naming the tabs it does have, and the rest of the run carries on.
Does my original workbook change?
Never. Every tool writes a new file; the workbook you uploaded stays exactly as it was.
Ready to get started?
Upload a file and run your first transformation. Free, no credit card required.