File formats you can export and import

No matter what type of data you want to import into a view, it's best to import a small test file first. You can quickly determine whether the import is working correctly and make any necessary corrections before you import the entire file. The following table lists the types of files you can import and export.

File type

File extensions

File description

Comma Separated Value

CSV

For export only. The CSV format is an ASCII text file with one record per line whose fields are separated by commas.

1-2-3® and Symphony®

Microsoft Excel

WKS, WK1, WRK, WR1, WK3, WK4

Entire worksheet or named range.

To import a Microsoft Excel file, use Excel to save the file as a 1-2-3® worksheet and then import it.

You cannot import a WRK or WR1 file to a view, but you may export to either format. If you import a multiple-worksheet file, only the worksheet that was most recently viewed will be imported. If you import a specific range from a multiple-worksheet file, only the information from the most recently viewed worksheet will be imported.

Tabular text

TAB, TXT, PRN, RPT

ASCII text arranged in rows and columns; limit of 1536 characters per record, total.

Structured text

LTR, CGN, STR

ASCII text that retains its structure in fields and values; shown as one record per page and one field per line; limit of 256 bytes per simple text field.