How do I handle different delimiters?

Detect delimiter by analyzing first rows (comma, tab, semicolon, pipe). Or let user specify. European CSVs often use semicolon (comma is decimal separator).

What about encoding issues?

UTF-8 is standard. Windows often uses UTF-8 with BOM or Latin-1. Try UTF-8 first, fall back to Latin-1. Check for replacement characters (�) indicating wrong encoding.

Should headers be validated?

Yes. Check for duplicates, required headers, valid names (no special characters). First row usually contains headers, but not always specified.

CSV Validator

Guide & TutorialOffline

Validate CSV data and check for formatting issues

Validate CSV files and check for errors instantly with our free online CSV validator. This tool helps data analysts and developers verify CSV structure, detect formatting issues, and ensure data integrity. Simply paste your CSV data and get instant validation feedback.

Input CSV

0 characters, 1 lines

Validation Result

About CSV Validation

This validator checks your CSV data for common formatting issues and provides detailed feedback about errors and warnings.

Checks performed:

Syntax errors and malformed rows
Inconsistent column counts
Empty cells and missing data

About CSV Validator

CSV validator checks CSV files for proper formatting, structure, and data consistency. Verify column counts, detect encoding issues, find malformed rows, validate data types, and ensure CSV compliance before processing.

How It Works

Parse CSV line by line, split by delimiter, handle quoted fields, count columns per row. Check: consistent column count, proper quote escaping, valid encoding, data type consistency. Report errors with line numbers.

Technical Details

CSV rules (RFC 4180): comma delimiter (or tab, semicolon), CRLF line endings, quoted fields for commas/newlines, double quotes escape quotes. Common issues: inconsistent columns, unescaped quotes, encoding (UTF-8 vs Latin-1), BOM characters.

Common Use Cases

Data Import

Validate CSV before database import.

Check user data before bulk insert

ETL Pipeline

Verify CSV structure in data pipelines.

API Uploads

Validate user-uploaded CSV files.

Data Quality

Check data consistency and completeness.

Code Examples

CSV Validation

javascript

