Open an Access file without Access
Drop an .accdb or .mdb file. You see every table
and its first rows, and you can download any table as a CSV that opens in Excel, Numbers
or Google Sheets. Free, no signup, and it works on a Mac.
Your file is read once to answer you and is not kept: nothing is saved, and nobody sees it. Each download sends the file again and gets one table back.
What comes out, and what does not
- Every table that holds rows, with every row. Text, numbers, money, dates, yes/no and long text all come across as Access shows them.
- Pictures, attachments and OLE objects stored inside the file do not. Those columns are left out, and the page names them under the table.
- Forms, reports, queries, macros and VBA do not either. They are not data, so there is nothing to put in a CSV. You get the records.
- Two kinds of file are refused, in plain words: a database with a password, and Access 97 or older. If you still have Access, export those tables from it (right-click the table, Export, Excel or Text File).
Why your Mac will not open an .accdb
Microsoft Access has only ever been made for Windows. There is no Mac version, and
Office for Mac does not include it. Excel on a Mac cannot read an Access file either.
So an .accdb someone emails you, or one left on a shared drive by a person
who has gone, is a closed box on a Mac. This page reads the file itself, so the box
opens in any browser: Mac, Windows without Access, Linux or a Chromebook.
The other ways, so you can pick: on Windows, a paid viewer such as MDB Viewer Plus;
on a Mac or Linux, the free mdbtools command-line programs, if you are
happy in a terminal; or LibreOffice Base with an extra driver, which takes some setting
up. If you only need the rows out, this page is the quickest of them.
If the file is still in use
Often the CSV is not the end of it. The Access file was somebody's whole system, and people still need to add to it, from more than one place, maybe on a phone. Press Keep it as an app on any table above and we build a working app from that table: a list, a form to add and edit, search, and room to add the other tables. You see it before you sign up for anything. That is what Bionic Forms is, and why this page exists: we make it, we would like you to try it, and the CSV download is yours either way.
Want to see the finished thing first? Open the live demo database, no account and no email. Or tell us what your Access database does and we will build a working version and show you, at no charge.
Leaving Access for good? What replacing Access looks like, what an Access export leaves behind, and the alternatives compared, with prices.
Being plain about what this is: a read-only reader we wrote and tested against files made by Microsoft's own database engine. It never changes your file. It is new, so if a table looks wrong, the help button at the bottom right reaches a person.