XML to CSV converter
Converts WordPress XML/WXR (WordPress eXtended RSS) to an easy-to-edit Shopify format CSV. Allows editing of titles, content, and tags before importing.
Please drag and drop the XML file exported from WordPress. It will automatically generate handles (slugs) and integrate tags, creating a Shopify-format CSV.
Custom fields are automatically exported as metafields in the CSV, which is convenient. Please correct the metafield settings as needed after export. For information on metafields that can be imported with Blog Importer, please refer to the supported metafields page.
Parsing Complete
CSV Preview (First row)
Optional Features (Admin Only)
Options like future shortcode removal will be added here.
When to use it?
- It is automatically output to the CSV as source_url. It is also useful when manually importing into standard Shopify redirects.
- When you want to import custom fields created with ACF, converting them to CSV with this tool will automatically output them as metafields.
- By converting to CSV once instead of importing the XML directly, you can easily perform keyword replacement and tag organization on a spreadsheet.
What you can do with this tool
- 🗂️
Convert categories and tags to Shopify format
Shopify only has tag functionality. Therefore, WordPress categories and tags need to be consolidated into tags. This converter handles that automatically.
- 🧱
Automatic output of custom fields
Custom field values created with ACF are also automatically converted to Shopify-format metafields and output to the CSV.
- 🔗
Automatic output of the original URL
Automatically outputs the URL used in WordPress to the CSV as source_url.
- 🏷️
Consistent handle generation
Automatically generates handles (URL slugs) with the same logic as Blog Importer itself. Prevents duplicates and URL inconsistencies during re-importing.
Help
- Yes, it's safe to use. This tool runs entirely on your device (in the browser), so your data is never sent to or stored on an external server. You can use it with peace of mind in a secure environment.
- By converting to CSV once, you can clean data to meet Shopify's specifications and make bulk adjustments to SEO keywords, which makes post-migration operations much smoother.
- The biggest advantage is that the "handle generation rules" are the same as the Blog Importer app itself. This allows the app to accurately identify existing articles even if you edit the data via CSV, minimizing the risk of duplicate posts or broken links.