APPLICATION DESIGN

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 typeFile extensionsFile description
Comma Separated ValueCSVFor export only. The CSV format is an ASCII text file with one record per line whose fields are separated by commas.
Lotus 1-2-3 and Symphony®

Microsoft Excel

WKS, WK1, WRK, WR1, WK3, WK4Entire 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 textTAB, TXT, PRN, RPTASCII text arranged in rows and columns; limit of 1536 characters per record, total.
Structured textLTR, CGN, STRASCII 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.

See Also