Exporting to a worksheet

When you export a view to a worksheet, each document becomes a row in the worksheet. Each field becomes a column in the worksheet. The original field contents become cell contents. Column titles become labels in the worksheet.

When you export a view to a new worksheet file, Notes exports the file in 1-2-3 WK1 format. Although you can specify any extension with the file name, it's best to keep the extension .wk1. When you open the exported file in a newer release of 1-2-3, 1-2-3 automatically converts the file to its new format and adds the appropriate extension.

If you change the exported file to WK2, WK3, or WK4 before opening it in a release of 1-2-3 that uses that extension, and then open the file in 1-2-3 and attempt to add and save attributes, the new copy of the file will be in conflict with the original, and you won't be able to save your changes.

To export to a Microsoft Excel file, export the view as a 1-2-3 worksheet, and then save the file in 1-2-3 as a Microsoft Excel file.

Exporting to a tabular text file

Tabular text is ASCII text arranged in rows and columns, separated by space characters. When you export a view to a tabular text file, each document becomes a text row (line). Each field becomes a text "column," separated by space characters. The original field contents become the "cell" contents. To see the separation between columns in the exported view, use a monospaced font for the columns in the original view.

The result of a tabular export may not look exactly like the view. Views use a proportionally spaced font, but exports use a monospaced font. Export a few documents as a test. Then, if necessary, adjust the column width settings in the view before you perform the whole export.

To display or edit the contents of a view in a Notes document, export the view to a tabular text file. Then import the tabular text file into a Notes document.

Exporting to a structured text file

Structured text is ASCII text that retains its structure in fields and values. Exporting a view to structured text creates a file containing the text of all the documents in the view, minus any rich text attributes.

To export a view

1. Select the database and open the view you want to export.

2. (Optional) Select specific documents to export only a subset of the view.

3. Choose File - Export.

4. Select the file format you're exporting to.

5. Do one of the following:

• To replace an existing file, select a directory and file name from the list.
• To create a new file, enter a new file name.
• To append to an existing tabular text file, select a directory and file name from the list.

7. If you selected an existing file, do one of the following:

• To replace the file, click Replace.
• To append to an existing file, click Append.

9. (Optional, for 1-2-3 worksheet or tabular text formats) Select "Include View titles" to export the view's column headings to a worksheet or tabular text file.

10. (Optional, for structured text format) Change the inter-document delimiter and word-wrap settings if you are exporting to a structured text file.

11. Click OK.

Delimiter and word wrap settings

• Delimiter - Choose Form Feed to use a form-feed to separate records in the file, or choose Character Code to separate the records in the file with the ASCII code for a delimiter other than the default, ASCII 12 (form-feed), such as:
  
  32 Space

  44 ,

  45 -

  58 :

  59 ;

  124 |

• Word wrap - Represents the number of characters at which each line wraps. The default is 75 characters.

File formats you can export and import