The WP All Import plugin allows you to import posts based on a custom post type from a CSV file into your WordPress site.
Prepare a CSV file with the data you would like to import to your WordPress site.
- Include fields headings in the first row, one per column. The headings don’t need to match the names of the custom fields you have defined in Toolset Types plugin but it’s good if they correspond. It will be easier for you to map the columns of your CSV file to the custom fields of your WordPress site.
- In the rows that follow include your post data, one post per row.
The nice thing about WP All Import is that it doesn’t really care how the data is formatted. WP All Import can handle CSV, TSV, Excel, XML, JSON, SQL. You upload the file and WP All Import will parse it properly.
If your file is one of the above formats you can just upload it to WP All Import. Here’s an example CSV file you can use (every column is a field, every row is a record).
Here is an example of an imported post after successfully importing a CSV file:
Install and activate the following plugins:
- Go to All Import -> New import
- Click on the Upload a file button and select your CSV file from your drive.
- In the Import data from this file into… choose whether you are adding a new post or updating existing ones and select your post type from the dropdown (“Movies” in our case)
- Click Continue to step 2
- On the next screen, you can review your data and set up filters if you need some
- Click Continue to step 3
- Map the fields from your CSV file to your WordPress fields by dragging the items from the sidebar to relevant fields.
In our example the field called “moviename” will become the post title, the other field will be mapped to Types custom fields.
- Click Continue to Step 4.
- Enter your unique identifier (the auto-detect button will help).
- Click Continue.
- On the last screen read the “Import Summary” and click Confirm and Run the Import.
If everything goes well your posts will be imported and you will see the “Import Complete!” message.
Go ahead and visit of one your posts to check if everything got imported as expected.
Refer to WP All Import documentation for further instructions.
Now, you can also import your posts from a CSV file and maintain relationships between your post types.
Read more about importing and setting up relationships between posts.