Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Convert HTML file to Excel or CSV

23 Mar 2014   #1
rundwald

Home Premium 64 bit
 
 
Convert HTML file to Excel or CSV

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>



My System SpecsSystem Spec
.
23 Mar 2014   #2
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 
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!
.
My System SpecsSystem Spec
23 Mar 2014   #3
rundwald

Home Premium 64 bit
 
 

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

23 Mar 2014   #4
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 
Rename a file's extension

Quote   Quote: Originally Posted by rundwald View Post
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


My System SpecsSystem Spec
24 Mar 2014   #5
rundwald

Home Premium 64 bit
 
 

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.
My System SpecsSystem Spec
25 Mar 2014   #6
sffaospark

Windows 7 Ultimate x64
 
 

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
My System SpecsSystem Spec
Reply

 Convert HTML file to Excel or CSV




Thread Tools




Similar help and support threads
Thread Forum
file:// protocol opens html file in Frontpage rather than browser
Here's a strange, and rather annoying bug. I recently installed an upgrade to Cubase (music editing software). In earlier versions, clicking "Help" opened a PDF manual, but now it links to an HTML file on the hard drive (specifically, the link is "file:///C:/Program Files/Steinberg/Cubase...
General Discussion
Macro to convert table to convert table into iCalendar file?
First off, yes I want an iCalendar vs an Outlook calendar file because, heresy of heresies, I prefer Thunderbird to Outlook. http://www.msofficeforums.com/images/smilies/smile.gif Moving on... My work doesn't offer an option to download the weekly schedule as a file, and my schedule changes so...
Microsoft Office
Convert to Excel File
With Office 2010 is it possible to scan a document to your computer and then covert it to an Excel file?
Microsoft Office
I can't open html file in IE
I have new computer, widow 7 64bit, IE 8. I have lots of html files (index.html) but I can't open them in IE, which is my default internet browser. I have to right click it and select open with and choose either Firefox or Google chrome. Why?:( I can open any web site in IE, it is just the...
Browsers & Mail


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 20:45.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App