Skip to content

Free online MDB to XLS converter

Convert Access MDB tables or queries to Excel 97–2003 XLS while checking data limits and field compatibility.

Convert MDB to XLS online - free

Uploading…

Your file is processed automatically and deleted right after you download the result, or after 3 hours at the latest.

How it works

  1. 1/3

    Upload your .mdb file

    Click to browse to select your file you want to convert or simply drag & drop your file into selected area.

  2. 2/3

    Perform .mdb to .xls conversion

    After successful file upload, click to convert when you are ready.

  3. 3/3

    Download converted .xls file

    Conversion result is ready to download.

Conversion statistics: MDB to XLS

9 in 10 conversions finish within 45 s.

Files converted
74
9 in 10 conversions take at most
45 s
Typical file size
1.2 MB
MDB files are most often converted to XLSX 28% ACCDB 24% XLS 12% DB 9%

Updated November 21, 2026, from conversions on 101convert.com

How to convert mdb to xls file

Older reporting systems, business applications, and hardware may require an Excel 97–2003 workbook instead of an Access database. Converting selected tables or query results to XLS makes the data easier to edit, share, and import into software that cannot read MDB files.

What the MDB format is

MDB is the Microsoft Access database format used by default through Access 2003 and still available as a compatibility format in some later Access versions. It can use the Jet or ACE database engine and store tables, relationships, queries, forms, reports, macros, modules, indexes, and validation rules in one file.

MDB files are common in older accounting, inventory, survey, reporting, and custom business applications. A database can contain multiple related tables, whereas an XLS file normally contains flat worksheets. Linked tables may store their data in other files, so exporting the MDB does not necessarily export every external data source.

What the XLS format is

XLS is Microsoft Excel’s binary workbook format for Excel 97–2003. It supports worksheets, formulas, formatting, sorting, filtering, and charts, and remains useful when a legacy application or device does not accept XLSX.

Each XLS worksheet supports up to 65,536 rows and 256 columns. XLS is therefore less suitable than XLSX for large tables and does not represent Access relationships, forms, reports, indexes, or other database objects.

How to convert MDB to XLS

Using Microsoft Access

  1. Make a backup of the original database.mdb file.
  2. Open the database in Microsoft Access.
  3. In the navigation pane, select the table or saved query to export. Use a query when the output must contain filtered, joined, grouped, or calculated data.
  4. Choose External Data → Export → Excel.
  5. Specify an output filename such as output.xls. In the format list, select Excel 97–2003 (*.xls), not XLSX.
  6. Enable Export data with formatting and layout if the displayed appearance matters. Leave it disabled when the workbook will be sorted, filtered, or processed by another program.
  7. Complete the export and inspect the workbook in Excel or LibreOffice Calc. Compare row counts and check dates, numeric values, text encoding, nulls, and column names.

Access exports the selected table or query; it does not turn the complete relational database into an equivalent multi-sheet XLS workbook. Repeat the operation for each object that must be included.

Using 101convert.com without installing software

You can convert an MDB file to XLS for free on 101convert.com without installing desktop software. Upload the file, choose XLS as the output format, start the conversion, and download the resulting workbook. Do not upload databases containing personal, financial, password-protected, or confidential information unless the service’s current privacy and retention terms are suitable.

Using MDBTools and LibreOffice

On systems without Access, MDBTools can extract basic tables to CSV, after which LibreOffice Calc can save each CSV as XLS:

  1. List the available tables with mdb-tables -1 database.mdb.
  2. Export a table with mdb-export database.mdb Customers > Customers.csv.
  3. Open Customers.csv in LibreOffice Calc. In the import dialog, verify the delimiter, character encoding, quoted text, and column types.
  4. Choose File → Save As, select Excel 97–2003 (.xls), and save the workbook.

This method requires a separate extraction for each table and preserves only exported cell data. MDBTools may fail with encrypted or damaged databases and has limited support for Access-specific types, expressions, and metadata.

