Excel Export Formats FAQ
What is the Excel Internet Query Export Option?
This option exports a file that you can open in MS Excel. Unlike other exports, it is does not contain the data (initially), but creates an internet connection to the plugin page to extract the data. The data can be refreshed from directly within Excel so there is no need to do an export every time there is new data.
What are the differences among Excel CSV (UTF8-BOM), Excel TSV (UTF16LE-BOM) and Plain CSV (UTF8) Export files?
- For any non-Excel spreadsheet application, use ‘Plain CSV (UTF8)’.
- For Excel, first try ‘Excel CSV (UTF8-BOM)’ and if that does not work property, try ‘Excel TSV (UTF16LE-BOM)’.
- Excel CSV (UTF8-BOM) is generally good for most Microsoft Excel installations. But in some cases Excel will not show non-western latin characters properly from UTF8-BOM file.
In that case, you can use Excel TSV (UTF16LE-BOM) but this format has a downside. The UTF16LE-BOM format cannot handle new lines inside of entries. Therefore the plugin converts new lines to spaces.
In other words, if you have a form with a text area where people enter multi-line input, the returns are converted to spaces in UTF16LE-BOM but are preserved in UTF8-BOM.