When importing a file into Delivra, you might see an error indicating that some cells in the Email Address column are blank—even though they don't appear empty to you. This error typically means that the system has detected formatting in those cells, but no actual email addresses.
This issue does not mean your entire file is invalid or that the import has failed. It simply flags that there are empty or improperly formatted cells within the Email Address column.
Excel and other spreadsheet tools can retain invisible formatting in cells that appear empty. If a cell has been formatted (e.g., font style, borders, or background color) but doesn’t contain an email address, Delivra will flag it during import.
To clean up your file and avoid this warning, try one of these approaches:
Reset the "last cell" in your worksheet
Scroll to the last row and column that actually contains data.
Clear formatting in all blank rows and columns between your data and the Excel-defined last cell.
Save your file as a .CSV
before reimporting.
Copy your actual data into a clean worksheet
Highlight and copy only the cells with valid contact data.
Paste into a new, blank worksheet.
Save the new file as a .CSV
and import it into Delivra.
Always save your file in .CSV
format before importing.
Double-check that the Email Address column contains valid addresses only—no empty cells or stray formatting.
Avoid hidden characters or formulas in email address fields.
If you've cleaned your file and still receive errors, try opening the file in a plain-text editor like Notepad to look for hidden characters. Or, reach out to our support team at support@delivra.com.