Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How do I make an Excel file updated by Zapier viewable and editable in Microsoft Teams?

J

Hello,

I am wondering if Zapier is the right tool for this job.

I currently have it so when a Jotform is submitted, the results populate a row in an Excel file. Is there any way to have this file viewable in Teams, so my co-workers can view, edit, and see updates this Excel file? I currently have it so the Storage Source of my Excel file is in OneNote. I know Sharepoint functionality within Zapier is limited. Wondering what the file path should be to have this Excel file in Teams. Wondering what is the best way for my co-workers to view and edit an Excel file that I have being edited with Zapier. 

 

Thank you and please let me know if you need any more information from me! 

Best answer by SamB

Just circling back in here to share that the Microsoft Excel app on Zapier is now able to access spreadsheets that have been shared with you via Microsoft OneDrive, so the feature request has been closed! 🎉

Hope you have the opportunity to test out this improvement in your Zaps soon. And if anything isn’t working as expected, please share it with the Community here or connect with our Support team directly and we’ll gladly assist further. 

In the meantime, happy Zapping! ⚡

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7922 replies
  • January 29, 2024

Hi there @johnniew. Welcome to the Community! 😁

At the moment it's not possible to access shared Excel files or folders with the Microsoft Excel app unfortunately. I spotted that we have a feature request for this so I've added your vote for that. I can’t make any promises as to whether it’ll definitely be added but if this is something that gets developed we'll sure sure let you know.

In the meantime, I wonder if you could possibly use Microsoft Excel’s workbook linking functionality to automatically add the data the Zap adds to one Excel file, over to another linked Excel file (workbook) that is shared with your co-workers? You can find out more about how to link workbooks here: Create workbook links


I don’t use Excel myself so would love to know whether that workaround does the trick - please keep me updated on whether that does the trick! 🤞

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7922 replies
  • Answer
  • October 30, 2024

Just circling back in here to share that the Microsoft Excel app on Zapier is now able to access spreadsheets that have been shared with you via Microsoft OneDrive, so the feature request has been closed! 🎉

Hope you have the opportunity to test out this improvement in your Zaps soon. And if anything isn’t working as expected, please share it with the Community here or connect with our Support team directly and we’ll gladly assist further. 

In the meantime, happy Zapping! ⚡

Terms & Conditions