Convert a Spreadsheet to an HTML Table

When you want to turn that giant spreadsheet into an HTML table without wrangling too many TD’s and TR’s by hand, you can use a formula to generate the HTML tags for you. The Design Intellection blog describes how to use the =CONCATENATE("text", cell, "text") spreadsheet formula to turn a row of data into an HTML table row. On Friday, Kevin pointed out a web-based HTML table generator that’s a simple, fast solution for small tables; but if your data’s already in a spreadsheet and the word “concatenate” doesn’t make you want to run screaming, this may be a better way to go.