How to use

Basic steps for using CSV Checker.

This page explains single-file check (validate one CSV) and compare two files (see differences between two CSVs).

Single-file check steps

  1. Open the check page
    From the home page, click the single-file check card or go to the format check page.
  2. Select a CSV
    Drag and drop a file onto the «Select CSV» area or click to choose. Row limits are shown in the footer under «Current plan».
  3. Review the results
    Format, delimiter, encoding, header, empty rows, column mismatch, etc. are shown.
  4. Choose columns (optional)
    Check the columns you want in the table, then click «Show table».
  5. View and download
    Use the «Issues found» panel and «Download CSV», «To full-width» / «To half-width» as needed.

Compare two files steps

  1. Open the compare page
    From the home page, click compare two files or go to compare page.
  2. Select two CSVs
    Put the reference CSV in «Current data» (left) and the file to compare in «Reference data» (right).
  3. View the comparison
    Added, deleted, and changed rows are colour-coded. Click the summary to list matching row numbers.
  4. Columns and navigation
    Use «Choose visible columns» to show or hide columns. Click a row number to scroll to that row.

General

Back to top