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 ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.