Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm trying to build a spreadsheet from a few different webpages that have data in a table format.

How do you put data from a web table into Excel?

share|improve this question
add comment

7 Answers

up vote 0 down vote accepted

What you want is a web query. It can be set up to be live (automatically refreshed) or manually refreshed.

In 2003, it's under the Data menu, then Import External Data, New Web Query.

Enter the web address, then find and click on the table to import.

Alternatively, you can copy the static table data. In IE, right-click and Export Table to Excel. In Firefox, you will need an extension like Table2Clipboard.

share|improve this answer
add comment

Easiest thing to do would just to start at the top of the table and end at the bottom.

Copy it and paste it in to a new Excel file, extract the data you require and put it in to the final spreadsheet.

There are a few tricks you may need to do, but excel can understand a wide range of files including web pages, so it should be able to extract the data in a tabular form.

share|improve this answer
add comment

Found a video that explains it for Excel 2000, but Excel 2007 is basically the same.

share|improve this answer
add comment

If you use Internet explorer and have Excel installed, right click on the table and click "Import Into Microsoft Excel".

share|improve this answer
add comment

On Windows with Internet Explorer (versions 6 - 8), I've been able to do this simply by highlighting the entire table, then choosing Edit:Copy (or right-clicking and choosing copy), then pasting into Excel.

On Windows, with Firefox, I can still do it, but it seems a bit trickier -- I feel like I have to highlight a little above the table and a little below it, then trim that in Excel.

I've not even attempted it on Mac, nor with Safari nor Chrome. I imagine in the Windows world, if Safari and Chrome were using the Clipboard correctly, they'd "just work" like Firefox does.

share|improve this answer
add comment

You can take any html file with table, rename it with a "*.xls" extension, and Excel will happily open it up as if it were a native document.

share|improve this answer
add comment

This will sometimes work:

  • Select the web page text in your browser
  • In a blank Excel worksheet, hit Control + A to highlight all columns and rows
  • From the menu, choose Edit > Paste Special and choose unformatted text
  • If it says the areas aren't the same size and shape, tell it to paste anway

If you're lucky, the data will end up in proper columns and rows. You can then re-copy and paste it wherever you want it.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.