Need to convert HTML tables to CSV file

I need a program to convert html tables into a csv file for conversion into an sql server table. i've seen on program but it was written in VB 3 or something. Has anyone come across anything like that?

Dinesh
dprasadAsked:
Who is Participating?
 
Jaime OlivaresConnect With a Mentor Software ArchitectCommented:
Which language do you prefer?
Here is an example in Perl:
http://www.experts-exchange.com/Programming/Programming_Languages/Perl/Q_20287078.html
And here is another:
http://www.coscorrosa.com/programs/cgi/html2csv/html2csv.pl

I guess it will be easy to translate to PHP or ASP.
0
 
TILLCommented:
You can use Excel, with Web Import feature. Is the easyest way.
0
 
dprasadAuthor Commented:
TIll, I'm using excel 2000, I dont see a web import feature. I tried to open it directly, and also tried pasting as html and text. when i do that, it puts everything in one column on the csv files. how should i do this?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
TILLConnect With a Mentor Commented:
From Excel menu, go to Data-> Import External Data ->New Web Query.
0
 
dprasadAuthor Commented:
I can find a newer copy, Ill try it with that
0
 
TILLCommented:
When you go to WebQuery you have to enter an URL which can be an internet adress or a local file. You the html file is stored locally, you can enter the URL like file:///c:\test.html
After that, the WebQuery Dialog will show you all the tables that you gave in that HTML file. All you have to do is select de right table, click ok and choose the drpoint of your table. And voila... the document is ready. After that you save it as csv and you're ready to go.;)

Best of luck with that.
TILL
0
 
dprasadAuthor Commented:
OK, I got office XP. It works, but because of the way the data is set up in the tables, I don't get it in the right format.
The problem is, on the web page, the data is set up like this
Name:  1999 Cayuse Walla Walla Valley Syrah

Vintage: 1999
Style: Syrah
Vineyard:
Region: Walla Walla, Washington
Description:  blah blah
blah
Size: .750/ml  Qty Available: 3
Store: A Wine Store Washington

with a price in a new column on the right. Also, the description field is variable length. So in excel, everything shows up in the first column. do you know how i could put each data element in its own column without copying and pasting each one? I have about 1,000 of these to put in
0
 
dprasadAuthor Commented:
Jaime: I tried running the 2nd perl script you listed. I have lvery limited knowledge in perl, but i can get them to work. I'm seeing the program run and display the information to the screen. But how do i get access to the tables converted into a csv file? whats the command line syntax? Thanks!

Dinesh
0
 
Jaime OlivaresSoftware ArchitectCommented:
Just use "Save as..."
0
 
dprasadAuthor Commented:
I dont understand, how do I do save as when I run the script?
0
 
Jaime OlivaresSoftware ArchitectCommented:
I can't run the script right now, but if you see results in a web browser, just save page as .txt file (changing to .csv extension)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.