Back to Free Tools

FREE TOOLS

XLSX Duplicate Row Report

Find duplicate original XLSX rows using exact stored typed key values.

Original XLSX workbook, Worksheet position, Key column positions,comma-separated, First data row, Last data row (0 for all remaining)

JSON

Browser only

Runs locally in your browser. Your files, pasted content and generated output are not uploaded. Reset clears this tool’s working data.

This tool needs JavaScript. If it does not load, refresh the page and try again.

How to use this tool

  • Enter the displayed example values,or choose the local input files requested by the controls. Optional source files take precedence where labelled.
  • Choose Find duplicate rows and inspect the complete result and any reported limitations.
  • Use Download result and each companion download link to save complete outputs. Reset clears output and restores example controls.

Examples

Worksheet position: 1
Key column positions,comma-separated: 1
First data row: 2
Last data row (0 for all remaining): 0

Limitations

  • Find duplicate original declared worksheet rows by selected1-based key columns. Report all group members with original row/cell addresses and stored typed values. Numeric cache spellings use exact decimal identity;strings,Booleans,errors,literal ISO dates,absent cells,explicit blanks and empty strings stay distinct. Formula key cells require a representable stored cache;styles are ignored and styled date serials stay numeric. No displayed-value/Excel-rounding equivalence,formula evaluation or source mutation. Select a1-based worksheet position and row range;end0 means remaining declared rows. Up to50,000 rows/500columns/500,000 key lookups and8-MiB cumulative key index. One standard Transitional XLSX up to20 MiB;50sheets/64-MiB expanded package,8-MiB/200,000-node inspected XML parts. Macros,signatures,embedded/ActiveX objects,encrypted files and external workbook links refuse. No external resource is fetched. Complete JSON report20 MiB. All processing stays in your browser.
  • Complete outputs only. Unsupported or oversized input is refused. Follow the displayed job-specific bounds and format policies.

Related tools

No items found.

More tools for your workflow

Explore the related desktop tool