All Questions
8
questions
0
votes
0
answers
214
views
Managing utf8 CSV on Mac
I use Excel on macOS and when I try to combine CSV files downloaded from SaaS platforms, it messes things up on the first lines. I don't have this problem when using Excel with Windows.
For now, I ...
2
votes
0
answers
872
views
Loading UTF8 CSV files generated on a Mac into Excel on Windows: does not recognize encoding
When I generate a UTF8 CSV file in Excel (or some other way) on Windows and then open it n Excel, I expect it to ask me to choose the right encoding.
I got a UTF8 CSV file that was generated on a Mac. ...
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 ....
1
vote
2
answers
4k
views
Russian UTF-8 tab delimited csv file saved from Excel 2016 is garbage in text editor
There is an option in Excel 2016 to export as a UTF-8 comma delimited CSV file. I don't want commas between fields- i want tabs.
I save the file as a tab-delimited txt file. In the Save As ...
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 ...
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, ...
1
vote
1
answer
12k
views
How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X
I have a CSV file which I can open and view the column with Chinese letters normally with TextMate.
However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. ...
1
vote
1
answer
369
views
My computer isn't loading my massive Excel file…are there any tricks?
I have an 11,000 row Excel file (in Japanese) that I have saved as an xlsx file. I need it to be saved in UTF-8 format, so I went in and tested a few rows in OpenOffice (the reason for this apparent ...