If you created a pretty Excel table and now want to publish it online as a web page, the simplest way is to export it to an old good html file. In this article, we are going to explore several ways of converting Excel data to HTML, determine pros and cons of each, and walk you through the conversion process step-by-step. Continue reading
Comments page 2. Total comments: 45
Hi,
Is there either a free, or relatively inexpensive option to convert my Excel 2007 sheets, that contain simple formulas and drop down lists to HTML? Simplified, an example of my excel sheet is:
Cell.(Assume column "A" states descriptions for column B)
B1: Blank number input
B2: =SUM(A1*4)
B3: Drop down with "Yes" & "No" choice
B4: =IF(B3="Yes",B2*0.0085/12,IF(B3="No","B2*0.0085/4"))
My excel sheet has 3 columns and 25 rows, but nothing that is anymore complicated that what I stated above.
I found a spreadsheet convertor that does EXACTLY what I want, plus MANY things I do not need for nearly $300USD. Is anyone aware of an alternative?
How can I convert an excel table into html code?
My website builder don't allow me to copy excel table in its field, and I have to copy / paste the html code instead.
thank you in advance!
Hi Svetlana,
Could you please tell me about how can we import data in excel from website. If am having 5 to 6 websites date want to download at a time, how much duration (time) it will take. If there any option or code to decrease the download time. This is my 1st issue.
And 2nd issue is difference between dates calculation. If A2 cell having 02/03/2016 and A3 cell 02/04/2016, when I used datedif(A2,A3,”d”) it is calculated between days is 0(only). But there is difference between two date is 1 day. And how can I subtract number of days like 2 or 3 or 5 days in a month days (days 2 –(minus) February 29 days) answer is obviously 27. But I want to get through formula
Hi Svetlana,
Thanks for your nice tutorial. I am a exel addict for years. Firts with Lotus 123a and later Excel. Now I work with osx - apple. I did not figure out how to get plugins for excel in osx. Tableizer is nice, but limited.
Do you have a suggestion?
Keep up the good work.
Happy Valentine,
Walther
Hello, Walther,
Unfortunately, plug-ins for Excel for Windows don't work with Excel for MAC. You can try Microsoft Office Online add-ins.
Hi,
I am trying to save my excel table to html format with a few columns hidden. When I try to link it to a sharepoint at as a page viewer, I tested the link and it was still ok before I press apply. However, when I press apply, the whole table gets shown and my hidden columns were exposed in the web part. Can anyone advice on how to hide these columns when you do publishing online? Thanks!
Hello, Darren,
Please specify what steps you follow to save the table.
Hi,
I am saving the excel sheets as (.mhtml) using VB Script.
Its getting published correctly but my problem is its displaying the sheet name (E.g. Sheet1) as well in the created (.mhtml) file. I don't want these sheet names to be displayed in the web page.
I tried hiding the sheet names in the excel and then saving it as (.mhtml) but the problem is not solved. Can anyone tell me if its possible to hide the sheet names in web page. Thanks in advance :)
Edit the html too remove them.
Hello, Abhinav,
Please specify your VB script.
I am looking for a converter that keeps the name of the Custom Styles that i have created in excel. Instead of the style-name the html-file contains something like this xl1526560 and I would like it to use my custome-name CHORD, is it possible?
Hello, Fleming,
Please specify your Excel version and what steps you follow to convert to HTML.
I am trying to get a small excel file to save as an 'interactive' webpage. The process seems to be missing from excel 2010. I have been unable to find any updated info on anything that MS did to replace the 'make interactive'in the 'save as web page dialog.
Any advice is most welcome.
Hello, Dorn,
Unfortunately, the option to publish interactive web pages was removed after Excel 2007.
You can try the following steps:
Upload the Excel file to your OneDrive, right-click the uploaded file, select "Embed > Generate" to create the html code you need.
Hi Svetlana,
I converted some cells to HTML and embedded it to my website. I saved the original spreadsheet to my desktop but changes I make to the spreadsheet are not being reflected on the HTML in my website. I checked the box "AutoRepublish every time this workbook is saved"
Thanks in advance for your help on this.
Alvaro
You can use https://ftpbox.org and sync your local auto published html file to your host automatically.
Hi Alvaro,
In case of frequent updates, a more efficient way is publishing your workbook online and linking it to your website. For more details, please see my other post:
https://www.ablebits.com/office-addins-blog/excel-online-web-app/
Hello and thank you for this very in-depth page! I'm having an issue that I don't think is addressed - I'm trying to create an HTML file from an XLS doc with drop downs. After conversion, the drop downs are not active. They're integral to the spreadsheet because choosing an item in the list dictates the specific data that populates on the page. Does that make sense?
Is there a way to create an html doc that will allow these drop downs to stay active?
Anyway to output just a straight HTML table without all the gross CSS styles? That is, anyway to export the selected range without styling?
Hello Johnny,
You can use Tableizer, a free Excel to HTML online converter described in the article, and then remove the <style> </style> block from the results.
This might help http://www.calvert.ch/maurice/2012/01/13/convert-excel-to-html-with-formatting/
Hi Svetlana
This is a great little tutorial, unfortunately I cannot get any charts to publish - I just get the red x.
There are no supporting files, so there are no missing graphics.
But before I even get that far I don't get the option to pick a chart when I select Items on Sheet - it just says "Sheet All contents of Sheet" but is grayed out.
Any clues?
Hi Chris,
It's very hard to pin down the cause of the problem without seeing your workbook. This might happen if the workbook is read-only and no edits including export are allowed. If this is not the case, then please specify what Excel version you use. Also, do you want to publish the entire content or charts only?
If you could send us a screenshot with the grayed out options or even better your sample workbook to support@ablebits.com, then we will definitely be able to to figure this out.