— Guides
Guides: edit your XML files in Excel
Practical tutorials to transform, edit and rebuild your XML files, no coding.
7 min read
Convert a Google Shopping XML feed to Excel
Open, edit and fix your Google Shopping (Google Merchant Center) XML product feed in Excel, then rebuild the XML — online, no script or macro.
Read the guide5 min read
Edit a PrestaShop or WooCommerce XML product export
Bulk-edit your PrestaShop, WooCommerce or Magento products exported as XML: open them in Excel, fix them, then re-import the rebuilt XML.
Read the guide7 min read
Open and edit an XML file in Excel (without coding)
How to open an XML file in Excel cleanly, edit it, and save it back as valid XML — no Python script or complicated macro.
Read the guide6 min read
Edit a Magento product XML feed in Excel
Open, fix and enrich your Magento (Adobe Commerce) product XML export in Excel, then regenerate the XML to re-import it — online, no script or developer required.
Read the guide5 min read
Bulk-edit an XML sitemap in Excel
Edit your sitemap.xml (URLs, last-modified dates, priorities, change frequencies) in Excel then regenerate a valid sitemap — online, no script.
Read the guide7 min read
Editing a large XML file in Excel: the “sample first” method
Is your XML catalog 20, 30 MB or more? Transform a small sample to get the structure, edit the full volume in Excel, then rebuild the XML — online, no script.
Read the guide4 min read
CSV opening as a single column in Excel? Comma, semicolon, and how to choose
Your CSV opens as one giant column in Excel? It's a separator story (comma vs semicolon). Here's why, and how to pick the right one in ExcelifyXML.
Read the guide8 min read
Edit a Salesforce Commerce Cloud (SFCC) catalog XML in Excel
Open a Salesforce B2C Commerce catalog, price book or inventory export in Excel, edit it in bulk, then rebuild an XML file ready for Business Manager.
Read the guide5 min read
Excel won't export your XML ("list of lists"): why, and what to do
"The XML maps in this workbook are not exportable": why Excel refuses nested lists, and how to edit your XML in Excel anyway.
Read the guide5 min read
EAN, GTIN and lost zeros in Excel: keep your codes intact
Excel shows your EANs as 3.61235E+12, drops leading zeros and invents dates. Why, how to open a CSV without losing anything, and how to fix it.
Read the guide6 min read
Excel to XML: build an XML file from a template
Your data is in Excel and you have a sample of the XML you need? Transform the sample, paste your rows, rebuild an XML in the same format, no code.
Read the guide5 min read
Edit an XML file in Excel and regenerate it in one click
Excel's XML export breaks on nested lists and stops at 65,536 rows. Edit your data in a workbook, then rebuild your XML file in one click, offline.
Read the guide6 min read
"Microsoft has blocked macros from running": unblock an Excel file safely
Red "SECURITY RISK" banner in Excel? Unblock a file you trust via Properties › Unblock, without lowering security. Network, ZIP, OneDrive and Mac cases.
Read the guide