5 min read
Convert a Google Shopping XML feed to Excel
Your Google Shopping feed is an XML file that's hard to edit by hand. Here's how to open it in Excel to fix titles, prices or descriptions in bulk, then rebuild it identically to re-import into Google Merchant Center.
Why edit your XML feed in Excel?
A Google Shopping feed has one <item> tag per product, with dozens of fields (g:title, g:price, g:description, g:availability, g:gtin…). Editing that in a text editor is tedious and error-prone: one unclosed tag and the whole feed is rejected.
In a spreadsheet, each product becomes a row and each field a column. You can sort, filter, find-and-replace, recompute prices with a formula, or fix 5,000 titles in minutes — exactly what Excel is built for.
The steps
- Export your XML feed from Google Merchant Center (or grab the file generated by your CMS / PIM).
- Drop the file on ExcelifyXML: it's turned into an editable CSV, one row per product.
- Open the CSV in Excel, Numbers or Google Sheets and make your edits (titles, prices, descriptions, availability…).
- Rebuild the original XML in one click from the Rebuild page: the exact feed structure is preserved.
- Re-import the XML into Google Merchant Center.
Google Shopping fields that survive the round-trip
ExcelifyXML preserves field order and attributes (currency on g:price, etc.), so your feed stays valid for Google. The g: namespaces and repeated fields (multiple g:additional_image_link) are handled.
One honest note: empty self-closing tags (e.g. <g:sale_price/>) disappear when going through CSV. No impact in practice — Google treats a missing field as "don't change", exactly like an empty tag.
Your data stays private
Your file is processed in memory on European servers then deleted immediately — it's never stored. No install, no third-party tool, everything happens online.
Convert your Google Shopping feed in seconds:
Transform a file