How to add filter rules to only import data you want

Skip data rows you don't want to import from spreadsheet with simple rules.

Quick Links:

  1. How to add filter rules for your import page
  2. How to only grab unique rows from a file by checking for unique values in a column
  3. Do your spreadsheet numbers have commas instead of decimals? How to use commas instead of decimals in number comparisons.

Filter Rule Setup Video

How to add filter rules before importing data

  1. Log into EasyCSV
  2. Create a new sheet import page on EasyCSV.io using the CSV file or Google Sheet you want to change (shown how-to in video above).
  3. After the page is created, click the "Filter Rules" link at the top of the page.
  4. Specify AND / OR rules based on that will be used to evaluate each row of data from your spreadsheet before impoting. Only rows that meet the criteria of your filter rules will be imported. Rows that do not meet the filter rule criteria you set up will be filtered out and NOT imported.
  5. Click the "Save" button.
  6. You can now do an import and it will only send the data you want!

Do your spreadsheet numbers have commas instead of decimals? How to use commas instead of decimals in number comparisons.

  1. Log into EasyCSV
  2. Go to your import page.
  3. Click the "Sheet Details" link at the top of you import page.
  4. Change the field labelled "Number separator - Decimal" to be a comma , instead of a decimal .
  5. Click the Save button.
  6. Now, if you have a filter that is using the number must be greater than or less than logic it will properly parse numbers with commas as the decimal separator.

How to only grab unique rows from a file by checking for unique values in a column

** ONLY for the Business Plan level and above **

  1. Log into EasyCSV
  2. Go to your import page.
  3. Click the "Import Flow" link at the top of you import page.
  4. Scroll down to the "Columns" section.
  5. Click the Edit link on the column you want to use are the unique identifier.
  6. Select the checkbox value for the option "Use column values to ONLY keep 1 unique row" and click the "Save" button at the bottom of the form.
  7. That's it! The import flow will keep the first row from the file with the unique value for that column and discard others. You can change to keep the last row in the file instead of the first by going back to the "Import Flow" view and clicking the "first" link in the new Filter in the middle of the flow.