Excel (.xlsx) file import not working

WarmySender only supports CSV (Comma-Separated Values) file format for prospect imports. Excel files (.xlsx, .xls) are not directly supported.

How to Convert Your File:

From Microsoft Excel:

1. Open your Excel file.
2. Click File > Save As (or Export).
3. In the 'Save as type' dropdown, select 'CSV (Comma delimited) (*.csv)' or 'CSV UTF-8 (Comma delimited) (*.csv)'.
4. Click Save. If prompted about losing features, click 'Yes' — CSV only stores data, not formatting.
5. Upload the resulting .csv file to WarmySender.

From Google Sheets:

1. Open your spreadsheet in Google Sheets.
2. Click File > Download > Comma Separated Values (.csv).
3. The CSV file downloads to your computer.
4. Upload this .csv file to WarmySender.

From Apple Numbers:

1. Open your file in Numbers.
2. Click File > Export To > CSV.
3. Click Save.
4. Upload the .csv file to WarmySender.

CSV Requirements:

• File must be UTF-8 encoded (most modern tools default to this).
• First row must be column headers (e.g., email, firstName, lastName, company).
• The 'email' column is required (unless you have linkedinUrl for LinkedIn-only prospects).
• Maximum 10,000 rows per import.
• Common delimiters: comma (,) is standard. Semicolon (;) may not be recognized.

Common Issues After Conversion:

• Special characters showing as garbled text — make sure you saved as 'CSV UTF-8', not just 'CSV'.
• Extra empty rows at the bottom — delete empty rows in Excel before exporting.
• Merged cells — unmerge all cells before exporting (merged cells don't translate to CSV).
• Multiple sheets — CSV only exports the active sheet. Switch to the correct sheet before saving.

Tip: After converting, open the CSV in a text editor (Notepad, TextEdit) to verify it looks correct before uploading.

Back to all documentation | Contact support