Make to export a CSV file

Pascal_Gallais- · ‎Oct 17, 2024

Hello,

@ScottWorld, after watching one of your videos, I set up a Make scenario to automate a csv export from an Airtable view:

I used the CSV "create csv advanced" module and it works fine.

My problem is that all fields in the exported csv are surrounded by double quotes:

Do you know how I can remove them?

Thank you

Pascal

ScottWorld · ‎Oct 17, 2024

Hi @Pascal_Gallais- ,

CSV files always add quotes around values that have spaces or other special characters in them, but I’m not sure why Make puts quotes around 100% of the values… even if those values don’t have spaces or special characters.

However, you don’t really need to worry about the quotation marks, because any database or spreadsheet program that imports the CSV file should know to remove the quotation marks upon importing.

A text editor will show you the raw data with quotation marks, but any program that imports the CSV file should ignore the quotation marks.

If you use a different method to create the file like using the text aggregator that @dilipborad mentioned above, be aware that you might accidentally be removing quotation marks where they actually SHOULD exist in a CSV file.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

See Solution in Thread

dilipborad · ‎Oct 17, 2024

Hello @Pascal_Gallais-,

While you use Make there are lots of options but in your case.
Try to use Text Aggregator and then set up a variable for headers of csv.

Output

You need to make sure to use your all variables and give a proper header if it's required.

Another important thing is that most CSV are surrounded with "(quotes) because sometimes the comma(,) is used within some of the values and at that time all csv goes messed up. So you need to remember this.

Hope this works for you.

👍

ScottWorld · ‎Oct 17, 2024