Wild Web Widget - SQL Table Query

SQL Table Query

Widget Function: Extract column data from an HTML table.

If you've tried to copy just one column of data from a table you know what a pain it is. It's a snap with this tool. You can then import the data into a database. You choose what columns to display. You may also specify a search string to choose the rows to display. You may have trouble with nested tables. Sometimes what looks like a single table is actually inside other tables. Most web pages use tables to format layout but have borders turned off so it is hard to tell. If you ever need to get data from a table, remember this widget!

Browser Requirements: Any
Notes & Tips:
If you know SQL, you can think of it as running an SQL query on an HTML table.
This widget is designed for flat tables. Tables within tables and colspans will give undefined results.

Example input

Example output

Title	Access Via	Start	End	Subject Area
Jahrbuch der Kunsthistorischen Sammlungen in Wien	FirstSearch (WilsonSelect)	January 1997	Current	Humanities and Social Science
JAMA, The Journal of the American Medical Association	IAC Academic	January 1991	Current	Science and Mathematics
Japan Chemical Week	Business & Industry	October 1994	Current	Business
Jewelers Circular Keystone	IAC Business	January 1989	Current	Business
Jewelers' Circular-Keystone	Business & Industry	January 1995	Current	Business
Jewellery News Asia	Business & Industry	May 1998	Current	Business
JMR, Journal of Marketing Research	UMI (ABI Inform)	November 1995	Current	Business
Job Safety and Health Quarterly	FirstSearch (WilsonSelect)	January 1998	Current	Humanities and Social Science
JOPERD--The Journal of Physical Education, Recreation&Dance	IAC Academic	January 1993	Current	Humanities and Social Science
Journal for Quality and Participation, The	UMI (ABI Inform)	January 1992	Current	Humanities and Social Science, Business
Journal for Research in Mathematics Education	FirstSearch (WilsonSelect)	January 1996	Current	Education

Jewelers Circular Keystone	IAC Business
Jewelers' Circular-Keystone	Business & Industry
Jewellery News Asia	Business & Industry

Return data in text format.
Field separator.
Choose what columns to display and their display order:

Choose rows where column contains

use regular expressions

Enter the website address:

[Home][About][Contact][Resources][Newsletter][Forum][Login]