Bug with Wordpress import plugin & data formatting

I use a plugin that allows you to import data (csv/txt files etc) into Wordpress posts. The problem I'm having is, I have some scraped data in a csv file that I want to import, but when I try to it fails. I believe it may be a simple data formatting/encoding issue, as within the data an apostrophe appears as ' etc I need you to establish what is wrong with the formatted data and import the data successfully. You'll also need to tell me what needs to be done to the data so I can 'fix' other similar csv files. I have a blank Wordpress site with the plugin installed for you to test on. Obviously I will also give you the data file.