Configuration to encode CSV file to UTF-8, be able to open in Excel with multiple columns

Symptom： 

Before Strategy 2021 update 10, exported CSV files from Library can’t be opened correctly in Microsoft Excel. All of the data appears in a single column, instead separate columns by comma.  
 

CAUSE: 

 
By default, exported CSV file by Strategy is encoded in UTF-16. However, Excel software is only able to recognize the CSV content when CSV is encoded in UTF-8. When opening a CSV file using Microsoft Excel, Excel will automatically separate columns by a comma if the CSV file is UTF-8 encoded. So when opening the UTF-16 encoded CSV file with Excel, Excel will display all columns into one cell. 
 

Workaround： 

Provide the workaround to encode CSV to UTF-8 when exporting visualization to CSV.  
For Strategy Web: 
 

• Open the folder <WebContainer>/webapps/MicroStrategy/WEB-INF/xml/ 
  
• Edit the file locales.xml 
  
• Change the specific locale's attribute char-set-excel into "UTF-8" or "unicode-1-1-utf-8" or "UTF8" 
  
• Restart Web Server.  
  

For Library: 
 

• Open the folder <WebContainer>/webapps/StrategyLibrary/WEB-INF/xml/ 
  
• Edit the file locales.xml 
  
• Change the specific locale's attribute char-set-excel into "UTF-8" or "unicode-1-1-utf-8" or "UTF8" 
  
• Restart Library Server.