Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
is there an easy, free way to convert an excel spreadsheet into an HTML table that is not 20mb?
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
4 Answers
- 1 decade agoFavorite Answer
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
- Jason W-SLv 41 decade ago
sure, but it takes some assembly.
start in the column just beyond the last filled data column.
type the following
=concatenate("<tr><td>",a1,"</td><td>",b1 ,"</td><td>",(include all of your columns with these dividers and then at the last),j1,"</td></tr>
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
<html>
<body>
<table>
<!-- paste all of your excel concatenated rows here -->
</table>
</body>
</html>
Then paste your entire column where the comment is located. You can then adjust your style and other details here.
save the file as an html file (remember to change the pulldown from txt to all files in notepad
Then open the file in a browser and check the data.
- 1 decade ago
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
- 1 decade ago
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..
