Back to blog
6 min read Import Export Guides

How to Import WordPress Blog Posts from CSV or Excel File

Importing posts from a spreadsheet works the first time with almost any settings. The second run shows whether the setup was right: either it updates the same posts or it creates a second copy of each. In the Import Export by RockStarLab import wizard, choose Blog Posts, upload one row per post, map the columns and pick how an existing post is handled.

Prepare a spreadsheet with one row per post

Download the sample CSV to create two draft walking guides. Then use the sample Excel update workbook to revise the Riverside guide. The workbook keeps both slugs and changes one paragraph, so you can see exactly what a repeat import does. Both files use the same demonstration image. Substitute your own publicly reachable image URLs for production.

Column What to put in it
post_title The headline as readers should see it.
post_name A unique slug, such as riverside-walking-itinerary. Keep it identical across revisions.
post_content The article body. HTML such as <p> can stay in one spreadsheet cell. Use your spreadsheet editor to save the CSV so commas in sentences are quoted correctly.
post_status Use draft to review posts before publishing.
taxonomy_category The category name. Both example rows use Walking Guides.
featured_image_url A direct URL to an image file, rather than the page where it appears.

If your spreadsheet comes from another WordPress site, follow the WordPress post export guide to include the original HTML, slugs, terms and featured image URLs. Back up the destination before changing existing posts. The WordPress backup and restore tutorial covers that step.

1. Choose Blog Posts and upload the file

Open Import Export by RockStarLab → Import on the destination. Select Blog Posts → Next Step. After backing up, acknowledge the backup reminder if it appears. Click Select File or drag in the CSV or XLSX file.

Blog Posts selected in the WordPress import wizard
Choose Blog Posts for entries that belong in Posts → All Posts.

2. Check the preview before mapping

Compare the preview with your spreadsheet. In the sample there are two rows and six columns. The first body contains a comma after “footbridge” and should remain in one cell. A whole row in one column or a body split across several columns is a reason to correct the file before continuing.

CSV preview showing two draft posts and six columns
Check the slug, HTML, category and image URL before mapping.

3. Map file columns to post fields

Click Auto Map and inspect Mapped Fields. Match the headline to Title, the slug to Slug, and the article body to Content. A vendor column named “Article” might contain a headline or an entire body. Read its sample value before choosing a destination. Map the category to the category taxonomy and the lead image to the featured image URL field.

Six CSV columns mapped to WordPress post fields
Review each source column and destination field after Auto Map.

4. Decide what happens when a slug matches

Under Check for Existing Items by Field, select Slug. Choose the two actions according to the purpose of the run:

File purpose If Match Found If No Match Found
Load a catalog of posts and keep it current Update Create
Add missing posts while protecting existing copy Skip Create
Apply corrections only to known posts Update Skip
Slug matching with Update for matches and Create for new posts
Keep the slug stable when you want later files to update the same posts.

For the first sample run, use Update / Create. If the slug already belongs to an unrelated post, the importer will treat it as a match. Check the slugs on your site first. For an update-only workbook, choose Update / Skip so that a misspelling cannot create an extra post. See the guide to updating existing posts without duplicates for more on matching.

Keep Automatically Import Media Files enabled if images found in the content should be downloaded into the destination Media Library. Select the featured image field separately when the spreadsheet specifies a lead image. Ensure the destination server can access each URL without signing in.

5. Review the imported posts and apply an Excel update

Click Start Import. When the run finishes, read the individual result counts. On a site where neither sample slug exists, expect two created posts. Open Posts → All Posts, locate the drafts, then preview one. Check the headline, paragraph formatting, category and featured image before publishing.

Import result with two posts created and zero failures
Use the Created, Updated, Skipped and Failed counts to check the outcome.
Two imported draft posts in the Walking Guides category
Open the new drafts from Posts → All Posts to review them before publication.

Now upload the sample XLSX, review its mapping and choose Slug → Update / Skip. Open the original Riverside draft again. Its paragraph should now read “Start at the footbridge and stop at the old mill.” The Hilltop paragraph should stay the same. Search for both titles to confirm there are still two drafts. If a revision was skipped, compare the incoming slug with the existing post’s actual slug.

Import or update WordPress posts with an AI agent

Follow the AI agent connection guide on the destination. Give the connected agent the import file or its uploaded file ID and specify the matching rule. Ask for a preview before authorizing changes:

Prepare this CSV as a WordPress Blog Posts import. Show the row count and a source-to-destination mapping for title, slug, HTML body, status, category and featured image URL. Check that both rows are drafts and have distinct slugs. Stop before starting the job.

Check the suggested mapping yourself. If the category was omitted, ask the agent to add taxonomy_category explicitly. Once the preview is correct, give the agent the actions for matches and missing posts.

Import this update workbook on the connected site. Match by post_name, update matches and skip missing posts. Preserve draft status. Validate the complete mapping, start the job once, and wait for completion. Report processed, failed and skipped rows. Verify the revised Riverside paragraph on the existing post.

The agent can use rsl-ie/import-prepare to inspect the file, rsl-ie/import-validate to check the mapping, rsl-ie/import-start to submit it, and rsl-ie/job-get to monitor completion. An accepted job may still be preparing spreadsheet rows. Wait for completion before reviewing the drafts.

Video walkthrough

The video shows an earlier interface. Follow the screenshots above for the current field mapping and duplicate-handling controls.

FAQ

Can I import WordPress blog posts from CSV?

Yes. Import Export by RockStarLab lets you import WordPress blog posts from CSV files and map file columns to WordPress fields.

Can I import WordPress blog posts from Excel?

Yes. You can import blog posts from Excel XLSX files as part of the import workflow.

Can imported images be downloaded into the Media Library?

Yes. The plugin can automatically download found images into the WordPress Media Library during import.

Can I import ACF fields with blog posts?

Yes. If Advanced Custom Fields is installed and the required fields exist on the destination website, ACF field data can be imported with blog posts.

Can I import ACF Repeater fields?

Yes. ACF Repeater field data can be imported when it exists in the import file and the destination website has the correct ACF field setup.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE