We often see four main reasons a sheet fails to be uploaded to Adversus.
It's a semicolon-separated CSV file
The file includes formulas
The Excel file is locked
There are too many columns in the spreadsheet
If you are experiencing issues with importing leads to Adversus, please troubleshoot using this article.
If the file is semicolon-separated
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:
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 to Adversus.
If the file includes formulas
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.
Open your file in Excel and save it as a an .xls file (not .xlsx). The .xls format often removes any formatting from the file.
If the file is locked
The person who has created the Excel spreadsheet has enabled a password to protect the file - but Adversus won't be able to read the spreadsheet if it's locked with a password.
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.
If the file has too many columns
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.
Consider removing unnecessary data columns that you are not gonna use for lead enrichment in Adversus