What is the difference between Excel Spreadsheet & Excel File during export?
Apply OS: Windows
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat for SQLite, Navicat for MongoDB, Navicat Premium
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.