I am trying to read kanji from a CSV file containing the RTK top 2 stories on MS Windows. Unfortunately, the kanji are not readable in Excel, although the stories, keyword, and numbers are fine. I have also tried reading them on with other software, MS Word, Open Office, etc....
I am using a Japanese Windows computer, and my Japanese reading ability is poor - and, that's the reason I started studying RTK. Well, any help would be appreciated. Thanks!
Start Excel on its own. Open the file you want to view now. It should give you an option screen with part of the file viewable. This probably varies from version to version on Excel but there is likely a combo list where you can tell excel what the file encoding is. Try stuff like SJIS, UTF-8, Unicode in the list and see if it works.
Alternatively try opening the CSV in notepad and if it opens and displays fine. Do Save As and save a new copy but tell it to use "Encoding: UTF-8."
Conversely the 1st part also works the same when you want to view something in Word that isn't showing proper encoding.
Vix, thanks for the advice, but unfortunately it didn't work. I am using the Japanese version of MS Windows 7.
The Excel method didn't work. Actually, I couldn't find the combo list. Instead, I tried the notepad option and changed the font, and that actually worked, but everything was jumbled together in a mess.
I wonder if there is a simple CSV reader available.
Try this. Start Excel. Do not double click the file to start it, so you should just have an empty document.
Go to the 'data' tab and click 'From Text' in the 'Get External Data'.
Select your CSV file and click 'Import'. Now you should see a rendition of the file. Click 'Delimited', then 'Next'.
Ensure that the 'Comma' Delimiter is the only one selected. Click 'Next'.
You should be able to work through each column, changing the properties if it does not display to your liking. When finished and opened, if it's as you want it, save as an Excel file so you won't have to go through this again.
If this doesn't work, can you specifically describe the earliest step at which things didn't go correctly? And what version of Excel you're using?