Delimiter and encoding
Delimiter detection, character encoding and byte-order-mark issues.
CSV CATALOG AUDIT
CSV catalog audit for cleaner product exports
Use it to diagnose a source catalog before converting it to a channel-specific export. FeedScore groups repeated row-level errors into practical fixes for your spreadsheet, PIM or ecommerce export.
✓ No account✓ One-time report✓ Public URL only
AUDIT SCOPE
What the CSV catalog audit checks
Headers and row shape
Duplicate columns, unexpected headers and inconsistent field counts.
Quotes and line breaks
Broken quoting and embedded characters that shift product rows.
Unique identifiers
Missing, duplicated or unstable IDs across catalog records.
Commerce values
Price, currency, availability and condition normalization.
Content coverage
Missing images, thin titles and descriptions, categories and identifiers.
ISSUE PRIORITY
Frequent CSV catalog problems
Fix blockers first, then catalog-wide patterns, and leave isolated optimization opportunities for last.
SignalWhy it mattersRecommended action
Rows have different field countsColumns shift and values map incorrectlyFix delimiters, quotes and embedded line breaks
Duplicate or missing headersExport mapping becomes ambiguousUse one stable schema and unique column names
Mixed price or stock formatsChannel conversion creates invalid valuesNormalize values before export
Duplicate product IDsProducts conflict across updatesCreate persistent source identifiers
HOW IT WORKS
From raw feed to prioritized fixes
Share the catalog URL
Provide a public CSV source file without granting access to your store.
Review structural errors
Fix parsing, column and row-shape problems before product attributes.
Improve catalog coverage
Use the affected-row export to repair content and commerce fields in bulk.
IMPORTANT DISTINCTION
CSV source vs. Merchant Center file
Google documents XML and tab-delimited text as common product data source formats. A CSV audit is most useful for cleaning the upstream catalog before you convert or map it into the exact format required by a destination.
FAQ
Questions about this check
Is CSV the same as a tab-delimited product file?+
No. CSV typically uses commas, while tab-delimited files use tab characters. Both are tables, but the delimiter and escaping rules differ. FeedScore identifies the structure before evaluating product fields.
Can I audit an exported spreadsheet?+
Yes, if it is available as a public CSV URL. Native Excel or Google Sheets files are outside the first-release scope unless exported to CSV.
Does the audit detect duplicate products?+
It detects duplicate identifiers and can flag exact or near-duplicate content signals. Determining whether two distinct IDs represent the same real product may still require a human decision.
Can the report help my developer?+
Yes. Findings are grouped by root cause and include affected rows, making it easier to repair the export mapping rather than editing products one by one.
METHODOLOGY & SOURCES
Built around documented feed requirements
Our public guidance is checked against first-party documentation. FeedScore adds independent data-quality checks and does not represent a platform approval decision.