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
-
Free Excel to Tally
Tally XML Converter Use Excel,Text,CSV etc file. Columns should be same as Templates. Paste Data-Choose XML Type-Click on Create File and Download. Paste XML file path in Tally Import to Create Entry. Click for Learning Videos LEARNWELL VIDEO. Create file
-
PHP
Import Data into Tally Import Data into Tally Excel File:
-
e2t
