Why does the pound sign (UK currency) not appear correctly when using "writetable"?

When trying to use the "writetable" function to save a table in MATLAB to a .csv file, the pound sign (£), appears as (£) in Microsoft Excel. However, when viewing it in MATLAB, it appears normally, without the extra Â. How can a table with £ be saved correctly?

Answer 1

[MathWorks Support Team]

This is likely due to a difference in encoding. The default encoding for MATLAB is UTF-8, however for Excel it is likely different. You can change the encoding as an option during the "writetable" call. For example:

>> writetable(T,'myData.csv','Delimiter',',','QuoteStrings',true, 'Encoding', 'ISO-8859-1')