Friends when have multiple branches or have offices on different locations, or want to work multiple people on same project or sheet. Then we simply use google sheet. In single google sheet many people can work from different computers. But sometime we need to handle it with Microsoft Excel and want to create reports according to our need. Same we can set and import Google sheet data into excel. And also can excess it live.
So let’s see how can import google sheet data into Excel and use live.:
- Goto Google Sheet

- Open Document That want to import in Excel

- Click on Share

- Choose anyone with the link and copy link:

- Now Open Excel – Goto Data – New query – From Other Source – From Web

- Paste URL that you copied from Google Sheet:

- Now do some changes in URL:
Example
Copied URL from Google Sheet:
https://docs.google.com/spreadsheets/d/1HcvrFNi8hV0G_Rytj7fkjrYDUIIZsALvImSd7AcEg/edit?usp=sharing
New URL after Changes:
https://docs.google.com/spreadsheets/d/1HcvrFNi8hV0G_Rytj7fkjrYDUIIZsALvImSd7AcEg/export?format=xlsx
(Changes : edit to export , usp to format, sharing to xlsx)
- Click on Sheet and Click on Load

Wait for some time . Now our google sheet will be loaded in Excel
We can refresh to fetch new changes.
Watch Above video for more details
-
2023 Best Trick to Create Own Unlimited High Quality AI images
With this trick we will create Unlimited High Quality AI images, with the help of google colab. Artificial intelligence (AI) has revolutionized the way we create and consume content. With the help of AI, it is now possible to create unlimited high-quality images in a matter of minutes. In this blog post, we will show…
-
Ultimate Ecommerce Reconciliation
With this automatic Ultimate Ecommerce Reconciliation utility we can reconcile all type E-commerce platforms (Amazon, Flipkart, Meesho, Myntra etc.) sales with there payments. We can reconcile all data order wise and stock item wise with one click. Also try Excel to Tally Ultimate Ecommerce Import This Ultimate Ecommerce Reconciliation utility has below features: Other benefits…
-
2023 Best Tally TDL to See Party Wise and Product Wise Sale Report
This Tally TDL to See Party Wise and Product Wise Sale Report will help to see which item you sold more and which item you sold less. And same also can see which customer buy which items more and which customer buy which item less. We all know Tally is a popular accounting software used…