Skip to main content
Office

Excel Validate Data

Validate email, phone number, and date formats to manage data quality.

  • Processed on the server
  • No sign-in needed

Upload file and set validation criteria

Choose a file

XLSX

Enter the column name exactly as written in the first (header) row.

* marks required fields.

Validation Results

Choose an Excel file, enter a column name and press [Validate] — the results appear here.

How to use Excel Validate Data

When to use

Use to bulk-validate email, phone number, and date formats in a collected list and filter out bad data before sending.

What to input

Upload an Excel file and choose the column and format to validate (email/phone/date).

Usage example

e.g. Validating the email column of a customer list shows how many values match the format and how many do not, with the row numbers of those that do not.

Things to check

Email and phone checks only look at the shape of values - they do not guarantee the address or number actually works. Phone numbers are checked in Korean digit groups, such as 02-123-4567 or 010-1234-5678. Dates count as valid when they are Excel date-formatted cells or written like 2026-11-17 or 11/17/2026; dates that do not exist on the calendar, such as 2026-02-30, are invalid. Only the sheet that was open when the file was saved is checked.

Related tools

  • Remove duplicates, empty rows/columns, and stray whitespace to get analysis-ready data.

    No sign-in neededProcessed on the server

  • Convert Excel data to CSV, JSON, or HTML for analysis, integration, and sharing.

    No sign-in neededProcessed on the server

  • Search for values in an Excel file and find matching values from other columns.

    No sign-in neededProcessed on the server

Uploaded files are used only for the requested job, and temporary files are deleted automatically afterwards.