Attribute Table Completeness Checker

Checks a pasted attribute table against your schema — required values, types, allowed values and duplicate IDs — and records the GIS review.

100% FreeRuns in your browserBasic

Project and review scope

A review of one attribute table against the schema you supply. The table check below runs in this browser on the CSV you paste or load; the rows record what a person verified. Geometry is not inspected — an attribute-only table cannot show whether features are valid.

Attribute table check

Paste or load the attribute table as CSV. Cells are kept exactly as typed (no trimming, no number formatting), and the table is read in this browser only. Limits: 10 MiB, 100,000 records, 200 fields per record.

Read in this browser only — nothing is uploaded.
Comma-separated. Leave blank if only blank cells mean missing. 0 and false are values unless you list them.
name, type, required, allowed values, column. Types: text, integer, number, date (YYYY-MM-DD), boolean (true/false). Allowed values are separated by |. Column defaults to the field name (or give a column number).
One logical record can span lines
Illustrative
One logical record can span linesFour physical source lines parse into a header and two records. The quoted newline stays inside the note cell, 0007 keeps its leading zeros, 123.4500 keeps its trailing zeros and the comma inside quotes is not a delimiter.Source text (4 physical lines)1 id,value,note2 0007,123.4500,"two spaces3 and a newline"4 0008,1.0,"a, b"Parsed (2 logical records)idvaluenote0007123.4500two spaces↵and a newline00081.0a, b↵ marks the newline kept inside the cell
Source: 4 physical lines → 1 header + 2 logical records. A quoted newline stays part of its cell; 0007 and 123.4500 are kept exactly as typed; a comma inside quotation marks is not a delimiter.
  • Note: No table supplied yet. Paste or load a CSV to run the attribute checks; the review rows work without one.
  • Note: Geometry: NOT INSPECTED — this is an attribute-only table; spatial validity must be checked in the GIS.

Review status: Not reviewed

Review progress 0 of 15 applicable rows verified (0%)

Outstanding critical findings

  • Schema and null-token policy selected — Not started
  • Unique ID field mapped and duplicates checked — Not started
  • Required values checked without treating 0 or false as missing — Not started
  • Geometry reported Not inspected for attribute-only data — Not started

Review rows

Schema and null policy

0/2 verified
  • Field names follow the agreed schema

  • Schema and null-token policy selected

    Critical

Identifiers

0/3 verified
  • A unique ID field on every feature

    No blank or duplicate IDs.

  • No duplicate features for the same real-world object

  • Unique ID field mapped and duplicates checked

    Critical

Required values

0/2 verified
  • All required attribute fields present

  • Required values checked without treating 0 or false as missing

    Critical

Types and domains

0/3 verified
  • Correct data type per field

    Text, integer, date, etc.

  • Domains / pick-lists respected

    Values match the allowed set.

  • Types and domains checked per supplied schema

Consistency

0/3 verified
  • Units consistent within a field

  • Dates in one consistent format

  • Spelling and capitalisation consistent

Geometry and metadata

0/2 verified
  • Metadata / data source recorded

  • Geometry reported Not inspected for attribute-only data

    Geometry validity needs the spatial data itself; record where it was checked, or why it was not.

    Critical

Add your own row

Keep, share and print

Nothing leaves your browser. Saving on this device is optional and only happens when you press it.

Tip: Enter any known values to calculate the remaining results.

Designed to run locally in your browser. Tool inputs are not intentionally stored by Zerdly unless stated otherwise.