This Tutorial is for wordpress users who love and use the Yoast SEO plugin for WordPress and want to be able to import posts with the SEO meta data in mass via CSV file.
This saves time and money keeping you from having to spend $30 to $299 on software that hides how really easy this is.
Step 1 – Install the free http://wordpress.org/extend/plugins/csv-importer/
Step 2 – Import your CSV File, and assign each table to the proper column label. When you get to the SEO Title, Tags and Discription just scroll to the last option and select Add Custom Field

Step 3
Then past the corisponding field name where you want the SEO data to go into the Custom Field Box

Step 4 – Import your CSV File, and assign each table to the proper column label. When you get to the SEO Title, Tags and Discription just scroll to the last option and select Add Custom Field

Step5- The three mains ones are SEO Tile, SEO
Keywords and SEO Discriptions but you can also map all of the Yoast Fields by just adding more to your CSV file.
Here is a list of the additional fields that can be mapped with Custom Fields
- _yoast_wpseo_focuskw
- _yoast_wpseo_title
- _yoast_wpseo_metadesc
- _yoast_wpseo_metakeywords
- _yoast_wpseo_meta-robots-noindex
- _yoast_wpseo_meta-robots-nofollow
- _yoast_wpseo_meta-robots-adv
- _yoast_wpseo_canonical
- _yoast_wpseo_redirect
Hope this Tutorial helps alot of people and keeps you from having to pay alot of money and waste time on software you do not need to buy. If you have any questions please leave them in the comments below…