How to Export from Access to Excel

Posted on by Ian

To export from Access 2013 or 2016 to Excel:

  1. Open the table or query that contains the data you want to export
  2. Click the Excel download icon (from the EXTERNAL DATA tab on the Ribbon)
  3. Click OK to save the file at the default location. Alternatively, change the location and/or a file name. Select any other options you wish to include under Specify export options
  4. Click Close

Below are screenshots for the above steps.

Open the Query

Open the table or query that contains the data you want to export

The Excel Download Icon

Click the Excel download icon (from the EXTERNAL DATA tab on the Ribbon):

Screenshot of the Excel export button in Access 2013.
The Export to Excel button on the Ribbon.

Export the File

Click OK to save the file at the default location. Alternatively, change the location and/or a file name. Select any other options you wish to include under Specify export options:

Screenshot of the Excel export dialog in Access 2013.
The export to Excel dialog. You can specify a location for the exported file and set other options here.

Close the Export Dialog

Click Close. Alternatively, you could select Save Export Steps before clicking Close.

Other File Formats

You can also export to other file types such as XML, text file, and PDF documents.