If you only have a few rows with apostrophes, then that may not be a big deal. Or, since Drupal is telling you where the problem is, you can do it manually.
Part of the problem here is that there's no standard specification for CSV.Īdded to that, Microsoft does not have much incentive to ensure interoperability between their version of CSV and Drupal's version, and so it is not surprising that they do not offer any (direct) way to encapsulate the contents of cells with single quotes within double quotes, so you've got to do something a bit more complicated if you want Excel to output Drupal-friendly CSV files.
