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

%3CLINGO-SUB%20id%3D%22lingo-sub-2471944%22%20slang%3D%22en-US%22%3EHow%20to%20save%20spreadsheet%20as%20UTF-16%20CSV%20on%20Mac%20OS%20using%20MS%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2471944%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20save%20an%20excel%20spreadsheet%20as%20a%20UTF-16%20Comma%20Separated%20Values%20spreadsheet%20because%20the%20system%20I'm%20working%20with%20requires%20it%20when%20working%20from%20Mac%20OS%2C%20however%2C%20from%20the%20list%20of%20options%20in%20the%20%22File%20Format%22%20drop%20down%20-%20I'm%20do%20not%20see%20an%20option%20for%20UTF-16%20anywhere%20so%20how%20do%20I%20save%20it%20in%20this%20format%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2471944%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2475353%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20save%20spreadsheet%20as%20UTF-16%20CSV%20on%20Mac%20OS%20using%20MS%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2475353%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20wanted%20to%20clarify%20that%20the%20.txt%20save%20format%20option%20is%20not%20going%20to%20work%20for%20our%20application.%26nbsp%3B%20It%20needs%20to%20be%20CSV%3A%20%3CEM%3ECSV%20UTF-16%20(Comma%20delimited)%20(.csv)%3C%2FEM%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JPFMC_0-1624457645080.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290668iFF27F3C664327F2A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JPFMC_0-1624457645080.png%22%20alt%3D%22JPFMC_0-1624457645080.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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?

2 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