How to Import Microsoft Access ACCDB Data into Excel for Mac
Question details
Users need to connect to or import data from a Microsoft Access database (.accdb) into an Excel spreadsheet on a Mac, but are unable to find the native import tool.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Attempting to pull database records from an ACCDB file directly into an Excel workbook on an Apple Mac device.
- Observed behavior
- Excel for Mac lacks the built-in Microsoft Access database import functionality that is standard in the Windows version, preventing users from natively opening or querying ACCDB files.
Determine whether you need a live, automatically updating connection to the database or just a one-time snapshot of the data, as this will dictate whether you need to install drivers or simply convert the file.
Use a Third-Party ODBC Driver
Install a specialized ODBC driver to bridge the gap and allow Excel for Mac to communicate directly with an Access database.
Because Microsoft Access does not have a Mac equivalent, the required drivers are not pre-installed on macOS. Utilizing a third-party ODBC driver (such as Actual Technologies) allows you to establish a live data connection.
Purchase and download a Mac-compatible third-party Access ODBC driver from a reliable provider like Actual Technologies.
Install the driver and open the ODBC Manager utility on your Mac. Add a new System DSN (Data Source Name) and configure it to point to your target ACCDB file.
Open Excel for Mac, navigate to the 'Data' tab, select 'New Database Query', and choose 'From Database'.
Select the DSN you just created. Follow the Microsoft Query prompts to select the specific tables and fields you want to import into your spreadsheet.

Export the Data as XLSX or CSV from Windows
The easiest workaround if you only need the data once and do not require live syncing with the database.
Run Excel for Windows on Mac via Virtual Machine
Install a Windows virtual machine on your Mac to run the native Windows version of Microsoft Office.
Experience Seamless Spreadsheet Management with WPS Office
While establishing Mac-to-Access connections requires advanced workarounds, analyzing and managing exported database files is effortless with WPS Office. As a lightweight and free alternative to Microsoft Office, WPS offers exceptional compatibility and performance on macOS.
- 1. Download for Mac: Visit the official WPS Office website and download the installation package designed for macOS.
- 2. Install and Launch: Follow the simple on-screen instructions to install the application, then launch WPS Spreadsheets.
- 3. Open Your Data: Drag and drop your exported CSV or XLSX files into WPS Spreadsheets to view, edit, and analyze your database records instantly.

Frequently Asked Questions
Why doesn't Excel for Mac have a built-in Access database import feature?
Microsoft Access is a Windows-only application. The native driver dependencies and database engines required to read ACCDB files are not built into the macOS environment, so Microsoft cannot offer the same one-click import feature on Mac.
Can I open an ACCDB file natively on a Mac?
No, macOS cannot natively open ACCDB files. You must use a third-party application, configure a specialized ODBC driver for Excel, or run a virtual machine equipped with Windows and Microsoft Access.
Is there a free ODBC driver available to connect Excel for Mac to Access?
Most reliable ODBC drivers for Mac-to-Access connectivity require a paid license. Providers often offer free trial versions, but these typically restrict the number of rows you can import per query.
What is the fastest way to view Access data on my Mac without buying software?
The fastest, cost-free workaround is to ask the person providing the ACCDB file to export the specific tables or queries you need as CSV or XLSX files. You can then open those files directly on your Mac without any extra software.




