Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Open and edit *.gsheet file in excel

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.

like image 881
IcyFlame Avatar asked Aug 15 '13 08:08

IcyFlame


People also ask

How do I open a gsheet file?

Open GSHEET file. Link to Google Sheets web application spreadsheet document. Files with gsheet file extension are URL links to a spreadsheet created in Google Drive. It is not the actual spreadsheet, just an URL link. You can download the spreadsheet from Google Drive in more typical format, like *.xlsx or *.ods.

How to open and edit Google Sheets files?

These files can only be opened using a web browser and edited on Google on-line Sheets web application. It will launch the on-line spreadsheet editor (similar like Microsoft Excel) in your web browser.

How to edit&download Excel spreadsheet?

Click the 'Create New' button, a new Excel Spreadsheet will be rendered for you to edit & download instantly. Click inside the file drop area to upload one Excel file or drag & drop one Excel file. Click the 'Edit Now' button, the uploaded Excel file will be rendered for you to view, edit & download instantly.

Can I download a Google Sheet as an Excel file?

Fortunately, Google Sheets makes it easy to download a spreadsheet as an Excel file or in other formats Here are step-by-step instructions for how to download and open a Google Sheet in Excel. Black Friday deals: see all the best offers right now!


1 Answers

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

like image 130
Douglas Avatar answered Sep 24 '22 06:09

Douglas