Convert HTML file to Excel or CSV

[rundwald]

Hi there! Can anyone direct me to a way to convert HTML files to Excel or CSV, freeware o ron-line? Please!

Here's a short example of the files' contents

<?xml version="1.0" encoding="UTF-8"?>

-<CRC>


+<Sample Number="0">


-<Sample Number="1">

<Time>20/03/2014 11:02:42</Time>

<Downstream>0.0</Downstream>

<Upstream>0.0</Upstream>

<DrawBlank>False</DrawBlank>

</Sample>


-<Sample Number="2">

<Time>20/03/2014 11:03:42</Time>

<Downstream>0.0</Downstream>

<Upstream>0.0</Upstream>

<DrawBlank>False</DrawBlank>

</Sample>


-<Sample Number="3">

<Time>20/03/2014 11:04:42</Time>

<Downstream>0.0</Downstream>

<Upstream>0.0</Upstream>

<DrawBlank>False</DrawBlank>

</Sample>


-<Sample Number="4">

<Time>20/03/2014 11:05:42</Time>

<Downstream>0.0</Downstream>

<Upstream>0.0</Upstream>

<DrawBlank>False</DrawBlank>

 

[Callender]

Rename file

On my machine all that's required is to rename a copy of the .html file with the .csv extension.

I say a "copy" so that you're not changing the properties of the original file!

Default software for reading html files on my machine is Cyberfox 64 bit.

Default software for reading csv files on my machine is SoftMaker FreeOffice (Planmaker)

I have other browsers and office suites that can handle the same files!
.

 

[rundwald]

OOps! I meant xml files! Does that make a difference? Also not sure how to alter file extension!

 

[Callender]

Rename a file's extension

OOps! I meant xml files! Does that make a difference? Also not sure how to alter file extension!

The same works for xml files on my machine/

First you need to have file extensions shown (if they are not already set to be shown). Here's how:

http://www.sevenforums.com/tutorials/10570-file-extensions-hide-show.html

Then make a copy of your .xml file and rename the copy.

Let's suppose that the original is named test.xml - right click the file and choose rename then delete everything after the dot and replace xml with csv so the new file will be named test.csv

Open the new file with your office program that can handle csv files - usually your spreadheet application.

If you're lucky enough to see a preview window try different options until you get the display details that you require.

 

[rundwald]

I tried the advised method, but the output was such that it could not be set in columns e.g. date, time, downsstrem

<?xml version="1.0" encoding="utf-8"?>
<CRC>
  <Sample Number="0">
    <Time>22/03/2014 08:46:19</Time>
    <Downstream>1.0</Downstream>


    <Upstream>0.0</Upstream>
    <DrawBlank>False</DrawBlank>
  </Sample>
  <Sample Number="1">
    <Time>22/03/2014 08:47:19</Time>
    <Downstream>0.0</Downstream>
    <Upstream>0.0</Upstream>
    <DrawBlank>False</DrawBlank>

Finally I found an online converter, that produced columnar output as text, so all is OK now.

 

[sffaospark]

i think the discontinued MS expression web can handle that (i think the installer is still available )
all you need to do is save the html to xml then right click to see if your xml is well formed

if it... then save it and open the file to excel