— Guides

Guides

Practical tutorials to transform, edit and rebuild your XML files, no coding.

5 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.

Transform a file

5 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.

Transform a file

4 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.

Transform a file

6 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.

Transform a file

5 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.

Transform a file

6 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.

Transform a file

4 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.

Transform a file