Skip to main content
Question

How can I add new columns to an Excel file with Zapier?

  • 5 July 2024
  • 2 replies
  • 13 views

Hi, is it possible to add a new column to a excell file? I’ve see some people try to do this with Google Sheets but I don’t see any action to do this - only - add rows.

 

Thanks in advance,

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

2 replies

JammerS
Userlevel 7
Badge +5

Hi @include007,

 

Currently, Zapier does not support directly adding a new column in Excel or Google Sheets. Zapier's Excel integrations primarily support adding a new row, finding a row, or updating a row.

 

However, there is a workaround for this by using "Code by Zapier to run a script that adds a column to your Excel file. This would require coding knowledge and a location where a script like OneDrive or Google Drive can access your Excel file.

 

I hope this helps. Let me know if you have any other questions!

I

Hi @JammerS - thanks for your reply. That’s a very good alternative which might be better in fact. I want to add a new column to the end of the table and populate it with some pre-defined values. I’ve achieved that with Python/Pandas. I am going to test it. Thanks again :)

Terms & Conditions