Free online DAT to EXCEL converter

Legacy reporting, accounting, and instrument-export programs may produce .dat files while recipients need an editable workbook for analysis or sharing. Converting readable tabular data to .xlsx makes it available for sorting, filtering, formulas, charts, and standard spreadsheet workflows.

What the DAT format is

In the Documents category, .dat is a generic data-file extension, not one standardized format. A DAT file may contain comma-, tab-, semicolon-, or pipe-delimited text, fixed-width records, headers, quoted fields, metadata, or a proprietary binary structure created by a business, accounting, reporting, database, or device-export program.

Open a copy in a text editor such as Notepad, Notepad++, or Visual Studio Code. Repeating readable rows indicate that Excel or Calc may be able to import the file. Unreadable characters or undocumented structures require the program that created the file. winmail.dat is an Outlook TNEF attachment container, not a spreadsheet table, and must be extracted with a mail application or TNEF-aware tool.

What the Excel format is

Excel workbooks normally use .xlsx, a ZIP-based Office Open XML format. It stores data in cells and supports multiple worksheets, formulas, tables, sorting, filtering, charts, formatting, and data validation. Microsoft Excel, Excel for the web, LibreOffice Calc, and other spreadsheet applications can open it.

Use .xlsx when the result must remain editable or use workbook features. The older .xls format is intended for legacy applications and has lower row and feature limits. Use .csv instead when a single plain-text table is sufficient and formulas, formatting, and multiple worksheets are unnecessary.

Convert a delimited DAT file with Excel

1. Make a copy of the original file and keep it unchanged.
2. In desktop Excel, select Data → From Text/CSV and choose the DAT copy. If the file is hidden, set the file filter to All Files.
3. In the preview, select the actual delimiter: Tab, Comma, Semicolon, Pipe, or another character. Confirm that fields appear in the intended columns.
4. Choose the source character encoding, commonly UTF-8 or a Windows code page. Check accented characters and other non-ASCII text in the preview.
5. Set columns containing account numbers, postal codes, product codes, identifiers, or long numbers to Text. Set date columns to the source date order, such as YMD or DMY, rather than accepting an incorrect automatic conversion.
6. Load the data into a worksheet, compare the imported row and column structure with the source, then select File → Save As and choose Excel Workbook (*.xlsx).

Import fixed-width DAT files

Use a fixed-width import when fields occupy defined character positions rather than being separated by a delimiter. In Excel, open the file through File → Open with the type set to All Files, or enable the legacy text import wizard through Data → Get Data → Legacy Wizards → From Text (Legacy) when available. Select Fixed width, place the column breaks at the correct character positions, assign text or date types where needed, and load the result before saving it as .xlsx.

If the file contains multiple header lines, footers, or report formatting, remove those rows only after confirming which lines are records. A report designed for printing may need manual cleanup before it becomes a reliable table.

Use Power Query for repeated files

For recurring delimited exports with the same layout, select Data → Get Data → From File → From Text/CSV in desktop Excel. Configure the delimiter, encoding, filters, and column data types in Power Query, then select Close & Load. The query can be refreshed for later files with the same structure, reducing repeated type and cleanup errors.

Use LibreOffice Calc

1. Open the DAT copy in LibreOffice Calc through File → Open. Select All files or a text/CSV file type if necessary.
2. In the import dialog, choose the source character set, delimiter, or fixed-width layout.
3. Review the preview and assign text formats to identifiers, leading-zero values, and other fields that must not be converted to numbers or dates.
4. Select File → Save As and choose Excel 2007–365 (*.xlsx). Recheck formulas, dates, formatting, and calculated values because some spreadsheet features can translate differently.

For a one-off conversion without installing software, the file can be converted on 101convert.com for free. Do not submit confidential, personal, financial, proprietary, or regulated data unless the service’s handling terms meet the required security and retention standards.

Convert proprietary or binary DAT files

Identify the program, database, or device that produced the file from its source folder, surrounding files, documentation, or export settings. Use that program’s File → Export, Save As, report-export, or data-export command to create .csv, .tsv, .xml, or another documented tabular file, then import that file into Excel.

Renaming file.dat to file.xlsx changes only the filename extension; it does not convert the internal format and may prevent the source program from recognizing the file.

Check conversion quality and limits

Compare the source and workbook row counts, column order, delimiter placement, encoding, missing values, duplicate records, decimal separators, dates, and negative values. Excel can remove leading zeros, reinterpret dates, evaluate formula-like text, and display long numbers in scientific notation. Excel preserves only about 15 significant digits for numeric values, so high-precision measurements and long identifiers should remain text or be processed in a database or specialist system.

An Excel worksheet supports up to 1,048,576 rows and 16,384 columns. Large exports may require a database, Power Query data model, or dedicated data-processing tool. Conversion cannot reconstruct fields missing from the source or reliably decode undocumented binary data, and DAT-specific metadata, application settings, database relationships, and unsupported formatting may not survive the export.