Export data from a database table using Navicat for MySQL

Procedure

1. Start Navicat for MySQL.

2. In the left-side navigation pane, right-click the database table that you want to export and select Export Wizard.

3. In the Export Wizard dialog box, under Table type, select Excel File (2007 or later) (*.xlsx) and click Next.

   The Table type section in the Export Wizard dialog box lists several file formats, including Paradox File, DBase File, HTML File, Excel File, Word File, SQL Script File, XML File, and Lotus 1-2-3 File.

4. Select the table to export, and in the Export column, set the local save path for the exported table.

   In the Source column, select the checkbox for your target table. In the Export to column for the same row, click the ... button to choose a local path and enter a file name.

5. Specify which columns to include in the export.

   The Source table drop-down list shows the table that you are exporting. Below this, the Available fields list contains all columns in the table. To the right are the Select All and Deselect All buttons, and the All fields checkbox.

   Do one of the following:

   • To export all columns: The All fields checkbox is selected by default. Click Next.

   • To export specific columns:

     1. Deselect the All fields checkbox.

     2. From the Available fields list, select the columns that you want to export.

   This example proceeds with exporting all columns.

6. Configure additional options as needed, then click Next.

   Note

   We recommend selecting Include column headers so that the exported Excel file includes the column titles.

7. Click Start.