Skip to content
TextArray1.41.0
100% local

CSV to Google Merchant XML feed

Convert a product spreadsheet into an XML feed Google Merchant Center accepts.

Input
Output
Related tools
CSV ⇄ JSON converterDeveloper tools
CSV to SQL INSERT generatorDeveloper tools
Product schema generatornewRandom generators
i18n key diffDeveloper tools
TOML to JSON converterDeveloper tools
SQL to JSONDeveloper tools
CSV to Google Merchant XML feed
Paste a product CSV — the kind exported from a spreadsheet, an e-commerce platform or an inventory system — and this tool builds the RSS-based XML feed that Google Merchant Center accepts for Shopping ads and free listings. It reads the header row, matches common column names like "SKU", "Product Name" or "Image URL" to the feed fields Google expects (id, title, description, link, image_link, price, availability, brand, gtin, condition), and writes one <item> per valid row inside a <channel> carrying your store name.
When a column doesn't match automatically — a header like "Cost" for price, or "EAN" for gtin — set it explicitly with the column-mapping fields; leaving one blank keeps auto-detection. The currency field controls the code appended after each price ("19.99 USD"), and the decimal-separator option handles exports where prices use a comma instead of a dot. A default value fills any field left blank in the source data, and the truncate option trims titles and descriptions to the length Google enforces (150 and 5,000 characters) instead of letting a long one get rejected. Choose plain XML escaping or CDATA sections for text fields, depending on how your downstream system prefers to receive markup or special characters.
A row missing a required field — id, title, description, link, image_link, price or availability — is left out of the feed rather than guessed at. Switch the output to "List of errors" to see exactly which rows were skipped and which fields they were missing, so you can fix the source spreadsheet and re-paste it. The tool also auto-detects comma, semicolon, tab or pipe delimiters, and treats CRLF and LF line endings the same way.
Everything runs locally in your browser — your product data, prices and URLs are never uploaded anywhere. When the feed looks right, copy it, download it as a file, or send it to another tool to keep working on it.
FAQ
Which fields does the feed require?
id, title, description, link, image_link, price and availability. A row missing any of these is left out of the XML and listed when you switch the output to "List of errors".
How does column mapping work?
The tool matches your CSV headers to feed fields automatically (for example "Product Name" or "SKU"). Use the column-mapping fields to set an exact header name when auto-detection picks the wrong column or your header doesn't match a common name.
What format does the price need to be in?
Any recognizable number works — currency symbols and stray characters are stripped automatically. Turn on the comma-decimal option if your prices use "," instead of "." for the decimal point.
Can I use CDATA instead of escaping special characters?
Yes. Switch the text encoding option to "Wrap in CDATA" if your titles or descriptions contain markup or characters you'd rather not see HTML-escaped.
Is my product data uploaded anywhere?
No. The CSV-to-feed conversion runs entirely in your browser — your product data, prices and image links never leave your device.