How to Import Stock Prices into Excel from Google Finance (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will show you 3 methods of how to import Stock Prices into Excel from Google Finance. We’ll use the data from NASDAQ for Microsoft Corporation (MSFT) to demonstrate our steps. This is what our final step will look like after importing it to Excel.

how to import stock prices into excel from google finance (Copy Paste)


Download Practice Workbook


3 Methods to Import Stock Prices into Excel from Google Finance

Method-1. Import Stock Prices from Google Finance from Web

For the first method, we’re going to import Stock Prices data from Google Finance to Google Sheets using the GOOGLEFINANCE function. Then, we’ll import that into Excel using Power Query.

Step 1: Import Stock Prices from Google Finance to Google Sheets

Now, we’ll use Google Sheets to obtain Stock Prices from Google Finance.

  • Firstly, from Google Sheets and open a new file.
  • Secondly, type the following formula in cell A1.
=GOOGLEFINANCE("MSFT","all","5/8/2022","5/17/2022","Daily")

Formula Breakdown

  • Firstly, “MSFT” stands for Microsoft Corp.
  • Secondly, we’ve put “all” in the second argument. This will return the following things for the specified date range –
    • Opening Prices.
    • Closing Prices.
    • High Prices.
    • Low Prices.
    • Share Volumes.
  • Thirdly, we’ve specified the date range from “8-May-2022” to “17-May-2022”.
  • Finally, we’ve defined the frequency as “Daily”.

Google Sheets: how to import stock prices into excel from google finance

  • Thirdly, press ENTER.

Thus, we’ll import Stock Prices into Google Sheets.

Step 2: Publishing the Google Finance Stock Prices Data

In this step, we’ll share the file online using the Share feature.

  • Firstly, from File >>> Share >>> select “Publish to web”.

Publishing: how to import stock prices into excel from google finance

A dialog box will appear.

  • Secondly, click on the Publish button.

  • Finally, press CTRL + C to copy the link.

Link Sharing: how to import stock prices into excel from google finance

Step 3: Importing the Stock Prices into Excel

In this step, we’ll import that dataset into our Excel file.

  • Firstly, open an Excel file and from the Data tab >>> select From Web.

A dialog box will appear.

  • Secondly, Paste the link address inside the URL box and press OK.

Import Data from Web: how to import stock prices into excel from google finance

  • Thirdly, select Table 0 and press Transform Data.

how to import stock prices into excel from google finance

It will import our Stock Prices into Excel Power Query.

Step 4: Modifying the Stock Prices Inside Power Query

Now, we’ll format the imported dataset inside the Power Query Editor of Excel.

  • Firstly, select the first two columns and select Remove Columns.

Power Query: how to import stock prices into excel from google finance

  • Secondly, select “Use First Row as Headers” to get rid of the first row.

Our data of Stock Prices look much cleaner now.

how to import stock prices into excel from google finance Power Query

  • Finally, we’ll import this to Excel by pressing Close & Load from the Home tab.

This is what the final step should look like. Thus, we’ve successfully imported Stock Prices into Excel from Google Finance.

Imported how to import stock prices into excel from google finance

Step 5: Updating the Stock Prices

Here, we’ll update the values in Excel when we edit our online file. If we make any changes to the Google Sheets file, then our data will change too.

  • Firstly, change the formula on cell A1 as follows.
=GOOGLEFINANCE("MSFT","all","5/8/2022","5/20/2022","Daily")

Here, we’ve added 3 new rows to the dataset.

  • Secondly, select anywhere in the “Table0”.
  • Finally, from the Query tab >>> select Refresh.

Data Refreshed how to import stock prices into excel from google finance

This will update our dataset. In conclusion, we’ve updated the dataset as per the original Google Sheets file.

Read More: How Do You Automatically Update Stock Prices in Excel (3 Easy Methods)


Method-2. Use of Copy and Paste Feature to Import Stock Prices into Excel from Google Finance

For this, we’ll copy the data from the original file and Paste it into our Excel file.

Steps:

  • Firstly, follow the steps of Method-1 to import Stock Prices from Google Finance to Google Sheets.
  • Secondly, select the cell range A1:F10.
  • Thirdly, press CTRL + C to copy the dataset.

how to import stock prices into excel from google finance Google Sheets

  • Next, Right Click on cell B4 to bring up the Context Menu.
  • Then, select “Match Destination Formatting” from Paste Options.

Thus, we’ll import Stock Prices into Excel.

how to import stock prices into excel from google finance (Copy Paste)


Method-3. Using Download Option to Import Stock Prices from Google Finance

We can download the Google Sheets file as xlsx, and then import it into our Excel file to achieve our goal.

Steps:

  • Firstly, follow the steps of Method-1 to import Stock Prices from Google Finance to Google Sheets
  • Secondly, from File >>> Download >>> select “Microsoft Excel (.xlsx)”.

Then, we’ll download the file.

  • Secondly, Open the file.

how to import stock prices into excel from google finance (Dowloaded as xlsx)

  • Finally, import the dataset into our Excel file.

In conclusion, we’ve shown steps for importing Stock Prices into Excel.

Read More: How to Get Live Stock Prices in Excel (4 Easy Ways)


Conclusion

We’ve shown you 3 methods of how to import stock prices into Excel from Google Finance. If you have any questions, feel free to comment below. Moreover, you can visit Exceldemy for more Excel-related articles. Thanks for reading, keep excelling!


Related Articles

Rafiul Haq

Rafiul Haq

Greetings! I am Rafiul, an experienced professional with an engineering degree and an MBA in finance. Data analysis is my passion, and I find Excel to be an invaluable tool in this domain. My goal is to simplify complex concepts by providing comprehensive and user-friendly guides on Excel and finance topics, aiming to enhance people's productivity and understanding at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo