Data quality worksheet

Purchase order CSV validator

Select a CSV and receive row-level issues without uploading the file. The original is never changed, and an issue report can be downloaded.

Browser-local worksheet

Enter your inputs

Nothing is uploaded or saved

Required headers: po_number, supplier, item, quantity, unit_price, currency, need_by_date

How to use it

A short, reviewable workflow

  1. 01

    Prepare UTF-8 CSV headers: po_number, supplier, item, quantity, unit_price, currency, need_by_date.

  2. 02

    Choose the file; processing occurs in this browser tab.

  3. 03

    Correct every reported row in a copy of the source and validate again.

Useful for

Common use cases

  • Pre-import PO checks
  • Supplier upload template review
  • Finding common spreadsheet formatting errors

Important boundary

What this result cannot decide

Validation does not approve, repair, submit, or issue a purchase order. Preserve the original and verify totals, authority, master data, tax, and terms in your procurement system.

Model notes

Assumptions and limitations

Assumptions

  • The first row is the header.
  • Delimiter is a comma and quoted fields follow standard CSV escaping.
  • Currency uses three uppercase letters and dates use YYYY-MM-DD.

Limitations

  • Does not validate suppliers, items, exchange rates, tax, totals, authorization, or duplicates.
  • A structurally valid row may still be commercially wrong.
  • Very large files may use browser memory.

Questions

Frequently asked

Is the file uploaded?

No. The browser reads it locally for the current page session.

Does the tool change my CSV?

No. It reports issues and leaves the selected file untouched.