Data File Formats

Import and export worksheet data in several data file formats.

Use File | Import to import the following formats into the worksheet:

ACCDB Microsoft Access 2007-2010

BLN Golden Software BLN Files

BNA Atlas BNA Files

CSV Comma Separated Variable CSV Files

DAT Files

DBF Database Files

MDB Microsoft Access 1997-2003 Files

SEG Data Exchange Format

P1 Data Exchange Format

SLK Sylk Spreadsheet Files

TXT Text Data Files

XLS Excel Files

XLSX Excel Files

XLSM Excel Files

 

Use File | Open Excelto import Excel files into a native Excel window.

XLS, XLSX, XLSM Excel Files

 

Use File | Save As to export the following formats from the worksheet:

BLN Golden Software BLN Files

BNA Atlas BNA Files

CSV Comma Separated Variable CSV Files

DAT Files

SLK Sylk Spreadsheet Files

TXT Text Data Files

XLS Excel Files

XLSX Excel Files

See Also

Opening Worksheet Files

Saving Worksheet Files

Worksheet Document