// Comprehensive CSV validator
function validateCSV(csvContent, options = {}) {
  const {
    delimiter = ',',
    hasHeader = true,
    expectedColumns = null,
    requiredHeaders = []
  } = options;

  const errors = [];
  const warnings = [];
  const lines = csvContent.split(/\r?\n/);

  // Parse line respecting quotes
  function parseLine(line) {
    const result = [];
    let current = '';
    let inQuotes = false;

    for (let i = 0; i < line.length; i++) {
      const char = line[i];

      if (char === '"') {
        if (inQuotes && line[i + 1] === '"') {
          current += '"';
          i++;
        } else {
          inQuotes = !inQuotes;
        }
      } else if (char === delimiter && !inQuotes) {
        result.push(current.trim());
        current = '';
      } else {
        current += char;
      }
    }
    result.push(current.trim());
    return result;
  }

  // Validate
  let headerCount = null;
  let headers = [];

  lines.forEach((line, index) => {
    if (!line.trim()) {
      if (index < lines.length - 1) {
        warnings.push(`Line ${index + 1}: Empty line`);
      }
      return;
    }

    const fields = parseLine(line);
    const lineNum = index + 1;

    if (index === 0) {
      headerCount = fields.length;
      if (hasHeader) {
        headers = fields;

        // Check required headers
        requiredHeaders.forEach(req => {
          if (!headers.includes(req)) {
            errors.push(`Missing required header: ${req}`);
          }
        });

        // Check duplicate headers
        const dupes = headers.filter((h, i) => headers.indexOf(h) !== i);
        if (dupes.length) {
          errors.push(`Duplicate headers: ${dupes.join(', ')}`);
        }
      }

      // Check expected columns
      if (expectedColumns && fields.length !== expectedColumns) {
        errors.push(`Expected ${expectedColumns} columns, found ${fields.length}`);
      }
    } else {
      // Check column count
      if (fields.length !== headerCount) {
        errors.push(`Line ${lineNum}: Expected ${headerCount} columns, found ${fields.length}`);
      }
    }

    // Check for unescaped quotes
    if ((line.match(/"/g) || []).length % 2 !== 0) {
      errors.push(`Line ${lineNum}: Unbalanced quotes`);
    }
  });

  return {
    valid: errors.length === 0,
    errors,
    warnings,
    stats: {
      totalLines: lines.length,
      dataRows: hasHeader ? lines.length - 1 : lines.length,
      columns: headerCount,
      headers: hasHeader ? headers : null
    }
  };
}

// Usage
const result = validateCSV(csvText, {
  hasHeader: true,
  requiredHeaders: ['id', 'name', 'email']
});

console.log(result.valid ? 'Valid CSV' : 'Invalid CSV');
result.errors.forEach(e => console.error(e));

Validates CSV structure, column counts, headers, and quote handling. Returns detailed error report.

Tips & Best Practices

Always specify expected delimiter
Validate before database import
Check encoding issues first
Handle both Windows and Unix line endings
Validate data types for each column

Common Mistakes to Avoid

Assuming comma delimiter always
Not handling quoted fields properly
Ignoring encoding differences
Not counting empty trailing lines
Missing BOM detection

When to Use This Tool

Use CSV validator before data imports, in ETL pipelines, for user file uploads, or when debugging CSV parsing issues.

Frequently Asked Questions

Consistent column count, properly escaped quotes (doubled inside quoted fields), consistent delimiter, valid encoding. RFC 4180 defines standard, but many variations exist.

// Comprehensive CSV validator function validateCSV(csvContent, options = {}) { const { delimiter = ',', hasHeader = true, expectedColumns = null, requiredHeaders = [] } = options; const errors = []; const warnings = []; const lines = csvContent.split(/\r?\n/); // Parse line respecting quotes function parseLine(line) { const result = []; let current = ''; let inQuotes = false; for (let i = 0; i < line.length; i++) { const char = line[i]; if (char === '"') { if (inQuotes && line[i + 1] === '"') { current += '"'; i++; } else { inQuotes = !inQuotes; } } else if (char === delimiter && !inQuotes) { result.push(current.trim()); current = ''; } else { current += char; } } result.push(current.trim()); return result; } // Validate let headerCount = null; let headers = []; lines.forEach((line, index) => { if (!line.trim()) { if (index < lines.length - 1) { warnings.push(`Line ${index + 1}: Empty line`); } return; } const fields = parseLine(line); const lineNum = index + 1; if (index === 0) { headerCount = fields.length; if (hasHeader) { headers = fields; // Check required headers requiredHeaders.forEach(req => { if (!headers.includes(req)) { errors.push(`Missing required header: ${req}`); } }); // Check duplicate headers const dupes = headers.filter((h, i) => headers.indexOf(h) !== i); if (dupes.length) { errors.push(`Duplicate headers: ${dupes.join(', ')}`); } } // Check expected columns if (expectedColumns && fields.length !== expectedColumns) { errors.push(`Expected ${expectedColumns} columns, found ${fields.length}`); } } else { // Check column count if (fields.length !== headerCount) { errors.push(`Line ${lineNum}: Expected ${headerCount} columns, found ${fields.length}`); } } // Check for unescaped quotes if ((line.match(/"/g) || []).length % 2 !== 0) { errors.push(`Line ${lineNum}: Unbalanced quotes`); } }); return { valid: errors.length === 0, errors, warnings, stats: { totalLines: lines.length, dataRows: hasHeader ? lines.length - 1 : lines.length, columns: headerCount, headers: hasHeader ? headers : null } }; } // Usage const result = validateCSV(csvText, { hasHeader: true, requiredHeaders: ['id', 'name', 'email'] }); console.log(result.valid ? 'Valid CSV' : 'Invalid CSV'); result.errors.forEach(e => console.error(e));