Symbols (’) replacing apostrophe sign in .csv downloads

Some of you may have experienced problems with goofy characters replacing the apostrophe sign in .csv downloads. That is because of the ‘fancy’ apostrophe with the curl – the one you get by typing an apostrophe in Microsoft Word – entered into the CRM.

The data in the csv file is correct. The problem is opening the file in excel.

To open a csv file that contains non-ascii characters in excel use the following approach:

1. Save the exported file as a csv
2. Open Excel
3. Import the data using Data–>Import External Data –> Import Data
4. Select the file type of “csv” and browse to your file
5. In the import wizard change the File_Origin to “65001 UTF” (or choose correct language character identifier)
6. Change the Delimiter to comma
7. Select where to import to and Finish

This way the special characters should show correctly. For those who are more comfortable copying and pasting data from MS Word into the CRM, you may also disable the “Smart Quotes” from MS Word’s settings.

Here’s how to disable Smart Quotes in MS Word 2007 :

1. Click the Microsoft Office Button , and then click Word Options.
2. Click Proofing, and then click AutoCorrect Options.
3. In the AutoCorrect dialog box, do the following: 
   • Click the AutoFormat As You Type tab, and under Replace as you type, select or clear the “Straight quotes” with “smart quotes” check box. 
   • Click the AutoFormat tab, and under Replace, select or clear the “Straight quotes” with “smart quotes” check box.

Here’s how to disable Smart Quotes in MS Word 2013 :

1. Click File , and then click Options.
2. Click Proofing then Click Auto Correct Options
3. In the AutoCorrect dialog box, do the following: 
   • Click the AutoFormat As You Type tab, and under Replace as you type, select or clear the “Straight quotes” with “smart quotes” check box.
   • Click the AutoFormat tab, and under Replace, select or clear the “Straight quotes” with “smart quotes” check box.

Was this article helpful?

0 0

How can we improve this article?

Name

Email

Submit