WPBeginner

Beginner's Guide for WordPress

  • Blog
    • Beginners Guide
    • News
    • Opinion
    • Showcase
    • Themes
    • Tutorials
    • WordPress Plugins
  • Start Here
    • How to Start a Blog
    • Create a Website
    • Start an Online Store
    • Best Website Builder
    • Email Marketing
    • WordPress Hosting
  • Deals
    • Bluehost Coupon
    • SiteGround Coupon
    • WP Engine Coupon
    • HostGator Coupon
    • Domain.com Coupon
    • Constant Contact
    • View All Deals »
  • Glossary
  • Videos
  • Products
X
☰
Beginner's Guide for WordPress / Start your WordPress Blog in minutes
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
Recommended
WordPress Plugins
View all Guides

WPBeginner» Blog» Tutorials» How to Split Large XML Files in WordPress

How to Split Large XML Files in WordPress

Last updated on May 27th, 2013 by Editorial Staff
67 Shares
Share
Tweet
Share
Pin
Special WordPress Hosting offer for WPBeginner Readers
How to Split Large XML Files in WordPress

WordPress comes with built in import/export functionality that allows you to import or export your WordPress posts in XML format. When moving your site from WordPress.com to WordPress.org and in other transfer scenarios, sometimes these export files are larger than your web host’s upload limit. In those cases, you really have two options. You can either ask your WordPress web hosting provider to increase your maximum upload limit. The second option is to simply split your large XML files into multiple smaller files, so you can upload them one by one. In this article we will show you how to split large XML files in WordPress.

Automatically Split Large WordPress XML Files

Even though you can manually split your large XML files by creating multiple XML files with the same header, category, and footer information and dividing the rest of the items. But who has time for that? There are really nice free tools that allows you to split your XML files with just a few clicks.

For Windows users, there is a tool called WordPress WXR File Splitter. Download and run this utility. When you run this program, you will see a screen like this:

WordPress XML Splitter utility

Click on the open WXR file button to open your WordPress XML file. This tool will then read your XML file and show you some useful information about the data in it. It will get the header, the footer, and it will show you the number of items in the file.

You can adjust the size limit for when you split your large file into smaller ones. Alternatively, you can provide the number of files you want this to be split into. Either way, the goal is to get the files to be small enough, so you can upload it on your host without surpassing the limits. Finally when you are ready, press Split Files button, and it will split the files and store them in the same folder as your original WordPress XML file.

For all you Mac users, you are not left out. There is a similar WordPress WXR Split utility available for Mac users. It does the same thing, splits large XML file into smaller file sizes.

Mac WXR Splitter

We hope that this article helped you split your large WordPress XML files, so you can import them into your WordPress. Let us know if you have any questions by leaving a comment below.

67 Shares
Share
Tweet
Share
Pin
Popular on WPBeginner Right Now!
  • How to Start Your Own Podcast (Step by Step)

    How to Start Your Own Podcast (Step by Step)

  • How to Properly Move Your Blog from WordPress.com to WordPress.org

  • Revealed: Why Building an Email List is so Important Today (6 Reasons)

    Revealed: Why Building an Email List is so Important Today (6 Reasons)

  • Checklist

    Checklist: 15 Things You MUST DO Before Changing WordPress Themes

About the Editorial Staff

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Trusted by over 1.3 million readers worldwide.

The Ultimate WordPress Toolkit

13 Comments

Leave a Reply
  1. Kingsley Felix says:
    Aug 29, 2018 at 5:28 am

    Not working for windows 10 and it seems this is the only XML spiltter on the internet

    Reply
  2. Eman says:
    Oct 18, 2017 at 4:01 am

    And for Linux users? Is there an online tool for that?

    Reply
  3. Aaditya Sharma says:
    Apr 18, 2017 at 12:51 am

    WordPress WXR File Splitter not working in windows 10, can you suggest me any other software or can we split .sql database any other method or software??

    Reply
  4. Amit Virani says:
    Mar 31, 2016 at 5:37 am

    In wordpress version 1.10.11 it allows me to upload maximum file size 32 mb but when I upload a 20 mb xml file it shows error 500 Internal Server Error

    Reply
    • WPBeginner Support says:
      Mar 31, 2016 at 10:20 pm

      This could be due to mmaximum execution time or PHP memory limit. You may also want to checkout our guide on how to fix internal server error in WordPress.

      Reply
  5. Caloolgeele says:
    Nov 29, 2015 at 8:54 am

    Thank you very much. You save my life.

    Reply
  6. Edos Ubebe says:
    Nov 5, 2015 at 9:01 pm

    Hello,

    I want to say thank you so much for this awesome post, you just saved my life. Thank you.

    Reply
  7. ahmed says:
    Aug 30, 2015 at 4:28 pm

    i have 121 mb xml file K downloaded from blogspot to my computer , and i can not split that file with the tool in the article , it give me erroro massege , and right now i have no idea what i have to do …. i can not upload the file to wp as it is over the allowed size ( 62 mb ) …is there any way to get xml file uploaded or splitted
    thanks

    Reply
  8. Brendan says:
    May 12, 2014 at 3:26 pm

    The Mac one does not recognise .XML

    Reply
  9. Ahmed Yosry says:
    Feb 6, 2014 at 10:15 am

    Thanks

    Reply
  10. Bill says:
    Aug 22, 2013 at 7:49 am

    I discovered (fortuitous accident), that with large XML files, you can just run the importer multiple times. This uploads content in batches.

    Reply
    • Miguel says:
      Apr 2, 2014 at 5:23 pm

      yes, but it will duplicate your content and menus

      Reply
  11. Akhil Gupta says:
    May 7, 2013 at 12:51 am

    Thanks for this valuable information :)

    Reply

