Copy Data from Lotus Notes to Spreadsheet:

Since spreadsheets are designed for number crunching and chart creation, let's look at how using "Copy Selected as Table" can help you easily transfer data from Notes documents into a spreadsheet.

Select the documents we want to transfer, right click, and choose "Copy Selected as Table"



Next open the spreadsheet (Lotus 1-2-3, OpenOffice Calc, Excel, etc.), place the cursor in the cell where we want the data to start, and "paste".




The data from Notes view is now in a spreadsheet. We may have to format the rows and columns a bit to look exactly as we want.