Yahoo! Finance offers financial statements for many companies. Although the financial statements are formatted similar to Microsoft Excel documents and look like spreadsheets online, Yahoo! Finance does not offer any means of transferring the information into Excel. Copy and pasting the entire page in a single shot can cause weird formatting in Excel, and manually copy and pasting each cell can take a long time. To get the information in an Excel document efficiently, you can use Excel's Web query tool to import the data from the Internet.
-
1.
Open the Yahoo! Finance financial statement in your Internet browser.
-
2.
Copy the link to the financial statement. You can highlight it, right-click and select "Copy," or highlight it and press "Control" and "C."
-
3.
Open a new Excel document.
-
4.
Click "Data," then "Import External Data." Then select "New Web Query."
-
5.
Paste the link in the Address box. The Yahoo! Finance financial statement page appears underneath it.
-
6.
Click "Import." Strange characters and codes initially appear in each of the cells, but as the program imports the data, it appears in the spreadsheet.
-
7.
Click "File," "Save."
