✓ TestedWorks with CSV, Excel, Google Sheets → Clean Export
By dataclean.to team · 2026-02-13
If your product data lives in CSV spreadsheets — exported from your e-commerce platform, inventory system, or manually maintained — getting it into the format Google Shopping requires is a multi-step process of renaming columns, reformatting values, validating identifiers, and ensuring nothing is missing. dataclean.to streamlines this conversion by cleaning your CSV data against Google Shopping's specific requirements and exporting it in the format Merchant Center expects.
The Problem
Google Shopping feeds have strict formatting rules that differ from how product data is typically stored in CSV files. Column headers must match Google's attribute names exactly ("image_link", not "image" or "product_image"). Prices need a specific format: "29.99 USD" with a space before the currency code — not "$29.99" or "29.99". Availability must be one of four exact values. Product identifiers (GTIN, MPN, brand) have complex rules about which combinations are required for which product categories. A CSV exported from Shopify, WooCommerce, or a custom system will not match these requirements without significant transformation. Google Shopping product data specification
How to Fix It
1
Upload your product CSV
Import your product data CSV into dataclean.to. The platform accepts files with any column naming convention and automatically detects product data patterns like prices, SKUs, URLs, and identifiers.
2
Map columns to Google Shopping attributes
Match your CSV columns to Google Shopping's required and recommended attributes: id, title, description, link, image_link, price, availability, brand, gtin, mpn, condition, and others. dataclean.to suggests mappings based on column content.
3
Clean and validate product data
Fix formatting issues across all products: prices are reformatted to Google's required format, GTINs are validated with check digit algorithms, availability values map to Google's four allowed options, and titles are checked against character and content policy limits.
4
Review and resolve feed errors
dataclean.to flags products that would be rejected by Merchant Center: missing required attributes, invalid identifiers, price format errors, and broken image URLs. Review the flagged items and fix or exclude them before export.
5
Export the formatted feed
Download the cleaned and formatted product feed as a CSV ready for Merchant Center upload. Column headers match Google's exact attribute names, values use the required formats, and the file is encoded in UTF-8 as Google requires.
Frequently Asked Questions
What CSV columns are required for a Google Shopping feed?
The minimum required attributes are: id (unique product identifier), title (product name), description, link (URL to product page), image_link (URL to product image), price, availability, and either brand or GTIN. Additional attributes like color, size, and google_product_category are required for specific product types like apparel.
Can I convert a Shopify or WooCommerce CSV export to Google Shopping format?
Yes. dataclean.to handles CSV files from any e-commerce platform. The column names and value formats from Shopify, WooCommerce, BigCommerce, and other platforms differ from Google Shopping's requirements, but the platform maps and converts between them.
How should I handle product variants in my CSV?
Each product variant (size, color, material) should be its own row in the CSV with its own unique id, specific title, and the relevant variant attributes filled in. Google Shopping treats each variant as a separate listing. The item_group_id attribute links variants of the same product together.
Example: Input → Output
name
sku
price
brand
rating
Wireless Headphones Pro
WHP-001
$89.99
SoundTech
4.5
wireless headphones pro
WHP001
89.99
soundtech
4.5/5
Red rows show common data quality issues. dataclean.to normalizes and generates JSON-LD automatically.