Leave a Reply Cancel reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

Over 1,320,000+ Readers

Get fresh content from WPBeginner

Featured WordPress Plugin
SeedProd WordPress Coming Soon Page Plugin
SeedProd
Jump start your website with viral coming soon pages. Learn More »
How to Start a Blog How to Start a Blog
I need help with ...
Starting a
Blog
WordPress
Performance
WordPress
Security
WordPress
SEO
WordPress
Errors
Building an
Online Store
Useful WordPress Guides
    • 7 Best WordPress Backup Plugins Compared (Pros and Cons)
    • How to Fix the Error Establishing a Database Connection in WordPress
    • Why You Need a CDN for your WordPress Blog? [Infographic]
    • 25 Legit Ways to Make Money Online Blogging with WordPress
    • Self Hosted WordPress.org vs. Free WordPress.com [Infograph]
    • Free Recording: WordPress Workshop for Beginners
    • 24 Must Have WordPress Plugins for Business Websites
    • How to Properly Move Your Blog from WordPress.com to WordPress.org
    • 5 Best Contact Form Plugins for WordPress Compared
    • Which is the Best WordPress Popup Plugin? (Comparison)
    • Best WooCommerce Hosting in 2019 (Comparison)
    • How to Fix the Internal Server Error in WordPress
    • How to Install WordPress - Complete WordPress Installation Tutorial
    • Why You Should Start Building an Email List Right Away
    • How to Properly Move WordPress to a New Domain Without Losing SEO
    • How to Choose the Best WordPress Hosting for Your Website
    • How to Choose the Best Blogging Platform (Comparison)
    • WordPress Tutorials - 200+ Step by Step WordPress Tutorials
    • 5 Best WordPress Ecommerce Plugins Compared
    • 5 Best WordPress Membership Plugins (Compared)
    • 7 Best Email Marketing Services for Small Business (2019)
    • How to Choose the Best Domain Registrar (Compared)
    • The Truth About Shared WordPress Web Hosting
    • When Do You Really Need Managed WordPress Hosting?
    • 5 Best Drag and Drop WordPress Page Builders Compared
    • How to Switch from Blogger to WordPress without Losing Google Rankings
    • How to Properly Switch From Wix to WordPress (Step by Step)
    • How to Properly Move from Weebly to WordPress (Step by Step)
    • Do You Really Need a VPS? Best WordPress VPS Hosting Compared
    • How to Properly Move from Squarespace to WordPress
    • How to Register a Domain Name (+ tip to get it for FREE)
    • HostGator Review - An Honest Look at Speed & Uptime (2019)
    • SiteGround Reviews from 1032 Users & Our Experts (2019)
    • Bluehost Review from Real Users + Performance Stats (2019)
    • How Much Does It Really Cost to Build a WordPress Website?
    • How to Create an Email Newsletter the RIGHT WAY (Step by Step)
    • 7 Best CRM Software for Small Businesses (Compared)
    • How to Create a Free Business Email Address in 5 Minutes (Step by Step)
    • How to Install Google Analytics in WordPress for Beginners
    • How to Move WordPress to a New Host or Server With No Downtime
    • Why is WordPress Free? What are the Costs? What is the Catch?
    • How to Make a Website in 2019 – Step by Step Guide
Deals & Coupons (view all)
WPEngine
WP Engine Coupon
Get 20% OFF on all WP Engine hosting plans or 4 months free on annual payment.
Visual Composer
Visual Composer Coupon
Get 20% OFF on Visual Composer WordPress page builder plugin.
Featured In
About WPBeginner®

WPBeginner is a free WordPress resource site for Beginners. WPBeginner was founded in July 2009 by Syed Balkhi. The main goal of this site is to provide quality tips, tricks, hacks, and other WordPress resources that allows WordPress beginners to improve their site(s).

Site Links
  • About Us
  • Contact Us
  • FTC Disclosure
  • Privacy Policy
  • Terms of Service
  • Free Blog Setup
Our Sites
  • OptinMonster
  • MonsterInsights
  • WPForms
  • SeedProd
  • Nameboy
  • RafflePress

Copyright © 2009 - 2019 WPBeginner LLC. All Rights Reserved. WPBeginner® is a registered trademark.

Managed by Awesome Motive | WordPress hosting by HostGator | WordPress CDN by MaxCDN | WordPress Security by Sucuri.