Import Content from a CSV or Another CMS with AI
Turn a CSV or an old CMS export into real WordPress posts with the right fields and categories, no copy-paste.
Prerequisites
A connected site and your content as a CSV (or fields you can paste as text). For large imports, take a backup first so a bad mapping is easy to undo.
Import the content in the CSV below into my connected site [site URL] as posts. Map the columns like this: [describe your columns, e.g. Title, Body, Category, Date]. Handle categories correctly: for each category name in the file, first create it as a WordPress category if it does not already exist, then assign posts to it by its ID, so nothing lands in Uncategorized. Create every post as a draft, not published. When you finish, read back three or four of the new posts and show me their title, category, and first line so I can confirm the mapping worked before I publish the rest. If any row is missing a title or body, list it and skip it rather than creating a broken post. Here is the CSV: [paste your CSV]
Already connected to WPVibe?
Skip the copy-paste. Just ask your AI for the “Import Content from a CSV or Another CMS with AI” recipe, or describe the task, and WPVibe runs these steps on your own site.
Moving content into WordPress from a spreadsheet or an old CMS is the part of a migration everyone dreads. You have a CSV of posts, or an export from a platform you are leaving, and each row needs to become a real WordPress post with the right title, body, date, and category. Doing it through copy and paste is a day of dull, error-prone work, and the classic mistake is that every post lands in Uncategorized because the category names in your file never got matched to real WordPress categories.
Your AI assistant can read your CSV and create the posts for you, and it handles the category trap correctly. It first creates or finds each category as a real WordPress term, then assigns posts to it by ID so nothing falls back to Uncategorized. It maps your columns to title, body, excerpt, and status, creates everything as drafts by default so nothing goes live before you look, and reads a few back so you can confirm the fields and categories came across right.
Paste the prompt below with your CSV. This recipe is written and tested for CSV rows, which is the most reliable format; an export from another CMS works too as long as you can hand the AI the fields as text or a CSV. Everything is created as a draft, so review a sample before you bulk-publish, and if you are importing hundreds of rows, take a backup first so a bad mapping is easy to undo.
Outcome
Each row of your CSV created as a draft WordPress post with title, body, excerpt, and category correctly assigned by ID.