Share via

Google Sheets live connection to Excel File - Microsoft Home and Business 2021

Anonymous
2023-03-28T04:05:58+00:00

Hi,

I am currently using a Microsoft Home and Business 2021. I want to create a live-connection from Google Sheet (3 sheets in 1 file) to Excel. The steps I took are:

  1. Create a spreadsheet in google sheet
  2. Share button at the top right corner
  3. In the pop-up click the Copy Link
  4. Open an excel file -> get data ->from web -> paste the link
  5. Replace the last part of the link: export?format=xlsx
  6. The output remains an HTML in power query

How do I get a result with the actual table?

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-28T07:28:52+00:00

    Be sure the step2 is share to Anyone.

    The link format should be like this:

    https://docs.google.com/spreadsheets/d/1aMCWIFqV8Gw37eBc6PLTkGUnX3R0iGWB9VYrz7Yt0EU/export?format=xlsx

    You can check this article.

    Power Query / Get & Transform – Get data from Google - Microsoft Community

    Best Regards,

    Snow Lu

    6 people found this answer helpful.
    0 comments