So I took them out and put as does not instead, and it worked out fine.

Csv can work well with single quotes, but only within the value (not as a separator).

As a separator you need either double quotes or nothing: a,b,c or a,b,..

Regarding the comma as a separator, you can even omit it (but make sure to have no comma at all): a b c.

If you only have a few rows with apostrophes, then that may not be a big deal.

If you have a lot of rows in your CSV with apostrophes or single quotes, then youve got a bit of pain.

It all depends on the languages and language environments youre comfortable with, however.

If you are of this opinion, you may want to file a request with the Feeds project.

Since there is no (standard) CSV spec, this cant be considered a bug (AFAIK), but it does seem like a useful feature that they might want to add.

Then I export them from Access to a csv file by using an advanced feature to save in UTF-8 format.

At the moment I dont have Access so I cant give a better description, but it does work.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged feeds importing-exporting or ask your own question.

Excel For Mac Escape Single Quotes In Csv