Share via

excel saves csv utf 8 as unicode text automatically

Anonymous
2018-06-07T19:16:42+00:00

excel saves csv utf 8 as unicode text automatically!

how do I make excel to save csv utf 8 automatic without need to go and fix from unicode text back to csv utf 8?????

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

Answer accepted by question author

Anonymous
2018-06-12T13:15:20+00:00

Hi Yael,

Based on the version you provided, you should be on the Monthly channel. When we tested this on the Monthly (Targeted) channel, we could not reproduce the issue anymore. This usually means that the issue is fixed, and all that is left to do is wait for other channels to get this build.

If you would like to get this update faster or test it out, you can follow the following article below to change your channel to Monthly (Targeted):

How to ‘Switch Channels’ for Office 2016 ProPlus

Afterwards, you can double-check whether your channel has been successfully changed via File > Account.

Regards,

Sheen

Was this answer helpful?

0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-06-08T05:11:15+00:00

    Thanks Sheen but this still doesn't solve my issue.

    The issue is that once I saved a file as CSV UTF 8, I want it to be the file type every time I open the file for editing.

    Right now, every time I open the same file if I don't go to the save as and change back to CSV utf 8, by default it will be saved as Unicode text. Unicode text is ruining my data and I am loosing the file. I don't want to remember to go to so save as every time. I work with these types of excels all the time.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-06-08T09:05:57+00:00

    I couldn't attached files here. where do you want me to put the images and the example file?

    Also my product name is Microsoft Office 365 business and the Version is 1805 (build 9330.2087)

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-06-08T08:54:20+00:00

    Hi Yael,

    Thank you for the explanation. I would like to collect a simple sample file with some data to see if I can save it as UTF-8. Can you please provide one file using dummy data and share it with us? Please also provide a screenshot of the data before and after you save it on Excel (we would like to see how the data is ruined).

    We would also like to collect your Office version and product name, which you can find via the article below:

    About Office: What version of Office am I using?

    Regards,

    Sheen

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-06-08T02:04:34+00:00

    Hi Yael,

    When saving a CSV file, you can specify the encoding by going to Save As> Browse> Save as type: CSV > Tools> Web Options > Encoding: UTF-8, as referred to the picture below:

    Regards,

    Sheen

    Was this answer helpful?

    0 comments