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
-
Ultimate Ecommerce Reconciliation
Spread the loveWith 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: … Read more
-
2023 Best Tally TDL to See Party Wise and Product Wise Sale Report
Spread the loveThis 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 … Read more
-
7 Most Innovative Business Ideas (2023) You Can Start with Rs. 1 Lakh | 7 Best Businesses That Can be Started in 1 Lakh
Spread the loveStarting a business can be a daunting task, especially if you don’t have a lot of money to invest. But don’t let that discourage you. You need capital, an idea, and most importantly, the willingness to take risks and make mistakes. If you have the necessary resources, Rs. 1 lakh can be enough … Read more