Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Adewonuola has attended:
Excel Advanced course

Excel

how do I import data from a website to excel.

RE: excel

Hello Adewonuola

Thank you for your question and welcome to the forum.

To import data from a table on a web page into Excel:

1. Go to Data - Import External Data - New Web Query.
2. A mini Internet Explorer window opens on your screen.
3. Go to the web page you wish to import data from.
4. Click on the arrow (in the yellow box) that points at the data you wish to import.
5. Click Import
6. Select where you want the imported data to start from in your spreadsheet (only select one cell). If you wish, use the Properties button to set things like how often the data will refresh.
7. Click OK. It will take a few seconds before the data appears in Excel.

Kind regards
Amanda

Fri 3 Apr 2009: Automatically marked as resolved.

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.