Impossible XLSX to CSV conversion with Cyrillic names. Can you help?

[stamenski]

Hello All,
I have the following sample below that contains ONLY 3 names with addresses, emails and phones.
When I save as CSV, I get "????" or "________" where the Cyrillic names and addresses are.
File must be in CSV in order to upload to CRM. I tried this on a mac for several days. Loosing my mind here.

My question is can you and how do you save this in Excel and then convert to CSV so that the names show and is no gibberish?

Name

Surname

Family

Region

PostCode

City

Address

Company

Phone

Fax

GSM

Email

Bulstat

Ива

Иванова

Велева

София

1000

София

ул.Георги Бенковски №7, ет.3

Ива Иванова Велева

02/4001600

02/9882522

office@yankov.com

1300443310

Калоян

Милков

Янков

София

1000

София

ул.Георги Бенковски №7, ет.3

Калоян Милков Янков

02/4001600

02/9882522

yan@yankov.com

1200416810

Валентина

Драйчева

Бакалова

София

1000

София

ул.Екзарх Йосиф №15, ет.3, офис.7

Валентина Драйчева Бакалова

02/4006384

02/4006386

valentina_bakalova@abv.bg

1800316810

<colgroup><col span="12"><col></colgroup><tbody>
</tbody>

 

[MartyS]

I don't think Excel will export Cyrillic to CSV.

However, there is an easy way around this.

Make sure there is only the one worksheet.
Save it as Unicode Text (*.txt)

Once saved, open the text file you've just created in NOTEPAD (or similar text editor if on a mac)
You'll see the data saved with TABS separating each field.
Highlight one TAB (which looks like you've highlighted around 4 blank spaces)
Copy the TAB character

Make sure you're at the beginning of the text file (Ctrl + HOME usually works)
Use FIND & REPLACE function

in FIND: use CTRL+V to PASTE the TAB character

In REPLACE: enter a COMMA

Run the FIND-REPLACE function for ALL instances.

Save the text file

Find the text file using explorer (or whatever you use in your operating system)

Rename the extension from .TXT to .CSV


You should now have a .CSV (comma separated variables file) with Cyrillic data in it!


https://www.dropbox.com/s/o3yrp2yfapevq62/CSVTestDone.csv?dl=0

Hope that helps?

 

[thisoldman]

Try saving as CSV UTF-8.

Using the File > Save As dialog, when I save as CSV UTF-8 (Comma delimited) (*.csv) the Cyrillic characters are preserved.
When I save as CSV (Comma delimited) (*.csv), or as CSV (MS-DOS) (*.csv), or as CSV (Macintosh) (*.csv), the Cyrillic characters are lost.