XML to CSV Converter

Convert WordPress XML to Shopify CSV | Free WXR Conversion Tool

You can convert XML/WXR files exported from WordPress into CSVs that are easy to use for Shopify blog migration. After reviewing and editing the title, body, handle, tags, published date, author, images, SEO fields, and custom fields in the converted CSV, you can import it to Shopify using Blog Importer.

Please drag and drop the XML file exported from WordPress. It will automatically generate handles (slugs) and integrate tags, creating a Shopify-format CSV.

What is a handle?

In Shopify, the string used at the end of a blog post URL is called a handle. Since it affects your post-migration URL structure and 301 redirects, if you want to preserve your WordPress URLs as much as possible, please select "WordPress Permalink". If you want to stabilize re-imports and overwrite updates in Blog Importer, you can select "Legacy Shopify Format" which uses the same generation logic as the Blog Importer itself.
Example: [example.myshopify.com/blogs/news/](https://example.myshopify.com/blogs/news/)[Handle Name]

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

Extracted articles: 0
Filename: -

CSV Preview (First row)

Import to Shopify with Blog Importer

Optional Features (Admin Only)

Options like future shortcode removal will be added here.

What you can do with this tool

Related guides and tools

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.

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.
  • WordPress XML / WXR is an export format used to migrate WordPress posts, pages, categories, tags, comments, custom fields, etc., to another environment. You can download it from "Tools" -> "Export" in the WordPress admin screen. Since Shopify cannot directly import WordPress XML as blog posts, it needs to be converted into a CSV format that is easy to handle within Shopify.
  • A Shopify blog migration CSV is a CSV file that organizes WordPress article data so it can be imported as blog posts into Shopify. This tool exports article titles, body HTML, handles, tags, publication dates, authors, featured images, original URLs, custom fields, etc., as a CSV. By converting to CSV, you can check and edit the article data before importing it into Shopify.
  • It outputs the main data necessary for Shopify blog article migration, such as article title, body HTML, handle (slug), tags, publication date, author, and featured image URL. The output content for original article URLs, SEO metadata, and custom fields may vary depending on the content of the WordPress XML and the conversion settings.
  • Information usable for migration can be exported to a CSV based on the post metadata included in the WordPress XML. However, not all custom fields will perfectly correspond to Shopify metafields as is. If necessary, please check and adjust column names and values in the CSV before importing.
  • ACF values may be included in the XML as WordPress custom fields. In that case, they may be exported and organized into a CSV. However, complex formats such as repeater fields, groups, image objects, and related posts may be treated as simple text or JSON strings. Please check the content on the CSV before importing into Shopify. Also, repeater fields and array data cannot be imported into Shopify.
  • The CSV file does not contain the images themselves, but image URLs. When importing into Shopify, the Blog Importer app reads those URLs, imports them into Shopify Files if possible, and replaces the image URLs in the articles with the Shopify URLs. We recommend keeping the images on the original site accessible during the migration, as they may not be imported if the image URL is private, deleted, or has restricted access.
  • Large XML files exceeding a few dozen MB can cause processing instability due to browser memory limits. In that case, please use the "WordPress XML File Splitter Tool" on this site to split the XML file into multiple parts before converting.
  • If you use another Shopify migration app such as Matrixify, make sure the column names, file names, sheet names, and metafield formats match the specifications of each app. Adjust the CSV column names as necessary. Additionally, when importing with Matrixify, images within the body text are not automatically replaced. Therefore, you will need to manually reposition the images. Please note that redirect settings must also be configured manually. If you want to migrate a large amount of articles, images, and SEO redirects all at once, please use Blog Importer.
  • If you want to maintain your WordPress-era URL slugs as much as possible, we recommend "WordPress Permalink". On the other hand, if you want to organize them into alphanumeric handles that are easy to handle in Shopify, please select "Old Shopify (Recommended)". If you place importance on designing redirects from existing URLs, maintaining the WordPress-side slugs makes management easier.

Cherish your
accumulated
blog posts.

No subscription required.
You can use it.

Try
🚨

Official Site (blog-importer.com)