Open and edit *.gsheet file in excel

Question

I have downloaded "Google Drive" application to my Windows 7 Ultimate Machine.

Now When I go to the folder and see my spreadsheet it is in some weird format called "*.gsheet". Now this file is not being opened by Excel(As if I need to mention that!!)

Now I want a solution, Such that:

1. Either the file is stored as a normal *.xlsx or *.odf file so that I can edit whenever I want to and as soon as I am done, The file will be synced to my drive immediately.(I have an internet connection of course)

2. Or A software that can open this kind of file and give the same kind of functionality(it is alright if it is slightly less than excel.) as excel.

Please help me with this issue.

Answer 1

I opened a ticket by Google for a similar issue. The thing is Google has no serious procedure to deal with that... So what I can advise you best, is for your option 2)

Then you will be able to open your synchronized *.gsheet file with your Chrome browser when you will be offline.

To do this, you have to perform two procedures :

1. Follow this procedure to turn on Google Drive offline

2. Enable each gsheet file to be available offline (I know it's weird and boring to do it for each file). =>

   To do this second procedure, you have to go to GoogleSheet docs.google.com/spreadsheets/. It will list all your gsheet files. Then click on the ... (three dot) on the right hand side of one file, and tick "available offline". Repeat this for every of your gsheet files.

Then reboot your PC and disconnect from Internet. Double click you *.gsheet file. It should open Chrome and let you update your file. The next time you'r connected to Internet, it will update it on GDrive.

Oh ! One more thing... If you have several computers, you'll have to repeat both procedure for each device...