Is it possible to link a google sheet and an excel sheet if they are both stored in google drive? I’ve started setting up a Zap, but it looks like the Excel spreadsheet needs to be stored in OneDrive, which I don’t use and don’t want to use!
Best answer
Link Google Sheet with Excel spreadsheet, both in Google Drive?
- Beginner
Best answer by christina.d
Thanks for sharing your ultimate solution with us,
You’re right that to update an Excel spreadsheet, you need to do it through a Microsoft OneDrive account…
To be honest, what I will probably do is use excel’s native ability to connect to external sources and connect to the google sheet this way.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+12- Zapier Staff
Hi
You’re right that to update an Excel spreadsheet, you need to do it through a Microsoft OneDrive account, sorry about that! Is there a reason that you need to keep the sheet as an Excel sheet and haven’t converted it to a Google Sheet? Maybe we can find you a workaround here! 😁
- Beginner
Hi, thanks for your reply. The excel sheet contains a lot of VBA macros and has taken years to build, converting it to a Google Sheet isn’t feasible unfortunately. Perhaps a solution is to have a ‘middle man’ excel sheet in OneDrive and link that to my main Excel sheet.
+9- Zapier Staff
Hey there
You could utilize an Excel sheet in OneDrive! I’m curious how you’re thinking to link this back to the Excel sheet being stored in Google Drive?
Let us know and we’ll keep brain storming! 🙂
- Beginner
Hi Christina, I would just have both the OneDrive and Google Drive spreadsheets sync’d to the hard drive on my computer and then use native excel function to refer cells on one spreadsheet to the other. No an elegant solution though, and dependant on my computer being on.
To be honest, what I will probably do is use excel’s native ability to connect to external sources and connect to the google sheet this way.
+9- Zapier Staff
- Answer
Thanks for sharing your ultimate solution with us,
You’re right that to update an Excel spreadsheet, you need to do it through a Microsoft OneDrive account…
To be honest, what I will probably do is use excel’s native ability to connect to external sources and connect to the google sheet this way.
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.