I need to create a Google Sheets and share it with a set of computers connected to each other via a local network. Those computers are not connected to the internet.

I need a solution in which all the participants can edit the document simultaneously. Therefore I cannot just share a Microsoft Excel file. A magical format which allows simultaneous access and has the spreadsheet features will solve my problem.

  • You could create the spreadsheet in Google and download it to Excel or Open Office format - but you may as well create it locally – John C Aug 3 '12 at 2:09
  • @John: Thanks, but see my edit. – snakile Aug 3 '12 at 7:16

As you're aware, Google won't do the job without an internet connection. Even the offline version of Google Docs only allows local changes, not synced ones.

Perhaps surprisingly, Microsoft's Excel does allow simultaneous editing by a number of people on a local network. It isn't real time like Google, but it does update everytime users save. There are simple instructions on this blog post, the relevant part being:

The workbook needs to be in a network share and it must have a write privilege to all your team members.

  1. Open your workbook.
  2. Navigate to Review on the toolbar
  3. Click on the Share Workbook icon
  4. Place a check on the check box that says Allow more than one user at the same time.
  5. Click on OK
  6. Now, save your workbook on a network share

While far from perfect, if everyone is encouraged to save regularly it might be an alternative for your situation.

  • Future readers will probably benefit from your answer. However, in my case several people have to do simultaneous editing and see all the updates as they're made in real time. – snakile Aug 3 '12 at 12:57
  • @snakile - there doesn't look like there are many (any) spreadsheets that work offline. If you can live with just a text editor there are a number of options listed here: en.wikipedia.org/wiki/… – John C Aug 4 '12 at 3:21

" Is it possible to share a Google Spreadsheet between computers with no internet"

I'm no networking expert, but logic tells me that the only way to do this is to finding a way to share the internet connection with all the five computers (ie giving them internet access.

The other option would be to convert the document to another (ie non google spreadsheet) format that allows simultaneous access. Sorry, but I don't know any format that does that (and I doubt you'll find one).

  • Thanks, but internet connection is out of the question. Your second suggestion (a non-Google spreadsheet) will work if such a thing exists in our universe. – snakile Aug 3 '12 at 10:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.