Housecall Pro CSV validator

A CSV looks simple until it is not. Delimiters get guessed wrong, quotes get unbalanced, and a single unquoted comma inside a price shifts every column to the right. The validator reads your file the way an importer will and reports precisely where it disagrees.

Structural checks

• Delimiter detection and inconsistent column counts
• Malformed quotes and unbalanced fields
• Blank or duplicate headers, missing header row
• Encoding anomalies and invisible control characters

Content checks

• Required values present on every row
• Valid numeric prices and costs; negative and price-below-cost detection
• Duplicate rows, names and SKUs
• Consistent boolean (taxable) and unit representations

Severities

Every issue is classified as an error (blocks a clean import), warning (should be reviewed) or information (a safe, automatic cleanup). You can filter by severity, category, row and repair status.

Prefer to start clean? Use the price book template.