is there an easy, free way to convert an excel spreadsheet into an HTML table that is not 20mb?

Question

I have a schedule saved in an excel spreadsheet, I need the exact schedule in a html table. I tried to "save as" in Excel but the file was over 20mb, i have searched the web and can only find VBA and "buy my product" stuff. Any ideas?

Great, i did the " sekection" and it worked. File size is only 100k.

Thanks

Answer 1

In Excel, highlight the section you want to save, then use the "Save as Web Page" option under File, and make sure to click on the Selection radio button instead of the default Entire Workbook radio button

Answer 2

sure, but it takes some assembly.

start in the column just beyond the last filled data column.

type the following
=concatenate("",a1,"",b1 ,"",(include all of your columns with these dividers and then at the last),j1,"

copy this completed monstrocity and the paste it in all of the rows of this single column down the page to the row where your data stops. It will produce the Table row and cell info for your webpage.

Now go to note pad and type the following

Answer 3

1) If you can convert the worksheet to a pdf (pdf creator apparently included with newer versions of Office, or get a free one); that can MAYBE be attached to or included in your html file
2) make sure you aren't trying to save more than one sheet (20MB sounds REALLY large; is it a multi-sheet workbook?
3) I have cut/pasted xls tables into email messages, I THINK I was using html format.

If none of these help, then maybe someone else can! Good Luck

Answer 4

do you have frontpage or dreamweaver? if you do, just copy the table and paste it to the design view of any of those two programs.. then just save your work.. the file should be smaller, but it still depends on how big that schedule is of yours..