Bulk Email Address Validation with CSV File
Check if the email addresses in a csv file are really exists without sending any messages
Validation in a nutshell
An email address can look right but still be wrong. Real email uses in depth email address validation to check if emails really exist without sending any messages.
Bulk Email address validation using a CSV file
From the Real Email dashboard you can upload a csv file to interactively validate any email address in it. This can be used to filter email group lists or mail out lists.
Many programs allow for importing and exporting csv files, including form spreadsheets and email sending platforms like MailChimp and SendInBlue. For more control you may like to process the files using the api and shell scripts.
Bulk file validation using api and shell scripts
If you would like more control you can validate a csv file using your Real Email api key and the bellow bash shell script. First login to Real Email and get your API key and place it into the Authorization header.
Given an example file like emails-input.csv
foo@bar.com
bar@test.comIf you run that through the bellow script.
#!/bin/bash
while IFS='' read -r line || [[ -n "$line" ]]; do
echo $line, `curl "https://isitarealemail.com/api/email/validate?email=$line" \
-H 'Authorization: bearer xxx' | jq .status`;
done < emails-input.csv > emails-output.csvThen It will give you the output file that looks like this.
foo@bar.com,valid
bar@test.com,invalid