\n \n
#215 · Formula & Cell Inspection Tool

List Merged Cells in Excel

Inspect an Excel workbook for merged ranges and download a report showing the sheet, range, size, and top-left value of every merge.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Choose the source file.
  2. Select the worksheet and review the header-row setting.
  3. Click List Merged Cells and provide any requested operation details.
  4. Review the bounded preview and download the newly generated result.

What this tool does

Inspect an Excel workbook for merged ranges and download a report showing the sheet, range, size, and top-left value of every merge.

Worksheet merge metadata is read directly; the workbook is not recalculated or edited.

Keep the original file until you have opened and checked the downloaded result in your preferred spreadsheet application.

Supported formats

XLSX, XLS, CSV, and TSV can be read in the browser. Output is generated as XLSX, CSV, or ZIP according to this operation.

FormatUse
XLSX / XLSWorkbook input
CSV / TSVDelimited table input
Generated resultNew downloadable file

Tips for better results

  • Work from a copy when the workbook contains business-critical records.
  • Check header spelling, identifiers with leading zeros, and date cells after export.
  • Remove passwords before processing; encrypted workbooks cannot be opened here.
  • For very large files, split the source into smaller worksheets first.

FAQ

Does list merged cells in excel upload my workbook?

No. The selected files are read and processed locally by JavaScript in your browser.

Which spreadsheet formats work with this tool?

XLSX, XLS, CSV, and TSV inputs are accepted where the selected operation applies. The page reports parsing errors instead of claiming a damaged file was processed.

Will formulas and advanced Excel features be preserved?

Basic cell values and formulas are handled, but macros, external links, charts, pivot tables, and application-specific features may not be fully preserved.

Can I use this with large workbooks?

Moderate files work best in a browser. The tool rejects files over 25 MB and limits the on-screen preview so thousands of rows are not inserted into the page.

How should I verify the downloaded result?

Open the output in your spreadsheet application and review a few representative rows, dates, identifiers, and formulas before replacing an original file.

Processing notes

AreaBehavior
PrivacyLocal browser processing
PreviewLimited to 100 rows
ResultNew file blob

Browse more office tools

Office tool hubs