Avatar of hermesalpha
Flag for Paraguay asked on

Which is the best solution/setup for synchronizing Excel and Google Sheets, restrict viewing of specific cells and automatic sharing/e-mail notification upon change in cells/columns?

Which is the best solution/setup for synchronizing Excel och Google Sheets, restrict viewing of specific cells and automatic sharing upon change in specific cells/columns/rows (and automatic e-mail notification)?

So far, I've found these possible solutions:

1. For synching (Sync Sheet): http://funbutlearn.com/2013/12/introducing-sync-sheet-sync-ms-excel.html
1. For synching (Sheetgo): https://www.sheetgo.com/import-automatically-data-excel/
1. For synching (G Suite): https://gsuite.google.com/intl/en/
2. For sharing portions of an Excel sheet: http://funbutlearn.com/2017/09/share-portion-sheet-google-spreadsheet.html
3. For automatic sharing and e-mail notification upon change: https://productforums.google.com/forum/#!topic/docs/QyMJDt2ld28

Then there is also Zapier, but I'm not sure where in above it fits in: https://zapier.com/zapbook/google-sheets/

Or would I really not need any other software, just to use MS Excel and Google Sheets?
SpreadsheetsMicrosoft ExcelFile Sharing SoftwareMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon


What does 'och' mean?

Does you mean 'with' or 'and' perhaps?

Sorry if it just a typo, but it looks deliberate as it is in both the title and body of your question, so I am thinking it has some specific meaning in this context?


You are right, it is a typo, Swedish for "and". I was typing in one language but thinking in another. Is there no way I can change this?

No problem - you can't edit it now, but as long as we know, that's fine.

So, when you say you want to synchronise, do you mean that you want to have, say, an Excel file on your hard disk / network drive, and if you make a change to it, the changes automatically synchronise to the Google Spreadsheet, and if you make a change to the Google spreadsheet, it automatically synchronises to the Excel file?

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck

Yes, that was the original idea, but then I saw in Sync Sheet that they use instead the method of clicking a button before synchronizing between local Excel and online Google Sheet. I think this is the best method because then there should be sent an e-mail notification to other persons upon each change in specific fields/rows, and if I am making changes back and forth to test myself, these other persons would get a lot of e-mail notifications for each change I make. The idea with e-mail notifcations is to immediately get the other persons open their synchronized Excel and reply in specific fields/rows whereupon I also get an e-mail notification.

Regarding changing my typo, I tried now to change but it's not possible anymore. Can a moderator help with this?

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: hermesalpha (https:#a42348924)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Experts-Exchange Cleanup Volunteer