Apply OS: Windows

Apply Navicat Product: All

Apply Navicat Version No.: All

 

If you are trying to export multiple tables / collections into one excel file, then you should export to "Excel File". For "Excel Spreadsheet", you can only export one table / collection, i.e. one single sheet in the file.

Also, you should export your tables / collections to "Excel File" if the data more than 255 chars in a cell. If you export to "Excel Spreadsheet", data will be truncated while more than 255 chars in a cell.

Have more questions?
Submit Ticket