REPAIR GUIDE · STEP BY STEP
Repair CSV Encoding and Quoting Problems
Fix broken rows caused by delimiters, quotes, embedded newlines or encoding.
How to diagnose and repair the issue
- Confirm the file uses UTF-8 text
- Check whether the export uses commas, tabs or another delimiter
- Quote fields containing delimiters or newlines
- Double quote marks inside quoted fields
- Reopen the exported file and compare row counts
⚠ Before exporting
Avoid editing CSV in spreadsheet software that silently reformats IDs.
Check the fix
Keep an untouched copy of your source feed. Run the relevant check again, inspect flagged rows and compare a small sample with your store catalog. Merchant Center may apply additional requirements by country, product category and destination.
For the definitive requirements, review Google's current product data specification and your own Merchant Center diagnostics.