How to save spreadsheet as UTF-16 CSV on Mac OS using MS Excel?

Copper Contributor

I'm trying to save an excel spreadsheet as a UTF-16 Comma Separated Values spreadsheet because the system I'm working with requires it when working from Mac OS, however, from the list of options in the "File Format" drop down - I'm do not see an option for UTF-16 anywhere so how do I save it in this format?

3 Replies

Just wanted to clarify that the .txt save format option is not going to work for our application.  It needs to be CSV: CSV UTF-16 (Comma delimited) (.csv)

JPFMC_0-1624457645080.png

 

I've tried to follow the instructions in the link below, but I'm not seeing a way to get into the "options" within the "Save As" window:

Instructions: https://help.alchemer.com/help/encode-an-excel-file-to-utf-8-or-utf-16

What I see instead (I can't enter anything or check the checkbox - not sure what the point of this is):

JPFMC_0-1624459174167.png

 


 

Hi, I am having the same problem. I cannot see where to save as .csv with utf-16... I have Microsoft Office 2021 Mac.