This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Using Excel 2016 I'm attempting to save a spreadsheet containing regular characters and Chinese characters as a CSV. The result is that the Chinese characters are rendered as question marks (ie 锡焊母端子 => ??????????). I'm familiar with the old trick of saving as a Unicode text file, opening in notepad, replacing the tabs with commas and saving. I've also tried saving it in various formats via the 'web options' and the results are always the same.
I need to be able to save it correctly as a CSV directly from excel. Is this possible?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This doesn't really solve the problem I think. Whoever opens the files next will also need Chiese as their non-unicode default. The problem is saving in Unicode format.
Paul
Hi,
We found a similar thread that has the troubleshooting steps that can resolve the issue. We suggest checking this link answered by MedicalS to resolve the character change issue on your Excel file.
Get back to us if you need further assistance.