Convert HTML file to Excel or CSV

rundwald · 23 Mar 2014

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

Code:

<?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 · 23 Mar 2014

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 · 23 Mar 2014

OOps! I meant xml files!

Does that make a difference? Also not sure how to alter file extension!

Callender · 23 Mar 2014

rundwald said:

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:

File Extensions - Hide or Show

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.

Convert HTML file to Excel or CSV-text-import.jpg

rundwald · 24 Mar 2014

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

Code:

<?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 · 25 Mar 2014

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

Convert HTML file to Excel or CSV

Convert HTML file to Excel or CSV

Rename file

Rename a file's extension