MDB and ACCDB to Excel
A common request: "here is the database from an old program, I need the table in Excel." You need neither Access nor a converter — just open the database in the browser and export the table you want.
Free for personal use. The database is not uploaded to a server — everything happens in the browser. Windows version — 3.5 MB, no installation: details. Organizations: license.
Step by step
- Drag the .mdb or .accdb file into the app window. The largest table of the database opens.
- If you need a different one, pick it in the file parsing panel, where every table shows its row count.
- If you do not need every row, narrow them down with a filter: the export takes exactly what is on screen.
- Export → Excel, CSV, DBF, JSON or SQL.
The whole database in one workbook
In the file parsing panel click Open all tables as tabs, then in the Excel export dialog choose the option to export all open tabs: you get one workbook with a sheet per table.
If you need to keep working with the data, export the tables to SQLite: almost any program opens that format, and here it supports editing and SQL queries.
What happens to types
- Dates land in Excel as dates. A column where every value has the time 00:00 is shown as a date without a time.
- Currency is stored in Access as an integer number of ten-thousandths — no cents are lost.
- Yes/No fields are shown as a tick box and arrive in Excel as TRUE/FALSE.
- Memo (long text) is exported in full.
- OLE object fields — pictures and documents stored inside the database — appear in the export as a marker with the size.
If you have more than a million rows
An Excel sheet is limited to 1,048,576 rows. Export a large table to CSV or SQLite, which have no such limit — or split it into parts by a column with the Split into files tool.
FAQ
Can I export the result of an Access query?
The query itself is not executed: it is text in the Access query language. But selection, totals and a pivot table are done with filters and grouping over the table, and the result is exported as usual.
Will leading zeros in codes be kept?
Yes: a text field stays text in Excel too.
Do I need Excel installed?
No. The .xlsx file is built in the browser; you can open it in Excel, LibreOffice or Google Sheets.
Free for personal use. Your file is not uploaded to a server. Windows version — 3.5 MB, no installation: details. Organizations: license.