# How to Export Data from MS Access to Excel

> To export data to Excel, open your Access database, select the table or query in the Navigation Pane, and go to the External Data tab on the Ribbon. Click Excel, specify the file location and name, choose formatting and layout options, and click OK to complete the export process.

Canonical: https://livedemo.ai/tutorials/how-to-export-data-from-ms-access-to-excel/
Apps: Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3db5ab56e05a00fe557b/preview?step=1

## Steps

1. Open your Access database and ensure the table, query, or form you want to export is available.
2. In the 'Navigation Pane', click on the table or query you want to export.
3. Click on the 'External Data' tab on the Ribbon.
4. In the 'Export' group, click 'Excel'.
5. In the 'Export - Excel Spreadsheet' dialog box, Specify the location and file name for the Excel file.
6. Check 'Export data with formatting and layout' if required. Choose whether to open the file after exporting by checking 'Open the destination file after the export operation is complete'.
7. Click 'OK' to start the export process.
8. If you selected 'Save Export Steps', you can name and save the settings for future use.
9. Click 'Save Export'.
10. Open the exported Excel file to ensure the data was exported correctly.