Quality and compatibility limits

  • The conversion produces spreadsheet data, not a replacement Access database. Relationships, primary keys, indexes, validation rules, forms, reports, saved queries, macros, VBA modules, and permissions are not preserved in XLS.
  • Memo or Long Text fields, OLE Objects, multivalued fields, complex lookup fields, and other Access-specific types may be truncated, flattened, omitted, or converted to text. Check these fields manually.
  • Access dates, currency, Boolean values, calculated fields, and nulls may be interpreted differently by spreadsheet software. Verify locale-dependent dates such as 03/04/2025 instead of assuming the intended day and month.
  • Blank headers, duplicate column names, unsupported query expressions, and formulas can cause export warnings or altered results. Values beginning with =, +, -, or @ may be interpreted as spreadsheet formulas when opened.
  • If a result exceeds the XLS row or column limits, split it into multiple worksheets or files, or use XLSX when the receiving system permits it.
  • Retain the original MDB as the authoritative source. XLS is an exchange and reporting format and does not preserve the database structure needed for relational queries or future editing in Access.

MDB vs XLS: format comparison

How the MDB and XLS formats compare on the properties that matter most for this conversion.

Comparison of the MDB and XLS file formats
Property .MDB Microsoft Access Database .XLS Microsoft Excel Spreadsheet
Open standard No No
Compression — Both
Typical file size Medium Medium
Opens in a web browser No Partial
Further editing Limited Limited
Metadata support Basic Basic
Plain-text readable No No
Best used for Data exchange Data exchange
Introduced 1992 1987
Developer Microsoft Microsoft
MIME type — application/vnd.ms-excel

Information about file extensions and file types is provided by File-Extensions.org

Frequently asked questions

Is the MDB to XLS converter free?

Yes, converting MDB to XLS on 101convert.com is completely free. No registration, email address or installation is required. If you need a higher file size limit or want to convert more files at once, see our plans.

How large can my MDB file be?

You can upload MDB files up to 10 MB and convert up to 3 files at once in a single batch. With a paid plan the limit is up to 50 MB per file and 20 files at once, see our plans.

How long does it take to convert MDB to XLS?

9 in 10 MDB to XLS conversions on 101convert.com take at most 45 s, measured over the last 90 days. The typical file is 1.2 MB. So far 74 files have been converted.

What happens to my uploaded files?

Files are processed automatically. Your upload is deleted from our servers right after you download the result, or after 3 hours at the latest. We never view or share your files.

Do I need to install any software to convert MDB to XLS?

No. The MDB to XLS conversion runs entirely online in your browser and works on Windows, Mac, Linux, Android and iPhone.

Did the conversion fail?

In most cases, the cause is an incorrect file format. Please upload a valid MDB file for this MDB to XLS conversion. Occasionally, the issue may be on our side. We analyze recurring conversion failures and disable or fix the converter if we detect a defect.

Will converting MDB to XLS keep my Access tables and relationships?

It can transfer compatible table or query data, but Access relationships, forms, reports, macros, and database structure are not preserved in XLS. The result is an Excel workbook containing exported data, often with separate sheets for selected tables or queries.

What happens to Access fields that Excel XLS does not support?

Unsupported or complex fields, such as attachments, multivalued fields, and some OLE objects, may be flattened, changed to text, or omitted. Ordinary text, numbers, dates, and compatible query results generally transfer more reliably.

How many MDB rows can an XLS file contain?

An XLS worksheet can contain at most 65,536 rows and 256 columns, so larger Access tables or query results may be truncated, split, or fail to convert. Check the row and column counts before converting.

Why are some MDB query results missing or different in XLS?

A query may fail or produce different results when it uses unsupported expressions, parameters, custom functions, or data types. Calculated values can be exported as their displayed results rather than as editable Access query logic.

Already downloaded

This file has already been downloaded. For your privacy it was deleted from our server right after the download, so it cannot be downloaded again. To get it once more, convert the file again.