Key takeaways
- Preserve the original file, source row, and email column before processing.
- Track submitted, completed, pending, and failed rows separately.
- Deduplicate intentionally without losing the original row mapping.
- Retry failed chunks idempotently and make the export from stored results.
- A completed download should contain the expected completed rows, not an arbitrary subset.
CSV email verification becomes a reliability problem as soon as the file is larger than a convenient browser request. The correct design is a durable pipeline: upload, parse, queue, persist, retry, aggregate, validate, and export.
Preserve the source file
Store the original upload and record the email column, delimiter, encoding, header, row count, and source identifiers. Keep the original value beside any normalized comparison value.
Track four counts
Show these separately:
- Submitted rows.
- Completed rows.
- Pending rows.
- Failed rows.
“Showing 29,000 of 29,000” is misleading if only 12,000 rows have actually received a verdict. The UI and export must use completed state, not upload state.
Handle duplicates carefully
Deduplicate when it reduces repeated work, but preserve a mapping from normalized email to every original row. When the export is generated, apply the result back to the original rows according to the customer’s chosen policy.
Use idempotent chunks
Give every row or chunk a stable ID. If a worker retries, update the same result. One slow or failed chunk should not invalidate all completed work, and it should not add another copy of the completed rows.
Validate before download
Before the export is marked complete, check that:
1. Completed result count matches the job’s completed count. 2. Every expected source row has a result or explicit pending state. 3. No result ID appears twice. 4. Original columns are preserved. 5. The file can be downloaded after a browser disconnect.
VeriMailX’s bulk checker is designed for this kind of large-file workflow.
The bottom line
Reliable CSV verification is about durable state and truthful exports. Keep source rows, count completed work, retry safely, and validate the final file before offering it to the customer.
Sources
- VeriMailX bulk email checker
- VeriMailX email list cleaning guide
- Verifalia plans and bulk list documentation
Frequently asked questions
Ready to clean your list?
Verify your emails with VeriMailX and send your next campaign with more confidence, fewer bounces and better results. Unlimited free single email verification — no card required.