Excel equivalent to Google Sheets' "importdata" function?

G

greesonbrad

New Member
Joined
Oct 17, 2014
Messages
3
Hello,


I want to pull some financial data from a website. Google Sheets has a fantastic function for grabbing data from tables. In my example, I want to pull the balance sheet for a specific company. Here is a link to the Google Sheets' example


Is there an Excel equivalent? I tried getting external data, but it does not allow for a variable web address, so I would be limited to only one stock...not desirable.


Is there a macro for doing such table grabbing?


Thanks for any help!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You must log in or register to reply here.

Similar threads

G
  • Question
Scrape Data From Google with VBA or Excel
Replies
0
Views
407
Grant22
G
D
  • Question
Cannot read google excel sheet
Replies
6
Views
252
DeepButi
D
P
  • Question
How to use a MATCH helper column containing rows from a different sheet and INDEX in an array formula to return based on data in the helper column?
Replies
0
Views
150
purekarting
P
J
  • Question
Problems with excel import data from website
Replies
2
Views
396
alansidman
A
A
  • Question
Import Table Data from Web using VBA to excel Worksheet and able to input Values which can modify the web data to be extract
Replies
0
Views
346
Ambrosia
A

Forum statistics

Threads
1,214,641
Messages
6,120,694
Members
448,979
Latest member
DET4492

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top