WatchGuard’s Threat Lab is a group of dedicated threat researchers committed to helping you stay ahead of the bad guys by providing in-depth analysis of the top security threats to your network. Check out our latest Quarterly Internet Security Report!
Solved
Language appearing as ? in excel csv
Posted on 2016-08-31
Hey All,
I was trying to save an excel document with other language information(Eg, French etc), and saved it as a .csv file.
When I try to reopen the file, the place where I have used different language , appears as a '?'? Why do you suppose this is happening?
Regards,
T
I was trying to save an excel document with other language information(Eg, French etc), and saved it as a .csv file.
When I try to reopen the file, the place where I have used different language , appears as a '?'? Why do you suppose this is happening?
Regards,
T
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
3-
2
8 Comments
Active today
You've probably saved it as "CSV (MS-DOS) (*.csv)", which uses Code page 437.
Use "CSV (Comma delimited) (*.csv)" instead, which uses ISO 8859-1 (a few lines above - the entries are not ordered by name).
Use "CSV (Comma delimited) (*.csv)" instead, which uses ISO 8859-1 (a few lines above - the entries are not ordered by name).
Active 1 day ago
Hi oBdA!
How do I check for .csv which used Code page 437 ?
I tried saving the file as CSV (Comma delimited), but gave the same result..
Hi xtermie!
Where do I see the option for UTF-8?
Thanks in advance,
T
How do I check for .csv which used Code page 437 ?
I tried saving the file as CSV (Comma delimited), but gave the same result..
Hi xtermie!
Where do I see the option for UTF-8?
Thanks in advance,
T
Active today
You can't check this; the file is saved as a bunch of bytes, and the code page determines which meaning (that is, which character) the bytes >127 represent. csv is a plain text file, so there's no meta data stored which code page was used when saving.
When you want to save this csv, always use "Save As", make sure the correct format is selected, and overwrite the original file. Do not use "Save", this will default to "CSV (MS-DOS) (*.csv)", even if you had it already saved as "CSV (Comma delimited) (*.csv)".
I tested with some French characters ("_éâè_"), and it worked just fine when using "Save as" and reopening.
Hex dump when saved as "CSV (Comma delimited) (*.csv)":
HxD - Freeware Hex Editor and Disk Editor
https://mh-nexus.de/en/hxd/
When you want to save this csv, always use "Save As", make sure the correct format is selected, and overwrite the original file. Do not use "Save", this will default to "CSV (MS-DOS) (*.csv)", even if you had it already saved as "CSV (Comma delimited) (*.csv)".
I tested with some French characters ("_éâè_"), and it worked just fine when using "Save as" and reopening.
Hex dump when saved as "CSV (Comma delimited) (*.csv)":
5F E9 E2 E8 5F 0D 0A _éâè_..
5F 82 83 8A 5F 0D 0A _‚ƒŠ_..
HxD - Freeware Hex Editor and Disk Editor
https://mh-nexus.de/en/hxd/
Active 1 day ago
Hey Thanks oBdA and xtermie!
I actually have a requirement for saving the file in a csv format for using it elsewhere, that's why..
I am not having any luck saving the file as CSV delimited, and currently clueless on how to go about this actually. Do you guys suppose, I need a language interface pack as mentioned below: ?
http://www.ehow.com/how_5736884_change-language-microsoft-excel.html
Regards,
T
I actually have a requirement for saving the file in a csv format for using it elsewhere, that's why..
I am not having any luck saving the file as CSV delimited, and currently clueless on how to go about this actually. Do you guys suppose, I need a language interface pack as mentioned below: ?
http://www.ehow.com/how_5736884_change-language-microsoft-excel.html
Regards,
T
Active today
This is a limitation of the file format; interface languages for Excel won't change anything.
"I am not having any luck saving the file as CSV delimited" is not a helpful statement for troubleshooting.
Have you compared hexdumps when saved as "CSV (MS-DOS) (*.csv)" and "CSV (Comma delimited) (*.csv)", and if so, what were the exact results?
Does the "Text Import Wizard" pop up when you open the saved file? If not, you saved it as DOS csv.
Did you follow my advice about using "Save as" only, and absolutely no other "Save" dialog at all?
1. Create a test sheet with some French characters.
2. Go to "File > Save as", change the "Save as type:" dropdown box to "CSV (Comma delimited) (*.csv)", save as C:\Temp\Book1.csv.
3. Click "Save", click "OK" on the "The selected file type does not support workbooks that contain multiple sheets" dialog, click "Yes" on the "Book1.csv may contain features that are not compatible with csv ..." dialog.
4. Close the workbook, clicking Don't Save!
5. Open the file again, follow the "Text Import Wizard", and the French characters should show up correctly.
Finally, note that the "correct" way to save the file is determined by "elsewhere", not by being able to reopen it in Excel. "Elsewhere" decides which encoding it will use to open the file.
Other options for import/export:
Import or export text (.txt or .csv) files
https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
"I am not having any luck saving the file as CSV delimited" is not a helpful statement for troubleshooting.
Have you compared hexdumps when saved as "CSV (MS-DOS) (*.csv)" and "CSV (Comma delimited) (*.csv)", and if so, what were the exact results?
Does the "Text Import Wizard" pop up when you open the saved file? If not, you saved it as DOS csv.
Did you follow my advice about using "Save as" only, and absolutely no other "Save" dialog at all?
1. Create a test sheet with some French characters.
2. Go to "File > Save as", change the "Save as type:" dropdown box to "CSV (Comma delimited) (*.csv)", save as C:\Temp\Book1.csv.
3. Click "Save", click "OK" on the "The selected file type does not support workbooks that contain multiple sheets" dialog, click "Yes" on the "Book1.csv may contain features that are not compatible with csv ..." dialog.
4. Close the workbook, clicking Don't Save!
5. Open the file again, follow the "Text Import Wizard", and the French characters should show up correctly.
Finally, note that the "correct" way to save the file is determined by "elsewhere", not by being able to reopen it in Excel. "Elsewhere" decides which encoding it will use to open the file.
Other options for import/export:
Import or export text (.txt or .csv) files
https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
Featured Post
If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month15 days, 2 hours left to enroll
649 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.