Convert XLS to MDF
Import legacy Excel XLS data into a SQL Server database and obtain its MDF and LDF files.
Convert XLS files online
We don’t have a dedicated online converter for XLS to MDF yet, but you can convert XLS files online to these and more formats:
Want to convert XLS to MDF?
Let us know. We pick the conversions to add next by how many people ask for them.
How to convert xls to mdf file
- Databases
- No ratings yet.
A legacy spreadsheet may need to be loaded into Microsoft SQL Server when a business application, reporting system, or database administrator requires SQL Server data rather than an Excel workbook. The conversion is an import into a SQL Server database; it is not a direct file-format rewrite.
What the XLS format is
XLS is Microsoft Excel's binary workbook format for Excel 97–2003. It stores worksheets, cell values, formulas, formatting, charts, comments, and limited workbook metadata. Excel, LibreOffice Calc, and older business systems can create XLS files.
An XLS workbook is not a relational database. During import, each selected worksheet normally becomes a SQL Server table, and its first row can become the table's column names.
What the MDF format is
MDF is the primary data file used by Microsoft SQL Server. It stores database pages containing tables, indexes, schemas, and other database objects. SQL Server normally creates a separate .ldf transaction-log file alongside it.
MDF is appropriate when data must be queried with Transact-SQL, used by a SQL Server application, or administered through SQL Server Management Studio (SSMS). It is not a portable spreadsheet format, and renaming workbook.xls to database.mdf does not convert the contents.
How to convert XLS to MDF
Using SQL Server Import and Export Wizard
- Install a local SQL Server instance, such as SQL Server Express for many local workloads or Developer Edition for development and testing. Install SSMS separately if it is not included. Typical instances include
localhost\SQLEXPRESSand(localdb)\MSSQLLocalDB. - Make a backup of the XLS file. Identify the worksheets to import, confirm whether the first row contains column names, and remove workbook encryption if the provider cannot open the file. Worksheet protection alone is a separate Excel feature and may still restrict editing.
- Create a destination database in SSMS, or let the wizard create one. To control the MDF and LDF locations, run a command such as
CREATE DATABASE XlsImport ON PRIMARY (NAME = XlsImport, FILENAME = 'C:\SQLData\XlsImport.mdf', SIZE = 50MB, FILEGROWTH = 25MB) LOG ON (NAME = XlsImport_log, FILENAME = 'C:\SQLData\XlsImport_log.ldf', SIZE = 25MB, FILEGROWTH = 25MB);. The directory must already exist and be writable by the SQL Server service account. - Open SQL Server Import and Export Wizard. Select Microsoft Excel as the data source, choose the XLS file, and select the Excel 8.0 or Excel 97–2003 format. If the Excel provider is missing, install the Microsoft Access Database Engine matching the wizard's 32-bit or 64-bit architecture.
- For the destination, select Microsoft OLE DB Driver for SQL Server, then specify the SQL Server instance, authentication method, and
XlsImportdatabase. The older SQL Server Native Client may work on existing installations but is deprecated. - Choose Copy data from one or more tables or views. Map each worksheet to a table, remove unwanted sheets, rename tables and columns where necessary, and enable the first-row-as-column-names option when applicable.
- Review the column mappings instead of accepting every inferred type. Assign suitable SQL types to dates, decimal amounts, identifiers, and long text. Run the import, then verify row counts and values in SSMS, for example with
SELECT COUNT(*) FROM dbo.Sheet1;.
SQL Server creates the MDF as part of the database creation process. To locate the physical files, run SELECT name, physical_name FROM sys.master_files WHERE database_id = DB_ID(N'XlsImport');. For transfer to another SQL Server, a .bak backup and restore is usually safer than copying database files.
If an MDF is specifically required, stop access and detach the database only after confirming that no required connections remain:
ALTER DATABASE XlsImport SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
EXEC sys.sp_detach_db N'XlsImport';
Attach the MDF and its LDF through Databases → Attach in SSMS. The destination server must be the same or a compatible newer SQL Server version, and its service account must have access to the file directory. Do not distribute only the MDF unless the recipient understands SQL Server attachment and recovery procedures.
Using automation
Recurring imports can use SSIS, PowerShell, or Python with pandas and pyodbc. These tools read the XLS workbook and insert rows through SQL Server; they do not write a valid MDF file directly. A database administrator should add primary keys, constraints, indexes, and appropriate schemas after loading the tables.
Quality and compatibility limitations
- Worksheet formatting, charts, merged-cell layout, comments, macros, and most formulas are not relational database objects. Imports generally load values or formula results, not the workbook's presentation or executable VBA. Recalculate and save the workbook in Excel first if current formula results are required.
- The Excel provider infers column types from sampled rows. Mixed numeric and text values can become NULL, be truncated, or be converted incorrectly. Import uncertain columns as text into staging tables, then clean and cast them with SQL.
- Legacy XLS worksheets are limited to 65,536 rows and 256 columns. SQL Server supports different limits, but imported data still needs suitable types and a deliberate table design.
- Online conversion services such as Zamzar or CloudConvert are not suitable for producing a deployable SQL Server MDF; they target document and spreadsheet conversions rather than SQL Server database creation. Uploading business spreadsheets can also disclose their contents. Use a local SQL Server instance and SSMS for this conversion.
XLS vs MDF: format comparison
How the XLS and MDF formats compare on the properties that matter most for this conversion.
| Property | .XLS Microsoft Excel Spreadsheet | .MDF Media Descriptor File |
|---|---|---|
| Open standard | No | No |
| Compression | Both | Both |
| Typical file size | Medium | Large |
| Opens in a web browser | Partial | No |
| Further editing | Limited | Not directly editable |
| Metadata support | Basic | Basic |
| Plain-text readable | No | No |
| Best used for | Data exchange | Long-term archiving |
| Introduced | 1987 | 2000 |
| Developer | Microsoft | Alcohol Soft |
| MIME type | application/vnd.ms-excel | — |
Information about file extensions and file types is provided by File-Extensions.org
Suggested software and links: xls to mdf converters
Frequently asked questions
Will my Excel formulas and formatting be preserved when converting XLS to MDF?
No, an XLS-to-MDF import generally stores worksheet data in database tables, not as a formatted workbook. Formulas may be imported as their calculated values, while cell formatting, charts, and other spreadsheet features are not preserved.
Can I still edit an MDF file like an Excel spreadsheet?
No, an MDF file is a SQL Server database file, so its data is organized in tables rather than worksheets. You can work with the imported data as database records, but the original spreadsheet layout is not retained.
Why are some XLS values blank or changed in the MDF database?
The import process has to infer database column types from spreadsheet cells, and mixed values in a column can be misread or omitted. Check columns containing both numbers and text, dates, or formulas, and verify the imported values.
Does converting XLS to MDF also create an LDF file?
A SQL Server database normally has a transaction log file, commonly with the LDF extension, alongside its MDF data file. The log records database changes; it does not contain a separate copy of the original workbook.