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.

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.

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.

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 |

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.


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.

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