What is the difference between Excel Spreadsheet & Excel File during export?
Apply OS: Windows
Apply Navicat Product: All
Apply Navicat Version No.: All
If you are trying to export multiple tables into one excel file, then you should export your tables using "Excel File". For "Excel Spreadsheet", you can only export one table, i.e. one single sheet in the file.
Also, you should export your tables 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.