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.

I am successfully adding new rows to an Excel spreadsheet for each new Jotform submission…. each field maps over just fine.  The trouble I’m having is that each submission on the Excel spreadsheet skips roughly 10 rows before it writes the next record.  So I have an entry on row 3...then on row 13...23...etc.  How can I have Excel just go to the next row without any blanks?  Is that something with Jotform?  Zapier? Excel?  I don’t know where to start debugging that.

Hi @ika619 

Good question.

Make sure there is no prefilled data in the “blank” rows that would cause the Zap to skip 10 rows before finding the next completely empty row to add data.

Please post screenshots with how your Zap steps are configured in order for us to have more context.

Make sure to reference the available help articles for using Excel in Zaps: https://zapier.com/apps/excel/help

Hmmm so I do have a page break after the Driver Name field in the Jotform you see in the screenshot.  Could that be a problem? 

@ika619 

Can you post screenshots with how the top rows of your Excel are configured?

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Still skipping 10 rows.  See attached.

 

@ika619 

Might be best to open a ticket with Zapier Support for further troubleshooting: https://zapier.com/app/get-help

Hi there, @ika619!

Thanks for reaching out. I can see you were able to open a ticket with my friends in support. They recommended giving this a shot:

In the mapping, it looks like we see empty columns fields all the way at the end. Can you scroll over and see if any cells have a value or formula in them? Or are they perhaps hidden and have a value? Kindly refer to the GIF below:
 
a3062cf4bd1f88c6641e5285cfe0797e.gif
(view larger)
 
A quick way to find out is to print and select fit all columns on the page for scaling. If it is too small, there is probably something over there.
 
Also, if you removed the rows while the Zap was turned on, we have been keeping track of where the next row needs to be added. To fix this, turn the Zap off, then make any changes you want in the spreadsheet. So, if you're going to move those rows down and start them at row 1, now is when you would like to do that. 
 
Then, turn the Zap back on. We will check the spreadsheet, find the next empty row, and keep track again.

If that doesn’t do the trick, I’d recommend continuing to troubleshoot support to get to the bottom of this! 

Keep us posted. 🙂

Terms & Conditions