Use Google Sheets & EasyCSV Together

How to use EasyCSV to allow uploads of multiple spreadsheets into on Google Sheet.

How to setup uploading to a Google Sheet from EasyCSV - 2 minutes

  1. Connect your Google Account to EasyCSV. Simply log out of EasyCSV. Then on the EasyCSV login screen choose to log in with your Google Account.
  2. Create a sheet import page on EasyCSV.io
  3. After the page is created, click the "Sheet Details" link at the top of the page.
  4. Under the section, "Where to send import data?" click the checkbox for "Post to Google Sheets".
  5. Search for a sheet to send all data to.
  6. Optional: You can specify a tab/worksheet in the destination Google Sheet. If you leave this option blank all data will be appended to the first tab/worksheet in the Google Sheet.
  7. Make sure the first row in the Google Sheet are the column headers you want to match columns from import CSVs spreadsheet columns. You can also include "Magic Column Headers" that will populate with import data (read below).
  8. It's that easy!

Magic Columns for your Google Sheet

If you add the below column headers to the first row of your destination worksheet in your Google Sheet they will magically populate with helpful data from each import.

Column Header What will populate
easycsv_import_id ID of the import (good to troubleshoot any imports you may want to remove)
easycsv_import_name Name of the import. Usually the CSV file name.
easycsv_importer_email Email of the person who uploaded the CSV.
easycsv_import_time Date and Time of the import.
easycsv_sheet_name Import page name.
easycsv_sheet_slug URL slug of the import page (Example: /store-import)
easycsv_sheet_id ID of the import page
easycsv_import_code Import Code if you are exchanging temporary import codes with your application.
easycsv_importer_reply_to Email of the Reply To field if import was done via email attachment.

How do I map column names from the CSV being imported to be placed in new columns in the destination Google Sheet?

Use the EasyCSV feature: "Custom JSON to post". You will find it at the top of your sheet import page if you are logged into EasyCSV and are the admin.

Let's say you have a CSV file you want to have imported to a Google Sheet. The column headers from the CSV file you want to import are: first name, last name, email address, street address.

Let's say you want to combine the first and last names into one field in the google sheet: Full_name. You also want to change the email address to just be: email. Here is what you will put in the text area on the Custom JSON to post page:

{
  "Full Name": "{{ FIRST_NAME }} {{ LAST_NAME }}",
  "Email": "{{ EMAIL_ADDRESS }}",
  "Street Address": "{{ STREET_ADDRESS }}"
}

You will see values from the importing sheet need to be surrounded by curly braces {{ }}, capitalized, spaces become underscores _ , and also surrounded by double quotes " ". The destination sheet column names should be exactly the same as what's in the first row headers of the destination Google Sheet.

Tip: On the Customize JSON to post page you will see some helper text that tells you how to write variable names to be populated from column rows of the CSV file you want to upload.

How do I re-connect Google Sheets to EasyCSV?

  1. Make sure you are logged into the correct Google Account and go here: View 3rd Party Apps Access
  2. Click on "EasyCSV"
  3. Click the "Remove Access" button.
  4. Log in to EasyCSV using your Google Account to re-connect.