XLSX. Exports the data to an .XLSX file. Compatible with Excel 2013. Report charts are also displayed.
Excel CSV. Exports the data to a CSV file. This option provides backward compatibility for files prepared from/for Sage CRM prior to 7.1. It also renders well in Excel if your local settings support tab delimitation. The data in Excel CSV is always tab delimited and padded with =" ", regardless of local settings. For example:
Exported to a CSV file. The data is delimited according to the CSV File Export Delimiter set at system and user level. If you open the file in MS Excel, it may not be formatted correctly. You can open it in Notepad and use the CSV Excel option, or open in MS Excel and convert the formatting. For example, using the Text To Columns option.