Cyrillic export from Excel to CSV
I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document.
I use Save As » CSV in order to make a CSV file, but it is not going to save the cyrillic values, instead the text looks like question marks (the system does not let me paste a lot of question marks here).
How do I export it correctly?
microsoft-excel export unicode csv character-encoding
add a comment |
I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document.
I use Save As » CSV in order to make a CSV file, but it is not going to save the cyrillic values, instead the text looks like question marks (the system does not let me paste a lot of question marks here).
How do I export it correctly?
microsoft-excel export unicode csv character-encoding
What version of excel?
– Raystafarian
Feb 19 '12 at 3:49
Microsoft Excel 2010
– Mike
Feb 19 '12 at 19:31
add a comment |
I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document.
I use Save As » CSV in order to make a CSV file, but it is not going to save the cyrillic values, instead the text looks like question marks (the system does not let me paste a lot of question marks here).
How do I export it correctly?
microsoft-excel export unicode csv character-encoding
I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document.
I use Save As » CSV in order to make a CSV file, but it is not going to save the cyrillic values, instead the text looks like question marks (the system does not let me paste a lot of question marks here).
How do I export it correctly?
microsoft-excel export unicode csv character-encoding
microsoft-excel export unicode csv character-encoding
edited Feb 18 '12 at 14:50
slhck
160k47444466
160k47444466
asked Feb 18 '12 at 14:03
MikeMike
109118
109118
What version of excel?
– Raystafarian
Feb 19 '12 at 3:49
Microsoft Excel 2010
– Mike
Feb 19 '12 at 19:31
add a comment |
What version of excel?
– Raystafarian
Feb 19 '12 at 3:49
Microsoft Excel 2010
– Mike
Feb 19 '12 at 19:31
What version of excel?
– Raystafarian
Feb 19 '12 at 3:49
What version of excel?
– Raystafarian
Feb 19 '12 at 3:49
Microsoft Excel 2010
– Mike
Feb 19 '12 at 19:31
Microsoft Excel 2010
– Mike
Feb 19 '12 at 19:31
add a comment |
3 Answers
3
active
oldest
votes
In this question, you will find Excel indeed does not preserve unicode characters when saving as csv. Their solution is to save as unicode tab separated text
To save with Unicode encoding in Excel,
Save as, choose text, then next to the save button, you see "tools" menu.
Choose web options,
then encoding tab,
then select the encoding you like.
I would suggest to save everything in UTF8, but that is your choice.
Note this is in Excel 2007 or above.
add a comment |
Excel does not support Unicode encoding when saving as CSV. You can copy your table to a program that does (e.g. Google Sheets) and then export it to CSV in that program.
add a comment |
do you use correct encoding? I use Libreoffice Calc and there you have to specify output encoding for the CSV or DBF file (and there should be something similar also in Excel). I used this also with some Japanese datasets and it looked OK. I assume that you should use UTF-8 in your case.
Actually my Excel is saving CSV in ANSI and not UTF8 or Unicode and I do not know how can I change that.
– Mike
Feb 18 '12 at 15:09
I also checked this but with no result superuser.com/questions/170926/…
– Mike
Feb 18 '12 at 15:11
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f391360%2fcyrillic-export-from-excel-to-csv%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
In this question, you will find Excel indeed does not preserve unicode characters when saving as csv. Their solution is to save as unicode tab separated text
To save with Unicode encoding in Excel,
Save as, choose text, then next to the save button, you see "tools" menu.
Choose web options,
then encoding tab,
then select the encoding you like.
I would suggest to save everything in UTF8, but that is your choice.
Note this is in Excel 2007 or above.
add a comment |
In this question, you will find Excel indeed does not preserve unicode characters when saving as csv. Their solution is to save as unicode tab separated text
To save with Unicode encoding in Excel,
Save as, choose text, then next to the save button, you see "tools" menu.
Choose web options,
then encoding tab,
then select the encoding you like.
I would suggest to save everything in UTF8, but that is your choice.
Note this is in Excel 2007 or above.
add a comment |
In this question, you will find Excel indeed does not preserve unicode characters when saving as csv. Their solution is to save as unicode tab separated text
To save with Unicode encoding in Excel,
Save as, choose text, then next to the save button, you see "tools" menu.
Choose web options,
then encoding tab,
then select the encoding you like.
I would suggest to save everything in UTF8, but that is your choice.
Note this is in Excel 2007 or above.
In this question, you will find Excel indeed does not preserve unicode characters when saving as csv. Their solution is to save as unicode tab separated text
To save with Unicode encoding in Excel,
Save as, choose text, then next to the save button, you see "tools" menu.
Choose web options,
then encoding tab,
then select the encoding you like.
I would suggest to save everything in UTF8, but that is your choice.
Note this is in Excel 2007 or above.
edited Mar 20 '17 at 10:04
Community♦
1
1
answered Jul 10 '14 at 18:34
vinniefvinnief
461311
461311
add a comment |
add a comment |
Excel does not support Unicode encoding when saving as CSV. You can copy your table to a program that does (e.g. Google Sheets) and then export it to CSV in that program.
add a comment |
Excel does not support Unicode encoding when saving as CSV. You can copy your table to a program that does (e.g. Google Sheets) and then export it to CSV in that program.
add a comment |
Excel does not support Unicode encoding when saving as CSV. You can copy your table to a program that does (e.g. Google Sheets) and then export it to CSV in that program.
Excel does not support Unicode encoding when saving as CSV. You can copy your table to a program that does (e.g. Google Sheets) and then export it to CSV in that program.
edited Dec 18 '18 at 13:14
Glorfindel
1,37441220
1,37441220
answered Dec 18 '18 at 12:56
Gregor AžbeGregor Ažbe
113
113
add a comment |
add a comment |
do you use correct encoding? I use Libreoffice Calc and there you have to specify output encoding for the CSV or DBF file (and there should be something similar also in Excel). I used this also with some Japanese datasets and it looked OK. I assume that you should use UTF-8 in your case.
Actually my Excel is saving CSV in ANSI and not UTF8 or Unicode and I do not know how can I change that.
– Mike
Feb 18 '12 at 15:09
I also checked this but with no result superuser.com/questions/170926/…
– Mike
Feb 18 '12 at 15:11
add a comment |
do you use correct encoding? I use Libreoffice Calc and there you have to specify output encoding for the CSV or DBF file (and there should be something similar also in Excel). I used this also with some Japanese datasets and it looked OK. I assume that you should use UTF-8 in your case.
Actually my Excel is saving CSV in ANSI and not UTF8 or Unicode and I do not know how can I change that.
– Mike
Feb 18 '12 at 15:09
I also checked this but with no result superuser.com/questions/170926/…
– Mike
Feb 18 '12 at 15:11
add a comment |
do you use correct encoding? I use Libreoffice Calc and there you have to specify output encoding for the CSV or DBF file (and there should be something similar also in Excel). I used this also with some Japanese datasets and it looked OK. I assume that you should use UTF-8 in your case.
do you use correct encoding? I use Libreoffice Calc and there you have to specify output encoding for the CSV or DBF file (and there should be something similar also in Excel). I used this also with some Japanese datasets and it looked OK. I assume that you should use UTF-8 in your case.
answered Feb 18 '12 at 14:09
JuheleJuhele
2,08221222
2,08221222
Actually my Excel is saving CSV in ANSI and not UTF8 or Unicode and I do not know how can I change that.
– Mike
Feb 18 '12 at 15:09
I also checked this but with no result superuser.com/questions/170926/…
– Mike
Feb 18 '12 at 15:11
add a comment |
Actually my Excel is saving CSV in ANSI and not UTF8 or Unicode and I do not know how can I change that.
– Mike
Feb 18 '12 at 15:09
I also checked this but with no result superuser.com/questions/170926/…
– Mike
Feb 18 '12 at 15:11
Actually my Excel is saving CSV in ANSI and not UTF8 or Unicode and I do not know how can I change that.
– Mike
Feb 18 '12 at 15:09
Actually my Excel is saving CSV in ANSI and not UTF8 or Unicode and I do not know how can I change that.
– Mike
Feb 18 '12 at 15:09
I also checked this but with no result superuser.com/questions/170926/…
– Mike
Feb 18 '12 at 15:11
I also checked this but with no result superuser.com/questions/170926/…
– Mike
Feb 18 '12 at 15:11
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f391360%2fcyrillic-export-from-excel-to-csv%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What version of excel?
– Raystafarian
Feb 19 '12 at 3:49
Microsoft Excel 2010
– Mike
Feb 19 '12 at 19:31