Friday, 6 June 2014

Get data from Online to Excel

How to get data from website to Excel2013

Step 1: Open Your Excel sheet
Step 2: Click on Online Search  or FromWeb
If you know the exact address of a particular website then choose FromWeb
Step 3: In  search what data you want choose it by moving the cursor on tabs.
Then click on it.
At the end of page you can choose data where to load like Work sheet or data model
above and below images showing that while we drag cursor on searched items, the data should appear.
From this we can choose what data we want to analyze?

After double click, the data had loaded into work sheet or data model or both based on what option you checked.

No comments:

Post a Comment