Many people (including me) are searching for, and asking how you can use custom fields in the WordPress CSV importer. The plugin page says:
Any column that doesn’t start with
csv_is considered to be a custom field name. The data in that column will be imported as the custom fields value.
So I made an excel spreadsheet with 2 columns:
- (example) my_custom_field
And by importing this CSV file WordPress gave me the following error:
Skipped 3 posts (most likely due to empty title, body and excerpt). Imported 0 posts and 0 comments in 0.23 seconds
But after trying different combinations of column names as: csv_post_post and csv_post_type nothing worked and every time WordPress gave me the error. So maybe it was my CSV file that isn’t saved the right way. Then I went to Google Drive where you can make spreadsheets. I made a Spreadsheet in Google (the same as my old one, with the 2 columns), Saved it as CSV file, imported it with WordPress CSV importer and it Worked!
So my solution for importing Custom fields in WordPress CSV importer is to use CSV files from Google Spreadsheet.