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

Website form to Excel - only allows me 3 fields and I can't choose which ones

  • 5 September 2023
  • 3 replies
  • 38 views
freezedriedusa
Userlevel 1

My first zap…

I have a zap that is successfully being triggered when someone submits a form from our website, and successfully taking some of the data from the form and entering it into a new row in an excel spreadsheet.

That’s all good, except when I set up the excel part, it only gives me 3 items from the form submission to use, and I can’t even choose which items I want to add to excel. It’s for tracking batches of products we produce, and I want to track how many packages per day/week/month/year are being produced. That quantity is being received by the zap, but where it lists the data to enter, I only get 3 choices, and none of them are the quantity. 

I’m sure I’m missing something, but I don’t see a way to modify which items from the form submission are passed onto excel. 

Help. 

icon

Best answer by ken.a 5 September 2023, 08:26

View original

3 replies

ken.a
Userlevel 7
Badge +6

Hi there @freezedriedusa,

Welcome to the Community! 🎉

You will need to setup your Excel spreadsheet in a certain way for you to be able to map your data to the Microsoft Excel action step.

You can read more on how to setup your Microsoft Excel spreadsheet here: https://help.zapier.com/hc/en-us/articles/8496044256909-How-to-Setup-Your-Microsoft-Excel-sheet-to-Work-With-Zapier

Hopefully, this helps! 😊

freezedriedusa
Userlevel 1

It’s working. Thank you! 

SamB
Rank
Userlevel 7
Badge +11

Glad to hear it, @freezedriedusa! 🎉🎉🎉

Thanks so much for letting us know! We really appreciate you taking the time to come back here and confirm that Ken’s recommendation did the trick. 🤗

If we can assist with anything else Zap-related in future just let us know - the Community is always here and willing to help!

Reply


Terms & Conditions