Cyrillic export from Excel to CSV












2















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?










share|improve this question

























  • What version of excel?

    – Raystafarian
    Feb 19 '12 at 3:49











  • Microsoft Excel 2010

    – Mike
    Feb 19 '12 at 19:31
















2















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?










share|improve this question

























  • What version of excel?

    – Raystafarian
    Feb 19 '12 at 3:49











  • Microsoft Excel 2010

    – Mike
    Feb 19 '12 at 19:31














2












2








2


1






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?










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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



















  • 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










3 Answers
3






active

oldest

votes


















1














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.






share|improve this answer

































    1














    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.






    share|improve this answer

































      0














      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.






      share|improve this answer
























      • 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











      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
      });


      }
      });














      draft saved

      draft discarded


















      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









      1














      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.






      share|improve this answer






























        1














        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.






        share|improve this answer




























          1












          1








          1







          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.






          share|improve this answer















          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.







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Mar 20 '17 at 10:04









          Community

          1




          1










          answered Jul 10 '14 at 18:34









          vinniefvinnief

          461311




          461311

























              1














              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.






              share|improve this answer






























                1














                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.






                share|improve this answer




























                  1












                  1








                  1







                  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.






                  share|improve this answer















                  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.







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  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























                      0














                      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.






                      share|improve this answer
























                      • 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
















                      0














                      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.






                      share|improve this answer
























                      • 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














                      0












                      0








                      0







                      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.






                      share|improve this answer













                      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.







                      share|improve this answer












                      share|improve this answer



                      share|improve this answer










                      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



















                      • 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


















                      draft saved

                      draft discarded




















































                      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.




                      draft saved


                      draft discarded














                      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





















































                      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







                      Popular posts from this blog

                      Сан-Квентин

                      Алькесар

                      Josef Freinademetz