The Data Trick
If your data is in Excel, this is a quick and easy way to turn it into pages without all the bloated code produced by the automatic conversions and with more control over the final appearance --- able to tinker and tweak.
Most other spreadsheet programs, such as QuatroPro, should work in a similar manner. If the data is laid out in tabbed columns or separated by commas in a word processor, you may be able to save as a tab or comma delimited file and import it into a spreadsheet program. If you do a conversion of this sort, be sure to *eyeball* the resulting spreadsheet columns and adjust anything that has jumped over a column or two.
A simple data list:
Now, insert columns and put in table row and cell code:
Select and copy the area and paste directly into an html code page, in between table start and end tags. On a real page you would probably have consistent heading and footer areas as well. The results of the simple coding above, plus some cellpadding and a border, would be:
If you, or any of your viewers, are looking at this in Netscape, you'll see a couple of blank looking spots for Spencer and Jane as they don't have middle initials. This can be resolved by putting a in the empty cells. On a large amount of data which is where this trick really comes in handy, just do a search and replace for <TD></TD> replacing it with <TD> </TD> with the results below:
The above is a truly plain table but using the same methods you can come up with some really nice results. I recommend starting with a sample block of 10 or so rows of your data until you work out precisely what coding you'll want for your final design. Let's make the surname bold.... merge the given name and middle initial columns and make the birthplace column maroon with white text.
turns into this:
You don't have to do tables with the information... you can do a paragraph style:
Name: Smith Fred G
Name: Jones John K
Name: Brown Jane
Name: Kellogg Spencer
Name: Andrews Rebecca L
Make it a bulleted list style:
Smith Fred G
Jones John K
Andrews Rebecca L
Many data pages look better done in a sans serif font like Arial. It's not necessary to put the font code in every table cell though. Use a simple style sheet and put the following code between the <HEAD> and </HEAD> tags:
This will make a table like the first set of data look like this:
One of the places I have used this method is on the pages indexed at:
When completed the naturalization pages will have over 53,000 names, about 36,000 are up now, with approximately 200 names per page on average. The deaths pages has about 43,000 names, also averaging 200 a page.