I had html page with multiple datas. I wish to print html result in excel. My results are in a vertical line. But i want them in a horizontal way.
<table border=0 cellspacing=0 cellpadding=0>
<tr height=14>
<td width=21 align=left>
<br>
</td>
<td width=354 align=left>
<font style=font-size:8pt face="arial" color=#333333>children clothing</font>
</td>
<td width=98 align=right>
<font style=font-size:8pt face="arial" color=#000000>page 1 of 86</font>
</td>
</tr>
</table>
<table border=0 cellspacing=0 cellpadding=0>
<tr height=14>
<td width=21 align=left>
<br>
</td>
<td width=477 align=left>
<font style=font-size:8pt face="arial" color=#969696>_____________________________________________________________________________</font>
</td>
</tr>
</table>
<table border=0 cellspacing=0 cellpadding=0>
<tr height=20>
<td width=20 align=left>
<br>
</td>
<td width=478 align=left>
<b>
<font style=font-size:11pt face="verdana" color=#333333>zion garments</font>
</b>
</td>
</tr>
</table>
<table border=0 cellspacing=0 cellpadding=0 id="qmstable">
<tr height=16>
<td width=20 align=left>
<br>
</td>
<td width=105 align=left>
<font style=font-size:8pt face="verdana" color=#000000>address</font>
</td>
<td width=373 align=left>
<font style=font-size:9pt face="verdana" color=#000000>59-f, sbi colony, gandhinagar, tirupur 641603</font>
</td>
</tr>
</table>
<table border=0 cellspacing=0 cellpadding=0>
<tr height=16>
<td width=20 align=left>
<br>
</td>
<td width=105 align=left>
<font style=font-size:8pt face="verdana" color=#000000>phone:</font>
</td>
<td width=373 align=left>
<font style=font-size:9pt face="verdana" color=#000000>91-4212-477819</font>
</td>
</tr>
</table>
Like this multiple data in multiple table.
If you want to do this manually, visit the following link and upload your html to the website and it will convert to excel format.
http://www.convertcsv.com/html-table-to-csv.htm
or
To convert an .html file, open it using Excel (File - Open) and then save it as a .xlsx file from Excel (File - Save as).