Convert Access to CSV (.accdb, .mdb)

What you get

One standard CSV file per table: comma-separated, with the column names in the first row and UTF-8 text that Excel reads correctly.

• Lines end with CRLF and values follow RFC 4180, so fields with commas, quotes or line breaks are quoted properly.
• The file starts with a UTF-8 byte order mark, so Excel shows accented and non-Latin characters correctly.
• Download one table with the button above, or every table as a .zip with one CSV per table (Export, then All as CSV).
• Only tables are exported. Forms, reports, queries and macros are not.

Open the CSV in Excel, Google Sheets or Numbers

Double-click the file to open it in Excel or Numbers. For Google Sheets, use File, then Import, and upload the CSV.

In Excel, double-clicking works because of the byte order mark. If you would rather choose the options yourself, use Data, then From Text/CSV, and select UTF-8 as the file origin and comma as the delimiter.

Dates, numbers and special characters

Values are written as they are stored in the Access file, in a plain text form that most programs understand.

• Dates appear as YYYY-MM-DD, or YYYY-MM-DD hh:mm:ss when the value has a time. They use the value saved in the file, so your time zone does not shift them.
• Yes/No fields appear as TRUE or FALSE.
• Binary and OLE values cannot go into a CSV, so they become a label such as [binary data, 12 KB].
• Attachment fields become the names of the attached files.
• Text with commas, quotes or line breaks is quoted, so it stays in one cell.

Loading the CSV into a database or Python

The CSV is a normal comma-separated UTF-8 file, so the usual import commands work. Change the table and file names to your own.

PostgreSQL, from psql, with the table already created:

\copy assets FROM 'assets.csv' WITH (FORMAT csv, HEADER true, ENCODING 'UTF8')

MySQL:

LOAD DATA LOCAL INFILE 'assets.csv' INTO TABLE assets
CHARACTER SET utf8mb4
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

Python with pandas. The utf-8-sig encoding drops the byte order mark:

import pandas as pd
df = pd.read_csv("assets.csv", encoding="utf-8-sig")

Is it safe?

Yes. The conversion runs inside your browser tab, and your file is never uploaded. The site has no server that could receive it.

To check, open your browser's developer tools, go to the Network tab, and convert a file. You will not see it being sent anywhere. The privacy page has more detail. The Access database viewer guide covers opening and browsing files, and Access to Excel covers workbooks.