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.

Filter Rule Setup Video

How to add filter rules before importing data

  1. Log into EasyCSV
  2. Create a new sheet import page on 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.