Working with Import CSV Files

Add the Import CSV Files plugin.

/related example - How to install plugins/

/Download link for the .zip file - Download/
The plugin adds a sub-menu item in the Tools section.
Click Browse to select the .csv file, change the post type and field delimiter if necessary and click Next.
Preview of the file data will show up.
Map the fields from the .csv files to post fields.
You can select a default post status and category for imported items (if not found or mapped) and click Next.
Wait for the import process to finish and view the report.