All Questions
9
questions
1
vote
1
answer
660
views
How to tell Excel to change right encoding in opened file?
Can somebody tell me please how to tell Excel to set up right encoding for csv file? It seems it is not possible without any annoying steps. I would like to see something like Libre office or Open ...
- 355
2
votes
1
answer
3k
views
Converting excel files to UTF-8 .TSV
Every week I have to convert 25 or more Excel files to UTF-8 .tsv files. As of now I'm doing it using Editplus application manually.
I was searching Google and other sites where I'm getting UTF-8 ....
- 151
0
votes
0
answers
649
views
How to change a file's encoding?
I am not sure if the question is the right one for my situation, but here is what I want to do:
I've downloaded a .csv file with Chinese characters in it. When opened with MS Excel, the Chinese ...
- 581
0
votes
2
answers
5k
views
Exporting from Excel to CSV replaces Japanese characters with ??? even though Windows, Office locale is Japan/Japanese
I am exporting an excel file (Excel 2016) containing Japanese characters into CSV. (Note : I am not exporting to CSV UTF-8 provided). In the process, all Japanese characters are replaced with '?'
My ...
- 11
18
votes
1
answer
42k
views
Excel save behaviour of CSV file with UTF8 encoding vs UTF8-Bom encoding
My original csv files are encoded with UTF8-BOM, this is so Excel can recognise the Unicode charcters (If its just encoded with UTF8 then Excel does not recognise the unicode characters).
My issue ...
- 283
2
votes
1
answer
18k
views
Default character encoding for Excel Text Wizard?
A large part of my job is to run an SQL query, save the results as a UFT-8 encoded csv file then import it into Excel for further manipulation and distribution.
When I import the csv file into Excel ...
- 21
0
votes
2
answers
51
views
Excel incompatible with itself
So I have a csv I created with excel in this format:
col1;col2;col5
a;b;c
d;e;f
I want to change it to the more usual " and , how can I do that as of now every change either changes the encoding or ...
- 446
2
votes
2
answers
13k
views
UTF-8 File is not showing Chinese characters in Excel
I am creating a CSV file with UTF-8 encoding.
It displays the Chinese characters properly if I open it using Notepad++.
It displays the Chinese characters properly if I open it using Notepad.
But, ...
- 171
3
votes
1
answer
7k
views
CSV files cant store special characters?
I have read several other questions on this subject but none have an answer which fixes my problem.
I have an execel file which is in russian and I need to convert it to CSV without it losing any of ...
- 343