Saving .CSV in Excel adds extra quotes.

If you have found that after saving and then importing from an excel saved csv file that extra quotes are added, here is the solution for removing them.

1. Open the file in a text editor such as WordPad or something similar.

2. Go to http://cwire.com/pub/FYI/HTML/equivalents.asp and note the HTML equivalents for the double quote ( " ), the comma ( , ) and the single quote ( ' ).

3. First do a Find and Replace command (CTRL+F) and replace all double quotes with their equivalent.

4. Next do a find and replace and replace all commas with their equivalent.

5. Lastly do a find and replace and and replace all single quotes with their equivalent.

6. Save the file and reimport it.

  • 96 Users Found This Useful
Was this answer helpful?