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.

  • Home
  • Get Help
  • How Do I
  • Move certain columns from CSV file to new Google Sheet (or remove from original CSV)

Hi there everyone!

 

Is there a way to move select columns from a CSV file into a Google Sheet? Alternatively, can you remove that data from the CSV file altogether using Zapier?

 

I saw a post here about cleaning up an Excel file and the answer was that it can’t be done: 

 

However, an acceptable workaround would be to somehow move the data from specific, desired columns into a new CSV file (or Google Sheet). 

 

So far this is what I’ve accomplished (which I’m sure is not impressive to all the Zap experts out there lol):

 

  1. Trigger: New File in Folder in Google Drive
  1. Action: Format (Utilities) - Import CSV file
    • I’m getting output and line items
  2. This is as far as I’ve gotten. Not familiar with all the options available from here, but I’m sort of assuming it’s another “Format (Utilities)” thing. Just not sure how to do that.

 

Any ideas? Any help appreciated!

 

*Bonus I am looking to filter out line items from a specific column too, but I think that is a separate question and I’m sure there are resources out there for that*

Hi @magicmiles 

 

Is there a way to move select columns from a CSV file into a Google Sheet?

Check out this help article about using CSVs in Zaps: https://zapier.com/help/create/format/import-csv-files-into-zaps

Try using this action: GSheets Create Row(s)

NOTE: There are record limitations with each of those apps to be aware of.

 

Alternatively, can you remove that data from the CSV file altogether using Zapier?

Not that I’m aware of.

 

*Bonus I am looking to filter out line items from a specific column too, but I think that is a separate question and I’m sure there are resources out there for that*

You can try using the Looping app to handle the CSV line items, and add a Filter step.

Terms & Conditions