Skip to main content
Best answer

Possible to create Excel spreadsheet from template?

  • February 13, 2022
  • 3 replies
  • 407 views

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

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @AtomicVentures 

Try this…

  1. Trigger: ???
  2. Action: OneDrive - Find File
  3. Action: OneDrive - Upload File (map File from Step 2)
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.

3 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31340 replies
  • Answer
  • February 13, 2022

Hi @AtomicVentures 

Try this…

  1. Trigger: ???
  2. Action: OneDrive - Find File
  3. Action: OneDrive - Upload File (map File from Step 2)

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
Forum|alt.badge.img+14
  • Zapier Expert
  • 31340 replies
  • February 13, 2022

@AtomicVentures 

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