Easy Guide to Deleting Columns from CSV and Creating Google Sheet on Make.com

Have you ever found yourself stuck with a CSV file that has too many columns? You just want to delete some of them and then push the final CSV data to a Google Sheet, but you're not sure how to do it. Well, you're not alone. Many Make.com users have faced this challenge, and we're here to help you overcome it.

Problem

The main problem here is figuring out how to delete unwanted columns from a CSV file and then pushing the final CSV data to a Google Sheet. The user was parsing the CSV data and then using the Create CSV advanced module to create a new data structure with just the columns they needed. However, they were unsure if the CSV module was the best way to delete columns from the file and how to get the resulting CSV back out of Make.

Solution

Good news! You may not even need to use the advanced module. You can simply unselect the column you want to remove from the basic Create CSV module. Here's how:

1. Open the basic Create CSV module.
2. Unselect the column you want to remove.

To make a Google Sheet from CSV, just select Convert a file > spreadsheet. It's that simple!

Troubleshooting Tips

If you're still having trouble, make sure you're using the correct modules and following the steps correctly. If you're still stuck, don't hesitate to reach out to the Make community. We're always here to help!

Summary

Deleting unwanted columns from a CSV file and pushing the final CSV data to a Google Sheet doesn't have to be a headache. With Make.com, you can easily accomplish this task using the basic Create CSV module and the Convert a file > spreadsheet function. Remember, the Make community is always here to help if you run into any issues. Happy Making!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.