CODEWITHSUNDEEP
csvencodingutf-8importconverters
Andrius
Andrius

Reputation: 21168

How to convert csv files encoding to utf-8

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?

Upvotes: 33

Views: 153749

Answers (6)

Megidd
Megidd

Reputation: 7961

I opened my file in MS Notepad, and then the File > Save As menu would let me choose the encoding.

Screenshot

Upvotes: 0

Rogelio Macedo
Rogelio Macedo

Reputation: 21

Copying .csv content from Excel to Notepad++ does not preserve format, open original .csv in Notepad++ and copy from there.

  1. Once opened in Notepad++, create new file in Notepad++ using 'Ctrl + n'.
  2. Go to Encoding -> Convert to UTF-8-BOM -> Copy-paste the contents -> save the file as .csv.

(Windows 10)

Upvotes: 1

Vesselin Cohen
Vesselin Cohen

Reputation: 49

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

Upvotes: 2

SharkAlley
SharkAlley

Reputation: 11659

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.)

Upvotes: 39

KLeonine
KLeonine

Reputation: 187

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

Upvotes: 5

Andrius
Andrius

Reputation: 21168

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.

Upvotes: 19

Related Questions