Multi-Tab Combiner & Count-by-Week

Thirty-five tabs of exported timesheets. One question: how many shifts did each person work each week? The usual answer is a fragile mega-formula that crawls every time someone adds a row. This free multi-tab combiner does the whole job in your browser instead: drop one .xlsx export or a handful of CSVs, pick your columns and period, and get a count-by-week pivot plus one combined master file back. No sign-up, nothing uploaded. It’s the simplest way to turn a pile of exported tabs into answers you can actually use.

Drop an .xlsx export or a few .csv files — every tab is stacked into one master table tagged with its tab name, then pivoted by week, semi-month or month. Everything runs in your browser; nothing is uploaded.

Drop .xlsx, .xls or .csv files here

Each workbook tab becomes a source tab. Untick tabs below to exclude them.

Point at the row that holds your column names if it is not row 1.

Distinct count tallies unique Value entries per period.

Adds a second row level: each period × group gets its own row.

Tabs to include

What this multi-tab combiner does

Drop in one .xlsx workbook — or several CSV files — and it reads every tab, finds the header row you point at, and stacks every row into one master table tagged with its tab name. Excel serial dates become real dates automatically, so exports that store dates as numbers still land in the right buckets.

Then each row gets bucketed into a period on your date column: Monday-start weeks, Sunday-start weeks, semi-monthly (1–15 and 16–end), calendar months, or a custom period list you paste in. The pivot puts periods down the rows and the distinct values of your value column — staff names, categories, regions — across the columns, with totals on both edges. Count the rows, sum an amount column, or take a distinct count.

Happy with the pivot? Copy it as TSV for pasting straight into Sheets, download the pivot as CSV, or download the combined master CSV with a Tab column so you can audit every row back to its source.

How to combine multiple sheets count by week

The quickest route from export to answer takes about a minute:

  1. Start by exporting your Google Sheet as .xlsx (File → Download → Microsoft Excel (.xlsx)) or exporting each tab as CSV, then drop the files onto the tool. One .xlsx is read with all its tabs; several CSVs become separate tabs.
  2. Untick any tabs you’d like to exclude, set the header row number if your headers aren’t on row 1, then pick the value column (Staff, for example), the date column, an optional amount column for sums, and an optional group-by column.
  3. Pick a period — Monday weeks, Sunday weeks, semi-monthly, monthly, or a custom list like “Launch push, 2026-01-01, 2026-01-15” — and an aggregate: count, sum, or distinct count.
  4. Watch the pivot rebuild live as you change settings. Copy it as TSV, download the pivot CSV, or grab the combined master CSV.
  5. No file handy? Click Load example to run the whole flow on built-in sample data.

Combine multiple sheets into one count-by-week pivot

Paste the tabs and the combiner pulls them into one master file, then counts by week so the pivot shows how many rows fell in each week. Tabs with different columns are handled, and the periods and aggregates are set in the same pass.

Worked example: a count-by-week pivot from pasted tabs

Hit Load example and it fills two tabs — January and February — with dated shift rows for Ana and Ben, picks Staff as the value column, Date as the date column, Hours as the amount column, Monday-start weeks, and count.

You’ll see three Monday-start weeks: 2026-01-05 – 2026-01-11 reads Ana 2, Ben 1 (total 3); 2026-01-12 – 2026-01-18 reads Ana 1, Ben 1 (total 2); 2026-02-02 – 2026-02-08 reads Ana 1, Ben 2 (total 3). The totals row reads Ana 4, Ben 4, grand total 8 — every row accounted for, no blanks, no NaN.

Now switch the period to Monthly and the same data re-buckets instantly: 2026-01 shows Ana 3, Ben 2 (total 5); 2026-02 shows Ana 1, Ben 2 (total 3). Flip the aggregate to Sum and you get hours instead of shifts: January Ana 9, Ben 11 (total 20); February Ana 7, Ben 7 (total 14).

Periods, aggregates and the master file

Weeks run Monday to Sunday or Sunday to Saturday. Semi-monthly splits each month into the 1st–15th and the 16th–end — handy for payroll-style reporting. Monthly is the plain calendar month. Custom periods take one line per period — label, start date, end date — so campaign windows or school terms work too.

Count answers “how many rows”. Sum answers “how much” from the amount column, treating non-numbers as zero. Distinct count answers “how many different values” of the value column sit inside each cell. Rows with a blank value or an unreadable date are skipped and reported in the summary line — never silently dropped.

The combined master CSV is your audit trail: every row from every included tab, with a Tab column first, so you can trace any pivot cell back to its source rows.

More spreadsheet tools

If your values come from messy dropdowns, Count Dropdown Values Across Sheets tallies each distinct choice for you. If your formulas break after sorting or inserting rows, a bulk locker for formula references hardens them. And if the dates themselves arrive in mixed formats, run the export through Messy Date Cleaner first, then combine the cleaned file here.

FAQs

Does it work with .xlsx or only CSV?

Both. Drop one .xlsx workbook and every tab is read through the SheetJS library loaded from a CDN; drop several CSV files and each file becomes a tab. If the reader library fails to load, you’ll get a clear message telling you to retry — never a silent empty result.

What if my tabs have different columns?

The column pickers are built from the headers found across the tabs you include. Rows are stacked into one master table on those headers — a tab that’s missing a picked column simply contributes blank cells for it, and rows with a blank value or an unreadable date are skipped and counted in the summary line. Set the header row number if your headers sit below row 1, and untick any tabs you’d rather leave out entirely.

Does anything get uploaded?

No. Every file is read in your browser with JavaScript — nothing leaves your device, and there’s no sign-up or server involved at any step.

Can I combine multiple sheets into one sheet in Excel?

Yes, in the sense that this tool builds the combined file for you. Paste the tabs here and the combiner returns one master file with the count-by-week pivot, which you can open in Excel. It is a paste-list alternative to Power Query, not a Power Query script.

How do I count dates by week in Excel?

The combiner does the weekly count as part of the build, so eachweek’sows are counted in the pivot. If you only need the count, paste the dates and the count-by-week pivot shows how many fell in each week.

Note: all processing happens in your browser — nothing you drop into this multi-tab combiner is uploaded anywhere.

Leave a Comment