I was transcribing the 1930 Hot Springs County Wyoming census and used Open Office spreadsheet to enter the data. When I got done I saved as HTML and added the top of the page and end. The code generated by the spreadsheet program was very minimal. On 10/15/2010 02:58 PM, Ralph Taylor wrote: > To convert an Excel (or other spreadsheet) table to HTML, I prefer the > method introduced here by Barry Carlson a few years ago. It involves saving > the file as plain text before converting it to HTML. > > One advantage is that it requires knowing only those few HTML codes used in > tables. It is the most efficient procedure I've found for producing a HTML > table from spreadsheet data without "code bloat" and I've used it many > times. > > Step-by-step: > 1. Insert a new, blank column before the first column of data and columns > between each data column. This avoids over-writing the data with HTML codes. > > > 2. On a blank row before the data, enter the table-opening tag,<table>; on > a blank row after the data, enter the closing table tag,</table>. > > 3. In the first column (the one you inserted), enter the codes to open a > table row and a table cell,<tr><td>. For the header row, substitute > <tr><th>. Copy the<tr><td> codes all the way down the column to the end of > the table. > > 4. Between data columns, enter the codes to close one cell& open another, > </td><td>. (Header row:</th><th>.) Copy the codes all the way down the > table. > CSS: If you want CSS styling of some cells, step 4 is the time to > specify the class. > > 5. In the column after the data, enter the codes to close a cell and a row, > </td></tr>. Copy the codes all the way down the table. > > 6. IMPORTANT! "Save as" the file as a plain text file, with a .txt file name > extension. DO NOT SAVE AS WEB PAGE! This strips out any formatting that > hasn't been given a HTML code. (You'll notice that the text file has tab > spaces between each former Excel cell, you can use Control-H to strip these > out if desired.) > > 7. Open the file in Notepad or other plain-text editor; alternatively, open > it in your Web editor. Add in the other stuff (doctype, document header, > body tags, includes, etc.); if you've created a template, you'll mostly copy > and paste. > > 8. "Save as" the file with a .htm extension. > > You now have an HTML file with only the formatting that you specifically > choose. There is no bloated code to strip out. You can continue to work with > it in your Web editor. > > Two tips: > 1. It's helpful to use a second version of the file, so that the original is > available in case of mistakes. Save the second version frequently during the > processing. > 2. For multi-column tables, I like to start with the last column and work > from right to left. > > -rt_/) > > > > ------------------------------- > To unsubscribe from the list, please send an email to FREEPAGES-HELP-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > > -- "A good moral character is the first essential in a man." George Washington