Use LWP::Simple to download the html file, assuming you need to.

Then use HTML::TableExtract to extract the table data. If that's insufficient, then you can also use heavier parsers like HTML::Parser.

- Miller

I prefer to use HTML::TreeBuilder. For example, this code will pull out the table on the PerlMonks home page that lists the currently logged in users:

use 5.010;
use warnings;
use strict;
use HTML::TreeBuilder;
use LWP::UserAgent;

my $ua = LWP::UserAgent->new;
my $fetch_result = $ua->get("http://www.perlmonks.org");
my $tree = HTML::TreeBuilder->new_from_content($fetch_result->content)
+;

my $nodelet_table = $tree->look_down( '_tag' => 'table', 'id'=>'nodele
+t_container' );
my $other_users_cell = $nodelet_table->look_down('id'=>'Other_Users');

my @other_users_list = $other_users_cell->look_down('_tag'=>'li');

print "User logged into PerlMonks:\n";

foreach my $user_element ( @other_users_list )
{
    print "\t".$user_element->as_text."\n";
}
[download]

thanks chrestomanci !!! i'm feeling lucky :)

Use HTML::TreeBuilder to export your HTML into a perl data structure. use Data::Dumper to figure out how that structure looks and where in the whole structure the table you desire resides. Access the Table from the above information.

I can offer a non-perlish suggestion. Open the HTML file in IE, right click on the table and click on "Export to Microsoft Excel". I assume you are on Windows.