Capturing Spreadsheet Data

1. Save the spreadsheet as an HTML file

Edit spreadsheet file:  File menu --> SaveAs
At the bottom of the form Click on the "All Formats" button and select "HTML document"
Verify filename and location and Click on the "Save" button.
At the popup verify that you want the "html" choice.

2. Remove all html styling from the file.

 Open the html file in a "text" capable editor.  
 Select all text and copy to the clip board.
 go to the "[[http://www.brave.net.au/online-html-cleanup-tool.php|Clean up HTML code]]" web site
 Paste the text (clipboard) into the "copy and paste" box.
 Select "clean this text" button.
 When the tool is finished removing all styling copy the result text back into the clipboard
 Paste the clean table into the new page.
 Replace the original text in the html file with the cleaned text
 save the html file in the work folder.