---
title: "How to Import WordPress Blog Posts from CSV or Excel File"
url: "https://wpimportexport.com/import-wordpress-blog-posts-from-csv-excel/"
description: "Import WordPress posts from CSV or Excel with categories and featured images. Download sample files, map columns and update existing posts by slug."
type: post
published: 2026-08-16T10:21:58+00:00
modified: 2026-11-14T10:33:52+00:00
categories: ["Import Export Guides", "Import Guides", "Media Import", "Video Lessons"]
tags: ["ACF import WordPress", "Import Export by RockStarLab", "import posts from CSV", "import WordPress blog posts", "WordPress CSV import", "WordPress Excel import", "WordPress migration"]
docs_topics: ["Import 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](https://wpimportexport.com/wp-content/uploads/2026/11/wordpress-travel-posts.csv) to create two draft walking guides. Then use the [sample Excel update workbook](https://wpimportexport.com/wp-content/uploads/2026/11/wordpress-travel-posts-update.xlsx) 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](https://wpimportexport.com/wordpress-csv-posts-export/) 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](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) 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](https://wpimportexport.com/wp-content/uploads/2026/11/blog-import-01-type.webp)

_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](https://wpimportexport.com/wp-content/uploads/2026/11/blog-import-02-preview.webp)

_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](https://wpimportexport.com/wp-content/uploads/2026/11/blog-import-03-mapping.webp)

_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](https://wpimportexport.com/wp-content/uploads/2026/11/blog-import-04-options.webp)

_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](https://wpimportexport.com/how-to-bulk-update-existing-wordpress-posts-without-creating-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](https://wpimportexport.com/wp-content/uploads/2026/11/blog-import-05-result.webp)

_Use the Created, Updated, Skipped and Failed counts to check the outcome._

![Two imported draft posts in the Walking Guides category](https://wpimportexport.com/wp-content/uploads/2026/11/blog-import-06-posts.webp)

_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](https://wpimportexport.com/how-to-use-the-wordpress-abilities-api-with-ai-agents-exports-imports-content-sync-and-backups/) 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.

[Video: How to Import WordPress Blog Posts from CSV or Excel File](https://www.youtube.com/watch?v=WNrbufckPDU)

## 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.
