Merge spreadsheets — instantly, in your browser.

Drop your Excel files and get a clean, consolidated workbook in seconds. Handles HTML-disguised-as-XLS exports from GST portal, E-Way Bill, and banking systems. Auto-detects headers, combines multi-row layouts, and formats the output.

All Excel formats Auto-detect headers Multi-row header combine Source tracking Styled output

🔀

Generic Merge

Stack rows from multiple spreadsheets with matching column structures. Works with any Excel file.

📋

GSTR-2B Consolidated

Intelligently merges 12 monthly GSTR-2B files. Sums ITC sheets, stacks data sheets, consolidates Read me.

📋 GSTR-2B Merge Rules

1×

Read me — taken once from the first file. Tax Period auto-computed from all files (e.g. "April 2025 – March 2026"). FY shown from files.

ITC Available, ITC not available, ITC Reversal, ITC Rejected — all numeric figures summed cell-by-cell (same row/col structure across months).

⊕

All other tabs (B2B, B2BA, B2B-CDNR, ECO, ISD, IMPG…) — original multi-row header preserved once, data rows from all files stacked below.

✓

Rejected / Reversal / DNR tabs — included with headers + data rows stacked (all 29 sheets preserved).

Portal exports detected as HTML?

Many government and bank portals export .xls files that are actually HTML tables. The tool also supports all Excel versions — .xlsx, .xls, .xlsm, .xlsb, .ods, .csv, .tsv, and more. All detected automatically.

Smart Detection

Recommended

Auto-detect headers

Find the header row in each sheet automatically

Combine multi-row headers

Merge group + sub headers into one column name

Apply Excel formatting

Borders, header color, freeze panes, autofilter

Sheet Handling

Every tab/table in every file is read. Same-named tabs combine into one output tab.

Output File

Filename

.xlsx

Source Tracking

Sheet Name column always added

Also add "Source File" column

Useful when you need to trace each row back to its workbook

Merge complete

Download merged file

✓ Merged. Ready to reconcile.

Send the merged data directly to ReconBridge for reconciliation, or download the Excel file.

How it works

1 · Sniff

Read the first bytes of each file. Detect real XLSX vs HTML-disguised XLS vs CSV.

2 · Parse

Use the right parser for each format. HTML tables are extracted with DOMParser.

3 · Combine

Detect headers per sheet, flatten multi-row headers, strip repeating header rows.

4 · Output

Write a styled XLSX with borders, frozen panes, autofilter, and source tracking.