It's a semicolon-separated CSV file

The file includes formulas

The Excel file is locked

There are too many columns in the spreadsheet

The issue

The way you see if the issue is a semicolon-separated file is if all columns "stick together" when trying to upload. It will look like this:

The fix

To solve the problem, you can open the file in Excel and save it as the default Excel file (.xls or .xlsx). You will then be able to upload the file.

If you are using Google Sheets, open your Google Drive, press New and choose Google Sheets.

Go to File and click Import.

Click Upload and find the file you weren't able to upload in Adversus.

Before clicking Import, make sure you've chosen Replace sheet as the Import action and are using the correct Separator.

The file is now properly formatted. Download it as an Excel file and upload it to Adversus.

The issue

It is not possible to import Excel files that include formulas to Adversus. So if you're using it in your Excel sheet, that's probably why we won't let you upload your leads.

The fix

Open your file in Excel and save it as an .xls file (not .xlsx). The .xls format often removes any formatting from the file.

The issue

The person who created the Excel spreadsheet has set a password to protect the file, but Adversus won't be able to read it if it's locked.

The fix

Open the Excel file and enter the password. In the upper left corner, click File, go to Info in the left-hand panel, and click Protect Workbook. From the dropdown list, click on Encrypt with Password and delete the password to remove the lock.

The issue

If the sheet includes too many columns, Adversus won't be able to read all of the information, which will cause the upload to fail.

The fix

Consider removing unnecessary data columns that you are not gonna use for lead enrichment in Adversus