How can I export view data into tabular text files?

Tabular text is ASCII text arranged in rows and columns, separated by tabs. When you export a view to a tabular text file, each row in the IBM® Notes® view becomes a text row (line). Each column in the view becomes a text column, separated by space characters. The contents of the Notes® fields shown in the view become the entries in each column.

About this task

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.

Exporting from a view does not remove documents from the view, but simply copies the data into a new file.

Perform the following steps:


  1. In a view, select the documents you want to export.
  2. Click File > Export.
  3. In the Export dialog box, click Tabular Text in the Save as type list.
  4. In the File Name box, either create a new file by typing a name and extension, or replace data in an existing file with the exported data by selecting the file.
  5. Click Export.
  6. If you select a file that already exists in the directory, click Replace to overwrite that file, or Cancel to return to the Export dialog box so you can enter a new filename.
  7. Select to export All documents or Selected documents.
  8. To include the view titles at the top of the exported file, check Include View titles.
  9. Select a character set for the exported file -- either Default, International, or Unicode.
  10. Click OK.