How To Export WordPress Posts (And Anything Else!) To CSV Easily: Super Simple Guide
🚀 Want your WordPress site to load faster? I use WP Rocket: https://mattbusiness.com/recommends/w...
I walk you through exporting WordPress posts into a CSV file for easy data access and manipulation.
Using the WP All Export plugin, you’ll learn how to pull essential post data, such as titles, dates, permalinks, categories, and SEO keywords, directly from your WordPress backend into a spreadsheet.
Perfect for anyone needing to manage content or perform bulk edits, this tutorial will simplify exporting WordPress content to a CSV.
#WordPress #WordPressTips #WordPressPlugins
Timestamps:
00:00 Intro
00:10 Installing the WP All Export Plugin
00:30 Activating WP All Export and Navigating the Dashboard
01:12 Creating a New Export for Posts
01:42 Customizing the CSV Export Columns
03:01 Selecting Metadata for Export (ID, Title, Date, etc.)
05:00 Previewing the Exported Data
06:14 Running the Export and Downloading the CSV
07:00 Closing Remarks
▬▬▬▬ Links & Resources ▬▬▬▬
SUBSCRIBE to my YouTube channel! ► / @mattcrawfordentrepreneur
Our huge thanks to those who continue to support the channel. If you want to help out, feel free to use my links below:
🎥 My Main Camera – https://amzn.to/3UoRxYo
🖥️ My Monitor – https://amzn.to/4a5LsWw
🎙️ Top Microphone – https://amzn.to/3Wp75xQ
🔆 Key Light – https://amzn.to/3Wpw04k
💡 Softbox – https://amzn.to/3w9XlNv
🔅 Fill Light – https://amzn.to/3UoIWov
🎬 Want to get more clients & grow your company to 7 figures per year? Free guide here – https://creator.mattbusiness.com/get-...
📚 The 160 Books That Changed My Life: Free eBook – https://mattbusiness.com/must-read-books
🎯 Level up your online business & get a 30 day free trial of Kajabi: https://mattbusiness.com/kajabi
▬▬▬▬ Follow Me & Keep In Touch ▬▬▬▬
Twitter – / mattacrawford
Instagram – / mattcrawfordcreator
Pinterest – https://www.pinterest.co.uk/filmlifes...
Filmmaking Lifestyle Site – https://filmlifestyle.com/
Facebook – / filmmakinglifestyle
▬▬▬▬ Video Transcript ▬▬▬▬
Hi, this is Matt Crawford, and this is a video on how to export all of the posts in your WordPress backend into a CSV, into a spreadsheet. So I'm here in the dashboard of one of my sites, Filmmaking Lifestyle, and the plugin that I recommend is called WP All Export. I'm on the plugin section here, and I'll show you how to get it. You're going to come down to the plugin section, click on “Add New,” and then search for “WP All Export.”
So, the one you’re looking for is this one with the octopus logo, green background. It’s called WP All Export and is created by Soflyy. Once you’ve installed and activated it, we’ll go back to the dashboard, and I’ll show you how to use it. Look for the octopus symbol on your sidebar and click “All Export.” We’ll then choose “New Export.”
Now, there’s a lot you can do with this plugin. For this video, I’m just going to show how to export posts, but you can also export pages, taxonomies, comments, users, and much more—especially if you have the pro version. For now, select “Posts,” and this will begin loading all posts on the site.
This site is rather large, so it's taking a little while. I actually have 4,882 posts ready to be exported. We’ll skip filtering options for this video, so let’s go straight to “Customize Export File.”
Now, this is where it gets interesting because you get to choose what data goes into your CSV export. By default, it includes the post ID, title, and content, which might be useful but can make the file huge if you have long posts. So, if you don’t need full content, you can just drag that out of the export window. On the left here, you’ll see a ton of other options based on your WordPress setup, which can be added to the CSV.
Under “Standard,” we have options like ID, Title, Date, and Permalink (which is the URL). I’ll add Date and Permalink to our export. You’ll also have Media options, so you could add images, file names, or URLs if needed. Then, we have “Taxonomies,” where you can add categories or tags. For this demo, I’ll add categories, too.
Now, under “Custom Fields,” you’ll see fields that vary depending on the plugins you have installed. For example, if you’re using Yoast SEO, you’ll see options for things like “Focus Keyword.” That’s helpful if you want to export SEO data, so I’ll include that here. There are a few more fields under “Other,” but for now, we’ll stick with these.
When you’re ready, click “Preview” to see a sample of what the CSV will look like. You’ll see each column with data like post ID, title, date, permalink, categories, and any other fields you’ve selected. Once that’s set, click “Continue.”
Now, we’re on the final export screen. You can leave most settings as they are and just click “Confirm and Run Export.”