Convert WDB to XLS

An older Microsoft Works database may need conversion when a recipient, reporting system, or office computer accepts only an Excel workbook. Converting it to .xls also makes the tabular records editable in Excel, but the database structure itself is not preserved.

What the WDB format is

.wdb commonly identifies a Microsoft Works Database file created by Microsoft Works. It stores records in user-defined fields, such as contacts, addresses, inventory items, or simple lists, rather than using a standard spreadsheet worksheet.

The extension is not unique; unrelated applications also use .wdb. Confirm the source program before converting. Renaming the file to .xls changes only its name and does not convert its contents.

What the XLS format is

.xls is the binary Excel workbook format used by Microsoft Excel 97–2003 and supported by some older spreadsheet and business applications. It can contain worksheets, formulas, formatting, filters, and charts, making the records easier to edit and share than a Works database file.

Each .xls worksheet is limited to 65,536 rows and 256 columns. Use .xlsx for new workflows unless a legacy application specifically requires .xls; it supports larger sheets and newer Excel features.

Convert with Microsoft Works

1. Open the file in Microsoft Works Database, preferably the Works installation that created it or a compatible Works 6–9 installation.
2. Check field names, record counts, dates, blank values, text length, and unusual characters before exporting.
3. Use File → Save As or File → Export and select a delimited format offered by that Works version, such as comma-delimited .csv or tab-delimited text. Set field and text delimiters when the program provides those options.
4. Open the exported file in Excel or LibreOffice Calc. In the import dialog, select the correct delimiter and encoding, and set postal codes, telephone numbers, account numbers, and other identifiers to Text so leading zeroes are retained.
5. In Excel, select File → Save As, choose Excel 97-2003 Workbook (*.xls), and save. In LibreOffice Calc, choose File → Save As and select an Excel 97–2003 .xls format.

If Works offers a direct Excel export, it can be used, but verify the result as carefully as a CSV conversion. Delimited export is usually the more portable fallback.

When Microsoft Works is unavailable

Current Excel and LibreOffice Calc generally do not provide dependable direct support for Microsoft Works Database files. A licensed installation or original media for Microsoft Works may therefore be required, sometimes in an older Windows virtual machine that can run the program.

Specialized Works database utilities may extract records, but support varies by Works version and file structure. Use a utility only after confirming that it explicitly supports Microsoft Works Database files, not merely another format with a .wdb extension. Export the extracted data to .csv, tab-delimited text, or another documented interchange format, then import it into Excel and save as .xls.

Online conversion

Services such as Zamzar and Convertio sometimes list Microsoft Works Database as an input format, but their supported formats and conversion quality change. Before uploading, confirm that the service explicitly lists .wdb as Microsoft Works Database and .xls as an output format; a generic WDB listing may refer to a different application.

Upload a copy rather than the original, and do not use an online service for confidential contacts, financial records, or other sensitive data. Open the returned workbook and compare its row count, headings, dates, and representative records with the source.

Quality and compatibility limits

A CSV or text intermediary transfers field values, not the complete database. Forms, reports, indexes, relationships, validation rules, field types, and Works-specific calculated fields are normally lost. Formatting and formulas may also require manual recreation.

Inspect fields containing commas, quotation marks, or line breaks because incorrect delimiter or quoting settings can shift values into the wrong columns. Check dates against the source because regional settings can reverse month and day positions. Prevent automatic conversion of long identifiers and decimal values during import.

If the data exceeds the row or column limits of .xls, save it as .xlsx or divide it across worksheets. Reopen the finished workbook in Excel or LibreOffice and verify record counts, column headings, dates, identifiers, formulas, and several records from each part of the original database.