Doesn't work

Well, it’s working for me – this is still one of the most powerful plugins out there. @laptopsticker, perhaps the best thing to do before importing is trying to export a csv.

This is what I did (using a custom post type example):

– I have a custom post type called “restaurantes”, so I set the WP CSV plugin to export only published posts that correspond to said type (i.e. “restaurantes”). Now I’ve got an example of what the plugin recognizes as a valid CSV;
– I then upload this csv to a Google Spreadsheet and analyze/choose the columns that matter to me;
– I copy all data from my own database sheet to the relevant fields that the plugin’s export csv provided. Thanks to some hlookup, index and match formulas, I quickly populate my sheet with 250 new rows. Plenty of columns I leave blank (from Yoast SEO, Ninja forms fields, etc.);
– I then download this Google sheet as a csv, now with all my fields matched and ready to be uploaded to WordPress. In order to avoid mistakes, I set all the 250 values in the “post_status” column to “pending” (this way I know where they end up!);
– Finally, I can use the plugin import that csv to WordPress

After the plugin’s success message, I go to check my “Restaurantes” and voilà, I’ve got my 250 “restaurantes” pending review, properly imported (custom fields included) and nearly ready to be published.

Hope this is understandable… anyway, the plugin is working fine.