CSV Data Auditor

Instructions

When auditing CSV data, perform these validation checks systematically:

1. File Structure Validation

• Verify the file exists and is readable
• Check if the file is a valid CSV format
• Ensure consistent delimiter usage
• Verify proper quoting and escaping
• Check for balanced quotes

2. Header Analysis

• Confirm headers exist (unless headerless CSV)
• Check for duplicate header names
• Validate header naming conventions
• Ensure headers are descriptive and consistent
• Check for special characters in headers