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.

200w_d-1.gif

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'

mceclip0.png

  • 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

Was this article helpful?

82 out of 178 found this helpful

Comments

Article is closed for comments.