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 Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
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 keep losing html file association
Every so often I see a post where people want to break up the link between the .html file and its associated "xxxxfiles" folder that constitutes a saved web page. Me, I want to KEEP the association but can't. Every time I reboot and every few hours I have to reset the association. There was...
General Discussion
HTML / HML File associations in XP
Hi guys.. I've tried everything fixing this issue,now i'm out. Please assist. My issue is on an xp machine using office 2007, The user can't click on any links that gets mailed to her. I've tried the HTML/H ML reg fix attached but to no avail. I've ran office diagnostics but it found no problem....
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
Html & htm file icon missed
Hello everybody, When I set Chrome as my default browser I lose the icon of htm & html file types. However, in another computer where Chrome is the default browser, I do not have this problem. Iíve done everything I found online but still nothing happened. In the registry the...
General Discussion
how to use Notepad++ to view html file
without all those codes? thank you very much.
Software


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 19:43.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App