Problem using cyrillic letters in excel to create CSV file.

T

Tip-C

New Member
Joined
Mar 2, 2009
Messages
4
Hello,

I need to create a CSV file to be able to upload large quantities of data to my website. However, one of the variables is written is Cyrillic (i.e. Russian, Ukrainian) letters. When i try to import the created CSV file after having entered all my data into excel, the information in that field is not recognized properly. All that happens is that a bunch of question marks appear in place of the letters. ????????? ???? ??????

I dont know what to do.

Please help,
Dennis
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Sort by date Sort by votes
Does the CSV show the letters properly? If so, then it is likely a problem with your database software or something other than Excel.
 
Upvote 0
Excel Shows the letters properly.

but when I save the file as a .csv and then try to open it with notepad I get ??? ??? ????? instead of letters. When i try to re-open the saved file again with excel, the cyrillic letters have been replaced by ??? ??? ?????? ??
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Getting Power Query data to an Excel worksheet
Replies
4
Views
245
MichaelMorris
M
A
  • Question
Need to repeat the first row in every csv file created
Replies
1
Views
176
rpaulson
rpaulson
P
  • Solved
Formatting csv file
Replies
6
Views
557
picklefactory
P
S
  • Solved
Import csv file and append to existing table?
Replies
5
Views
665
shellp
S
S
  • Question
Create Excel Packing Slips using CSV Data
Replies
4
Views
295
StaceyVECL
S

Forum statistics

Threads
1,215,391
Messages
6,124,673
Members
449,179
Latest member
fcarfagna

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top