In-Portal has feature, that allows to export all visible data from the grid into CSV file. This can be used for reporting purposes or just for quickly updating multiple records and then import that data back.

Exported CSV file is specially patched, the way, that allows it to be opened in Microsoft Excel without a problems (see how many issues there can be http://www.paessler.com/knowledgebase/en/topic/2293-i-have-trouble-opening-csv-files-with-microsoft-excel-is-there-a-quick-way-to-fix-this). However latest Excel versions doesn't seem to like UTF16-LE encoding at all, that worked pretty well at time, when this feature was developed.

To make it work again I'm forced to set "Default CSV Export Encoding" setting in "Configuration -> Website -> Advanced" section to "Regular" (instead of "Unicode") on each project we're using it in. The downside of such approach is, that if data in the grid is entered in 2 different languages, then all non-latin symbols will be encoded incorrectly.

If problem is only with encoding, then we need to add more encoding options (e.g. add UTF-8). This way administrator can choose whatever encoding is best for majority of website users, who are downloading CSV files.

Browser not supported