How can I export an HTML document to an excel sheet?

Hi

I have an HTML document , that I want to know if it possible to export it in an excel sheet in columns

the .txt file has about 300 records like those
------------------------------------------------------------------------
<city>10 th Of RAMADAN CITY</city>
<category>unclassfied</category>
<hotel_name>MERITTA HOTEL</hotel_name>
<address>10 th OF RAMADAN CITY</address>
<owner_name>MASHHOUR GOUDA EL SAHAR & CO.</owner_name>
<operator_name>MASHHOUR GOUDA EL SAHAR & CO.</operator_name>
<manager>MASHHOUR GOUDA EL SAHAR</manager>
<tel1>015363120</tel1>
<tel2>015363850</tel2>
<tel3>-</tel3>
<email>-</email>
<fax>015376777</fax>
<total_rooms>34</total_rooms>
<total_beds>68</total_beds>


-------------------------------------------------------------

what i want is to create an excel file with the details in this document so that the BLUE items is the name of the cell, and the RED record is what is under the name of the cell

so it can be like that

category ---------- hotel_name ----------- address

unclassfied ------ MERITTA HOTEL -------- 10 th OF RAMADAN CITY



is there a way to do it?

 

Did you try to open the HTML/XML file from the excel directly? I think excel supports html and xml format.

 

i tried but it didnt work is there any other way?

 

http://www.forgram.com/

Check that out. No idea if it will work.

 

Thanks , it worked and the first method also should work with this add in

Thanks