Breaking

Excel2Tally-Ultimate_Ecommerce | Import E-Commerce Data into Tally and file GST on time | Best E commerce data import software

  This  is Excel to Tally Ultimate E commerce Automation to Import your E-Commerce Data Entry into Tally with Easy and quick way. With this...

Monday, 4 July 2022

Simple Way to Connect Goolge Sheet with Excel | Google Sheet to Microsoft Excel Live Data Connection | Excel Power BI to Connect Google Sheet

 


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.:

1. Goto Google Sheet


2. Open Document That want to import in Excel



3. Click on Share


4. Choose anyone with the link and copy link:


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


6. Paste URL that you copied from Google Sheet:
    

7. 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) 


8. 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 the above video for more details.












No comments:

Post a Comment