How to convert Excel to HTML so that the website display can be responsive

Question

I'm creating content on my website and want to make a table from Excel, so I can quickly retrieve data from Excel, so how do I convert the data from Excel??

Answer 1

Hello Konveksi,

Thank you for posting here in Microsoft Community.

It is possible to convert an Excel file into an HTML format. In order to convert an Excel file to HTML, you can follow these steps:

1. Open the Excel file you want to convert.
2. Select the cells you want to include in the HTML table.
3. Click on "File" in the top left corner of the Excel window.
4. Click on "Save As" and choose "Web Page" from the list of file types.
5. Choose a location to save the HTML file and click "Save".
6. In the "Publish" section, select "Entire Workbook" or "Selection" depending on your preference.
7. Click on "Publish" to save the HTML file.

With regard the configuration on your website, to set your expectations that I have only limited knowledge on this field.

But once you have the HTML file, you can embed it on your website using an HTML code. To make the table responsive, you can use CSS to adjust the table's size and layout based on the screen size of the device being used to view the website.

Also take note if you do have hyperlinks attached on the table that is linked to another area on your workbook that you want also be an HTML format, you may need to individually save those links as HTML format and update the hyperlink to link with the HTML format instead of the workbook or worksheet.

I hope this information helps! If you have other questions, please do feel free.

Best regards,

Arquel C.

Microsoft Moderator

Answer 2

I can quickly retrieve data from Excel,

display can be responsive

layout Responsive？

or retrieve data dynamically?

Answer 3

i mean, mobile responsive.

I want to make information in the product description by adding a table on my website KonveksiIndo, to make it faster I want to convert from Excel to HTML. but I want after converting the display to be mobile responsive

Answer 4

I am not sure the details about what you want.

You can save Excel sheet as a html which Arquel C. has mentioned.

But if u want to generate html like the web https://konveksiindo.com/ which includes pictures display different columns in PC and moblie,the Excel save-as function is not possible.

you need css like flex layout to create your own page.

https://developer.mozilla.org/en-US/docs/Web/CSS/flex

I create similar page as below

e.g.: https://e.anyoupin.cn/EData/?

Answer 5

Hello Konveksi,

I agree with peiyezhu, which you can try proceeding with the steps provided. I appreciate your collaboration on this, but I am afraid I have limited knowledge with this matter as it's already beyond my field of expertise.

Best regards,

Arquel C.

Microsoft Moderator