How to convert csv files encoding to utf-8

Question

Is it possible to convert csv data that has iso-8859-13 encoding to UTF-8?

My old system does not have UTF-8 encoding, it uses only iso-8859-13. The system that I need to import to does not have iso-8859-13, but has both UTF-8 and UTF-16. If I try to open the csv file with an encoding other than iso-8859-13, then some symbols are not recognized. If I try to import such file into the new system, it gives an error that I have wrong encoding. I can only import it using windows-1252, but then it will import with unrecognized symbols. What can I do to convert it to normal encoding such as UTF-8?

Solution 1

I was able to convert simply using text editor. I opened csv file with iso-8859-13 encoding. Then created empty csv file with utf-8. Then simply copied everything from one csv to another. Then I could import it into new system.

Previously I tried to do this with libreoffice, but for some reason it would save with iso-8859-13 encoding.

Solution 2

Open the file in Notepad++ and click Encoding->Convert to UTF-8.

(Do not click Encode in UTF-8 because it won't actually convert the characters.)

Solution 3

For those who don't know how to convert the file's encoding using Notepad++ : Create a new file in Notepad++ -> Go to Encoding -> Encode in UTF-8 -> Copy-paste the contents -> save the file as .csv

Solution 4

For me worked that way: Open CSV file with regular Notepad. Save as in Notepad and set encoding like in picture.Encoding

View more solutions