Integrations
Excel add-in
The Excel add-in is built but not available to install yet: it is not in AppSource, and its files are not hosted. This page says what it will do, and how to check the addresses in a workbook today.
- Status: Coming soon
- Check a workbook today as a bulk list
=EV.VALIDATE(A2)
Returns the status and the reason in two cells,
for example: valid acceptedAt a glance.
- Status
- Coming soon. Not available to install yet. Below: what it will do, and what to use today.
- For
- People who keep address lists in Excel workbooks and want a status next to each row without exporting a file.
- You need
- Once it is listed: Excel on the web, or Microsoft 365 or Office 2021 or later on Windows and Mac, and an API key made for it, with a daily credit cap.
- Costs
- 1 credit = 1 validated address, as with any API request. Free: unknown results, API errors, malformed addresses and test addresses on sandbox.email-validation.org.
- Full guide
- Read the guide
What it will do.
A status in a cell
=EV.VALIDATE(A2)will return an address’s status and reason. Results stay in memory while the workbook is open, so a recalculation is free.A whole column
The task pane will validate a selected column: up to 50 addresses as single checks, more as one bulk list, and it states the most a run may cost before it starts.
A free test sheet
Add test addresses will add a sheet of sandbox addresses that return a fixed result each and cost nothing.
Until it is listed. What to use today.
Upload the workbook
Upload the XLSX file as a bulk list in the dashboard and download the results file when it is done.
Use Google Sheets
The Google Sheets add-on gives you a cell function and a menu for whole sheets today.
Call the API
Send each address to the validate endpoint from your own code or an automation.
Good to know.
- Your key will be kept in the add-in’s own storage on your computer, never in a workbook, and addresses will be sent only in the body of a request, never in a URL.
- Results are remembered only while the workbook is open: when Excel recalculates a reopened workbook, its formulas check again and are charged again, so paste results as values to keep them.
- Developers with the add-in’s source can sideload it to try it; the source is not published yet. The add-in guide has the details.
Updated · Maintained by the email-validation.org team