Import CSV File Into WordPress To Create New Posts

Job ID: 34403647

Budget: $30 – $250 USD

This project is to import a CSV file into WordPress, automatically creating new posts based on the data. Currently it is "one big" CSV file that has three columns.

Column One is Topic
Column Two is Quotes (that matches the Topic)
Column Three is Author (author of the quote in Column Two)

I need the Data in Column One (Topic) to be the title of the post, for example "Ability Quotes".

I need the Data in Column Two (the quotes that match the particular topic) to be the "Body Content" of the post, so all the quotes for the topic need to be in the body content, separated as "Quote #1" Quote #2" etc, and below the quote would be the "Author" that matches.

As an additional step, I would like to create "New posts" as well that would have the "Author" as the "Title" and the body content would be all the quotes that match that particular author.

Please don't ask for more details without first clearly reading what I have said above, as above are the details and instructions. For those that truly read and understood what I am trying to do, please see attached CSV file for the file that needs to be imported as posts.

Thanks