Introduction

When migrating a blog from WordPress to Shopify, you may want to batch edit post titles or re-organize tags before importing. While WordPress exports data in XML (WXR format), converting it to a “Shopify-friendly CSV” allows anyone to easily edit the content using Google Sheets or Excel.

Using the free “WordPress XML to CSV Converter” provided by Blog Importer, you can perform this conversion instantly in your browser.

Why convert XML to CSV?

WordPress XML files have a complex structure that cannot be opened by general spreadsheet software. Converting to CSV offers the following benefits:

  • Batch Editing: Use “Find and Replace” or functions in spreadsheets to fix titles and body content at once.
  • Selective Migration: Easily delete rows for old articles you don’t want to migrate.
  • Metafield Migration: Organize WordPress Custom Fields into Shopify Metafield columns.
  • Data Normalization: Clean up categories (tags) before importing.

How to convert and import your blog

Follow these 5 steps for a smooth data migration.

Step 1: Export from WordPress

From the WordPress admin panel (Tools > Export), export your XML file including custom fields. Select ‘Posts’ or the specific post type you wish to export.

[Tools] > [Export]

Step 2: Access the Converter Tool

Go to the converter tool page via the link below. This tool runs entirely in your browser, so no data is sent to the server.

🔄

WordPress XML to CSV Converter

Convert WordPress XML files into a Shopify-friendly CSV format for free.

/tool/wp-to-shopify

Step 3: Upload and Convert

Drag and drop your XML file. Once the conversion is complete, click “Download CSV”.

Step 4: Edit in Spreadsheet (Optional)

Open the downloaded CSV in Google Sheets or similar software. Edit fields like Title, Body (HTML), and Tags as needed. Custom fields are automatically generated with column names like metafield_namespace_key.

Step 5: Add Metafield Definitions in Shopify

In the Shopify admin, go to [Settings] > [Custom data] > [Blog posts] and create metafield definitions that correspond to the custom fields you wish to migrate.

Step 6: Rename Columns

In your spreadsheet, rename the custom field column headers to match the “namespace and key” of the metafields you created (e.g., metafield_custom_color).

Step 7: Match Metafield Data Types

Furthermore, you can specify the data type by appending it after a colon. Refer to the supported metafields page for valid type names. Example: metafield_custom_color:single_line_text_field Ensure the namespace, key, and data type are correctly specified.

Step 8: Import with Blog Importer

Open the Blog Importer app in your Shopify admin, select the “Free format (custom CSV)” option, and upload your file. Images and SEO redirects will be handled automatically.

FAQ

Q. Can I migrate custom fields? A. Yes! The converter automatically detects custom fields and converts them into columns for Shopify metafields.

Q. What happens to the images? A. When importing with Blog Importer, the app automatically uploads images to Shopify and rewrites the links to Shopify’s server paths.

🌐

WordPress Migration Guide

Learn the standard migration procedure using XML files directly.

/guide/wp-migrate