Correcting a CSV file containing uninterpreted special characters
This article is intended for:
Admin
Module concerned:
Have you just exported a CSV file and does it contain unwanted special characters (accents, letters that appear to have been misinterpreted, for example)?
Here is a workaround that will allow you to obtain a file that better meets your expectations in just a few clicks.
Contents of this article:
Correcting the CSV file
- Download the Notepad++ application (free software)
- Right-click the CSV file in question
- Select 'Edit with NotePad ++'
- The file opens in Notepad ++
- Click the 'Encoding' tab
- Click 'Convert to ANSI'
- Save the file: it is ready to use, and the special characters are correctly interpreted
- The encoding procedure is complete
Keywords associated with this article:
Special characters - CSV file - Convert to UTF8 ANSI - Unreadable field export - Misinterpreted accents - non-letters - unusable payroll export - incomprehensible accented characters - Notepad ++ - download CSV file - convert data - encoding
Comments
Article is closed for comments.