Skip to main content
Best answer

Blank fields in CSV Upload

  • September 3, 2021
  • 1 reply
  • 102 views

I am uploading a CSV to Salesforce and have a sheet with a field (Other, text field) that does not have a value for all of the lines.  I cannot map the field to Zapier with a blank value.  Will this effect the rest of the sheet if it runs with blanks?  Do I need to fill in a value in that field for the test to get it to map? Do I need to build filters to parse out if a line has a value in that field?  I should mention that it’s okay for the field to be overwritten with new data. 

Best answer by Troy Tessalone

Hi @Start Early 

If your CSV has header rows, you should be able to map the desired data points.

Otherwise, you may need to use a dummy CSV with all the data points populated to properly config the Zap mappings between steps.

Check out this help article for using CSVs in Zaps: https://zapier.com/help/create/format/import-csv-files-into-zaps

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • September 3, 2021

Hi @Start Early 

If your CSV has header rows, you should be able to map the desired data points.

Otherwise, you may need to use a dummy CSV with all the data points populated to properly config the Zap mappings between steps.

Check out this help article for using CSVs in Zaps: https://zapier.com/help/create/format/import-csv-files-into-zaps