How to import html form data to excel?

Asked By 30 points N/A Posted on -
qa-featured

Hello Experts,

How to import html form data to excel? I want to transfer all my html form in to the Microsoft excel form for recording purposes. I hope you can share with me the correct and accurate commands in order for me to transfer or import some files to Microsoft excel application. Your help will be much appreciated.

Thank you.

SHARE
Answered By 0 points N/A #173886

How to import html form data to excel?

qa-featured

Hello Miss,

Follow the link below: http://html.brothersoft.com/html-to-excel-converter.html

You can do your desired job by it. But the Excel file will not be as same as the html file you see. If you want them exactly same, then do it manually with proper formatting.

Thanks.

Answered By 60 points N/A #173888

How to import html form data to excel?

qa-featured

Hi Any Hill,

I have read your concern about importing HTML data to MS Excel. I made a research about it and it is seemed that there are a lot of ways in importing that kind of data. You can check this site:

How to import HTML into Excel

It is very easy to understand because it has a pictures and step-by-step instruction.

NirmalTV: How to Import HTML tables to excel

The Link above may also help you.

Thanks.

Answered By 0 points N/A #173890

How to import html form data to excel?

qa-featured
Hello Any Hill,
 
Here's a sample code. Watch Tutorial on Youtube for additional knowledge about this.
 
<%response.ContentType="application/vnd.ms-excel"%> 
<html> 
<head> 
<style type="text/css"> 
td {padding:2em; background-color:yellow; border:1px dotted #000;} 
</style> 
</head> 
<body> 
<table> 
<tr> 
        <td>1</td> 
         <td>2</td> 
         <td>3</td> 
         <td>4</td> 
</tr> 
<tr> 
       <td>=sum(a1:d1)</td> 
        <td>6</td> 
      <td>7</td> 
      <td>8</td> 
</tr> 
</table> 
</body> 
</html>
 
Hope this helped you!
Answered By 5 points N/A #173889

How to import html form data to excel?

qa-featured

 

You can simply do it with MS Excel itself. Follow the Steps:
 
1. Open an Excel Sheet and select the Data Tab in the ribbon.
 
2. Click on From Web icon.
 
3. A pop up window will open. Enter the web page URL you want to import.
 
4. Click on Import.
 
All HTML data from the web page are imported to the Excel.
 
Thank you.

Related Questions