Skip to main content
Question

Why does Zap display data row number one higher than actual placement in Microsoft Excel?

  • October 15, 2024
  • 3 replies
  • 32 views

Forum|alt.badge.img+1

This works fine except for the data out displays the row number one more than where the data was placed. No Special characters are used in the Excel sheet headers, There are no hidden columns or rows and no other data in the spreadsheet except for the headers. I test the Zap and the data gets placed in row 2. But the data out Zap info displays the the row number as row 3. What could be causing this?

 

 

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 15, 2024

Hi @Jstimac 

Try turning your Zap ON and testing live.

Check your Zap Runs history details to see the DATA IN/OUT for each step to help you troubleshoot: https://zapier.com/app/history/


Forum|alt.badge.img+1
  • Author
  • Beginner
  • October 15, 2024

Turned it on and submitted a new entry in Cognito Forms. Entry data was added to row 2, Data out in my Zap history is showing it as added to Row 3.

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 15, 2024

@Jstimac 

You can try opening a ticket with Zapier Support for them to dig deeper into the Excel integration: https://zapier.com/app/get-help