Skip to main content

All Questions

0 votes
0 answers
207 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 ...
Aymeric's user avatar
2 votes
0 answers
865 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. ...
I Z's user avatar
  • 489
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 ....
Linga's user avatar
  • 151
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 ...
Deersfeet's user avatar
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 ...
Donna A's user avatar
  • 21
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, ...
Techidiot's user avatar
  • 171
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. ...
cenk's user avatar
  • 113
1 vote
1 answer
368 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 ...
Jerry's user avatar
  • 13