How to Generate CSV Files

Create a CSV file from Zapier, Integromat, or a simple POST Request from JSON data.

Generate a CSV File using the Zapier Webhook Action

  1. After logging in, click the "All CSV Generators" link after clicking to open the top nav behind your username.
  2. Create a CSV Generator
  3. After you create a CSV Generator you will get a webhook URL to send a POST request to.
  4. In Zapier, create a new Zap.
  5. For the first trigger step choose any App where the data is coming from.
  6. For the action step, choose "Webhooks by Zapier".
  7. For the field "Choose Action Event" choose "POST".
  8. Click the continue button.
  9. For the "URL" field paste the webhook for your CSV Generator from EasyCSV.io Zapier create a CSV file.
  10. For "Payload Type" select "Json"
  11. Data will be your key/value pairs. The keys in the left-column will become your header row of the generated CSV file. The values will be the first row of data. For the values, you will want to select the values from your first trigger step of the Zap.
  12. For "Wrap Request in Array" select "Yes".
  13. You do not need to do anything else and can click the Continue button.
  14. Test your Zap and then turn it on. You are all set!
  15. You can check the import log table at the bottom of your EasyCSV CSV Generator page for details on successful generations or errors.

Generate a CSV File using a POST request from JSON

  1. After logging in, click the "All CSV Generators" link after clicking to open the top nav behind your username.
  2. Create a CSV Generator
  3. After you create a CSV Generator you will get a webhook URL to send a POST request to.
  4. Send your POST request to your webhook URL with the param "data" consisting of an array of JSON objects (key/value pairs). Each item in the array will become a row in the CSV file. The keys of the first object will become the CSV header row. Example CURL:
    curl --location --request POST 'http://www.easycsv.io/generate_csv/12345-f9ae-678-b518-a84a786374c5?data={%22name%22:%20%22buc%20doe%22,%22email%22:%22bucdoe@easycsv.io%22}'
  5. You can check the import log table at the bottom of your EasyCSV CSV Generator page for details on successful generations or errors.

Generate a CSV File using the Integromat Webhook Action

  1. After logging in, click the "All CSV Generators" link after clicking to open the top nav behind your username.
  2. Create a CSV Generator
  3. After you create a CSV Generator you will get a webhook URL to send a POST request to.
  4. In Integromat, create a new Scenario.
  5. For the first step of your scenario choose any App where the data is coming from.
  6. For the last step, choose the "HTTP" module.
  7. For the HTTP module choose the type "Make a request".
  8. For the "URL" field paste the webhook for your CSV Generator from EasyCSV.io Integromat generate a CSV file.
  9. For "Method" select "POST"
  10. For "Query String" we will add the key "data". Then type an array of JSON. Example in screenshot and also below:
    [{"name": name_value_from_first_step, "email": email_value_from_first_step}]
    The keys of the first record will become the CSV header row and the values will be the first row of data after the header row.
  11. For "Body Type" select "Raw".
  12. For "Content Type" select "JSON".
  13. You do not need to do anything else and can click the Ok.
  14. Test your Integromat Scenario and then turn it on. You are all set!
  15. You can check the import log table at the bottom of your EasyCSV CSV Generator page for details on successful generations or errors.

Special syntax for dates, times, and uniqueness for your files & emails

You will most likely want to include some form of a date, time, or uniqueness in your CSV Generator. Whether it's for the output filename or for the email subject line or body copy. Use the special syntax below in your CSV Generator to have these values set when a file is generated.

Syntax Example(s)
{MMDDYYYY} Filename: leads_to_hubspot_{MMDDYYYY}.csv
Email Subject Line: New CSV File for {MMDDYYYY}

leads_to_hubspot_01232021.csv
New CSV File for 01232021
{MMDDYY} Filename: leads_to_hubspot_{MMDDYY}.csv
Email Subject Line: New CSV File for {MMDDYY}

leads_to_hubspot_012321.csv
New CSV File for 012321
{DDMMYYYY} Filename: leads_to_hubspot_{DDMMYYYY}.csv
Email Subject Line: New CSV File for {DDMMYYYY}

leads_to_hubspot_23012021.csv
New CSV File for 23012021
{DDMMYYYY} Filename: leads_to_hubspot_{DDMMYY}.csv
Email Subject Line: New CSV File for {DDMMYY}

leads_to_hubspot_230121.csv
New CSV File for 230121
{24HHMMSS} Filename: leads_to_hubspot_{MMDDYY}_{24HHMMSS}.csv
Email Subject Line: New CSV File for {MMDDYY} - {24HHMMSS}

leads_to_hubspot_012321_182330.csv
New CSV File for 012321 - 182330
{UNIQUE_ID} Filename: leads_to_hubspot_{UNIQUE_ID}.csv
Email Subject Line: New CSV File - {UNIQUE_ID}

leads_to_hubspot_a1b2c4d5.csv
New CSV File - a1b2c4d5
{FILENAME} Email Subject Line: New CSV File - {FILENAME} New CSV File - leads.csv
Need something else? Email support@easycsv.io and ask for what you want and give us an example of how you will use it. We will probably add it quickly for you.