About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

Possible to create Excel spreadsheet from template?

  • 13 February 2022
  • 3 replies
  • 261 views
A
Userlevel 1

It would be awesome to have zapier create an excel sheet from a template so validation and formatting carries over.

icon

Best answer by Troy Tessalone 13 February 2022, 17:26

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @AtomicVentures 

Try this…

  1. Trigger: ???
  2. Action: OneDrive - Find File
  3. Action: OneDrive - Upload File (map File from Step 2)
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A
Userlevel 1

I'm really close to getting that to work it seems however when i go back to drive to open it, i get an error saying “This workbook couldn't be opened because the file format may not be matching with the file extension.” even though i have it set to save as the same type of file extension.

 

Nevermind got it! For some reason when I set it up it was Pulling just the excel files name into a .csv i needed to check the file(Exists but not shown) box. Thanks for your help @Troy Tessalone 

Troy Tessalone
Userlevel 7
Badge +14

@AtomicVentures 

Please post screenshots with how each of your Zap steps are configured, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions