Imported lists are a great feature of Leadfeeder, and are usually quite simple to get started and to understand. If there are issues they typically fall into a couple of categories uploading issues, or issues with matching.
Importing a list is simple, but if an error does occur it is typically this one:
"List processing failed. Please make sure that the file uses UTF-8 encoding and try again."
UTF-8 is the primary character encoding for the World Wide Web.UTF-8 can support many languages many different combinations of pages and forms. It also fast tracks things so that servers don't need to individually determine the encoding of every file. The short answer is that UTF-8 encoding makes things faster and simpler.
You can typically save CSV files with UTF-8 encoding if it isn't done automatically by the software you are using.
If you use Notepad
- Click on File
- Choose Save As
- There are three items to update in the Save dialog that comes up:Save as type: change this to All Files File name: name your file and add the .csv extension to it - e.g.: myupdates.csv Encoding: click on the dropdown and choose UTF-8
If you use Google Docs
- Open Google Drive.
- Create a new Google Sheets document.
- In the new Google Sheets document, import your CSV file.
- Once you import your file, you can click on File>Download As>Comma-Separated Values to save the file to your computer.
The file should now be in UTF-8 encoding, and it should successfully upload.
If you use Numbers
- Click on File
- Hover over Export
- In the submenu that appears, choose CSV
- Click on Advanced Options to show the Text Encoding dropdown
- Select Unicode (UTF-8) from the dropdown menu
- Click Next
If you use Excel
Excel, when exporting to .csv can create unreadable characters in the files. You can work around this by re-saving the file from Notepad with the following instructions if you are experiencing issues.
(Older versions of Excel for Mac do not natively support the import or export of UTF-8 encoded files and the encoding must be selected. Opening and saving the file from Numbers may be a better option in this case.)
If you use the Windows operating system and you have Notepad
- Open the .xlsx file in MS Excel, then click File > Save As (Other Formats).
- Enter any name for the file, then select "Unicode Text (.txt)" for "Save as type".
- Click Save.
- Open the Unicode text file using Microsoft Notepad.Some characters appear as a box. This is because Notepad cannot display some Unicode characters. You can ignore these characters for now.
- Replace tabs with commas (",”) so that the .xlsx file is tab-delimited and in proper comma-separated value (CSV) format.
- Select a tab character by dragging the character between two column headers and pressing CTRL+C.
- Use the Replace function (CTRL+H) to replace all tab characters with commas.
- In Notepad, click Save As.
- Enter a filename and change Encoding to "UTF-8".
- Add .csv at the end of the file name to change the file extension from ".txt" to ".csv".
- Click Save.The file icon should be changed to MS Excel now.
- Open the CSV file from Excel and verify the data.(Even if you find a problem, do not save the file in Excel. It will cause the encoding problem again. Just check the data only in Excel. If you see a data problem at this stage, fix the data from the original spreadsheet and repeat the steps again. You can also change the file from Notepad but make sure to ensure to save the file as UTF-8 format.)
You can now use this CSV file for importing.
If you use another program, you might be able to manually change the encoding it uses when saving a file. Be sure to look through their documentation to find out more about how this works.
You can also use https://csvlint.io/about to look at your CSV and see if there are formatting or other issues.
Depending upon how you have your lists and names formatted matching issues can sometimes arise. To get the best match we recommend some key practices and things to know.
- Create a 2-column only list of company names and their website addresses in the following format:
Save as a CSV. Note that character case will be ignored during processing, eliminating any prefix such as www is ideal.
- Do not leave empty rows between the companies and website addresses in the CSV. The minimum length of the company name is 2 characters. Save the file in the UTF-8 encoding format.
- Only the first 10,000 entries of a list will be loaded, if the list exceeds 10,000 entries. You can split longer lists and upload them individually. You can upload up to 20 lists. Please note also that it might take some time to load your list and the Imported list filter might not instantly appear.
- We use multiple sources to determine global organization names so, in general, it would be almost impossible to "be sure" that every version of a company name exactly matches our company database. To help give room for matching for each company name leave the smallest subset of "meaningful parts". For example, stating "3i Group Limited" as "3i", "Microsoft Corporation" to "Microsoft", or "Adobe Inc." to "Adobe" etc.
Hopefully these tips and checks make it easy for you to get everything you want out of our Imported Lists feature, however if you do have problems let us know!
You can contact our support either by chat on the lower right corner or by sending us an email to firstname.lastname@example.org.