Import recipients from a CSV file¶
3 min read
In order to enable the feature to upload prospects from a CSV file, your Revenue Grid Admin must enable it in the Import/Export tab of the settings.
In order to add recipients from a CSV file to a sequence, first make sure your CSV file is in the right format and has all necessary columns in place, spelled and deliminated correctly. Then, you can upload it to Revenue Grid: directly on the Recipients tab of a particular sequence, or to the main pool of prospects on the Audience page.
Prospects imported from a CSV file have no icon next to their logo in Revenue Grid (if they are not linked to any Salesforce records), while prospects imported from Salesforce will be marked with Salesforce Contact and Salesforce Lead icons.
Prospects imported from Salesforce and CSV will remain in Revenue Grid until they are manually deleted.
CSV file format¶
These are the headers of the columns which should match exactly like in the template.
Required columns: email, firstName, lastName
Optional columns: all the rest
In the example above, second prospect in the list won’t be uploaded to Revenue Grid because of missing value in one of the required columns.
Make sure you double check your CSV file opened in MS Excel or in any other supported CSV file editor.
Importing prospects to Revenue Grid from CSV file¶
You can import recipients directly into one of your sequences, or to the Audience page to the major pool of prospects in Revenue Grid.
1. Click button in the top right-hand corner, and choose "CSV"
2. In the appeared dialog box, choose a file or drag-and-drop it to the gray area.
Once a file is chosen, Preview area will parse first two rows from your CSV file. There may be a case when you would get error messages.
Missing mandatory column - means at least one header of the required columns is missing or mistyped. Please open your CSV file on your computer via MS Excel or any other supported editor and make sure that required headers all properly delimited and look good.
No relevant data - means the chosen file is empty.
3. Choose values in the Character Code and Values Separated By drop-downs and click "Import".
Total - how many rows have been found in the file (besides the header row)
Created - how many prospects have been successfully imported
Matched existing - how many prospects match already existing prospects with the same email
Failed - how many prospects had blank at least one value in required fields
Added to sequence (this appears only when you importing into a sequence on the Recipients tab, as opposed to on the Audience page) - it equals to number of Created prospects, and shows how many prospects have been added to the sequence
What happens when I have duplicated prospects? Refer to this article for details on how Revenue Grid handles duplicates while importing prospects.
We would love to hear from you!