How do I fix special characters in an exported CSV file?

How do I fix special characters in an exported CSV file?

Sometimes, certain characters may appear unreadable after exporting a CSV file.

This issue is usually related to the file’s encoding. When you double-click a CSV file, some versions of Excel do not automatically open it with the correct encoding (UTF-8). As a result, accents and special characters may display incorrectly.

Follow these steps to open the file properly in Excel:
  1. Open a blank Excel file.
  2. Click the File tab and select Import.
  3. Choose CSV file as the file type to import.
  4. Select your file and click Get Data.
  5. In the import options, choose CSV – Unicode (UTF-8) as the file format.
  6. Make sure the delimiter is set to Semicolon (;), then click Next.
  7. Confirm the column format and click Finish.
  8. Choose where you want the data to appear, then click Import.
Your file should now display correctly, with accents and special characters properly formatted.

If you are using Windows, you can also refer to the detailed step-by-step procedure here.

    • Related Articles

    • Is it possible to export my data?

      You can export your records directly from the platform, or contact our team to request a full export of your data. Export one or more records Exporting allows you to download the information contained in one or more records as a .zip file. Export a ...

    • How do I delete my account?

      To delete your account: Click on the icon with your initials in the left-hand menu. Select "My account." At the bottom of the page, you will find the button allowing you to delete your account. Please note: Once your account is deleted, all data ...

    • What happens to my data when I delete a client record or my account?

      Deleting a Client Record When you delete a client record, it moves to the Deleted tab, where it remains for 30 days. After that, it is permanently deleted along with all its contents, except for financial records. You have 30 days to restore a ...

    • What happens if I decide I no longer want to use Psylio?

      Of course we will be sad to see you go, but you have the freedom to end your subscription at any time. You can opt to archive your records, return to the free plan and continue to use the free version of Psylio for as long as you wish to keep your ...

    • What is the process for implementing Psylio in my organization?

      First of all, thank you for your interest in Psylio! The first step in implementing Psylio in your organization is to receive a service proposal. In order for our team to send you a service proposal tailored to your needs, we ask you to complete this ...