Skip to main content Link Menu Expand (external link) Document Search Copy Copied

Validate Spreadsheet

Start Validating

Once you have uploaded the input file, click “Start Validating” to begin the validation process. Depending on the file size and your Internet connection, the process may take some time.

Validation Dashboard

The Validation Dashboard displays an overall validation summary and information about the number and types of validation errors that the tool’s algorithm detected in your spreadsheet.

validation-dashboard

Bullet point (A) points to the top navigation bar, and it displays (from left to right):

  1. The input file name.
  2. Start new validation button icon.
  3. Overview links to the dashboard page itself.
  4. Repair Completeness Errors links to the worksheet page that handles repairing missing values. The total number of errors of this type displays on a red badge.
  5. Repair Adherence Errors links to the worksheet page that handles repairing invalid values. The total number of errors of this type displays on a red badge.

Bullet point (B) points to the summary information cards that are generated by the tool:

  1. Validation Summary displays the error count chart and some text to describe “Completeness Error” and “Adherence Error”.
  2. Completeness Error Analysis displays the total number of cells that have a missing value in a given column name.
  3. Adherence Error Analysis display the total number of cells that have an invalid value in a given column name and an error flag.