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 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.

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

Move certain columns from CSV file to new Google Sheet (or remove from original CSV)

  • 14 January 2022
  • 1 reply
  • 355 views
magicmiles

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*

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

1 reply

Troy Tessalone
Userlevel 7
Badge +14

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.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions