FileDeck한국어
← Guides

How to check Excel duplicates and required blank cells

Start by deciding what identifies a record. An ID column checks repeated IDs; selecting ID and Date compares their combined values. Required-field checks separately flag empty cells and whitespace-only values.

Worked example

The values below are fictional examples that illustrate the workflow.

Input and settings

Columns: ID,Name
First data row: 001,Alex
Second data row: 001,Sam
Third data row: 002,(blank)
Duplicate key: ID / Required field: Name

Expected result

First and second data rows: duplicate ID
Third data row: missing Name
Original data appears in Data; findings appear in Review

Steps

  1. Choose a file and sheet with column headings in its first data row.
  2. Select identifier columns as duplicate keys, then select columns that must contain values as required fields.
  3. Create the report. One row can have several issues, so the issue count may differ from the number of affected rows.
  4. Download the XLSX and use the source row references in Review to decide what needs correcting.
Check duplicates & blanks →

What to check

Comparison trims surrounding whitespace and is case-sensitive. Rows with blank keys are excluded from duplicate checks; also mark the key as required if you want missing keys reported.

Every row in a duplicate group is reported, including the first. The report does not correct values or delete duplicates; review findings before making changes.

Processing and saving

Files are processed in your browser without uploads. Download the result before closing the tab and compare it with your original. Learn more in the privacy and file-processing notice.

More guides