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 July 2026
On this page7
How Operelio reads a workbook
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 from the tab list that appears under the upload. 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.
One caveat on old files: legacy .xls workbooks only expose their first sheet. Save the file as .xlsx to work with its other tabs.
The tab picker is on every tool, 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, switch the merge to combining this workbook's tabs, and pick the tabs. The preview shows the combined row and column counts before you run, and those numbers are computed by the same engine that runs the job, so the banner and the result always 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. Tick Source Tab to add a column recording 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 a merge columns step can fold them into one. Combining tabs is available on Pro and up.
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 Match & pull columns or Compare Files, upload the single workbook and choose a tab as File B. Pick two different tabs and the tools treat them exactly like two separate files.
Split a list back into tabs
Split File's tabs 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. Tabs output writes an Excel file, so it is available on Pro and up.
Or ask Bridgeant
The whole loop (combine the tabs, clean the combined list, split it back into tabs) is one ask to Bridgeant on Pro 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.
Frequently asked questions
Which tab does a tool read by default?
The first tab in the workbook, always. The tool says which tab it is reading before the run, and the tab picker under the upload changes it. Nothing depends on which tab was open when the file was saved.
Do I need a paid plan to work with tabs?
Picking which tab a tool reads is on every plan, including Free. Combining tabs into one list and splitting a list back into tabs are on Pro and up, like merging files and Excel output.
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.