Tech Tock

Time is of the essence.

Tables to Go

FireFox add-on OutWit Hub is great for exporting tables from the web into Excel.  It has a few quirks, but follow these directions and you’ll get good results:

After installing, you’ll get a new icon in FireFox:

image

Navigate to a page with tables and click the W button next to the address bar.

Highlight “tables” in the tree list on the left:

image

Click into the data panel at right and select all (ctl-A):

image

Right click and select Export Selection As CSV:

image

This will make a file that will open with proper columns and rows in excel.

Many other menu items, like copy cells and export to excel didn’t get excel friendly data for me, but knowing the above makes this a valuable tool.

Advertisements

January 28, 2010 - Posted by | Uncategorized |

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: