Overview

If the file is not following the correct format, then it will fail to import. However, the reason why the file failed to import will not be shown, but the most common reasons why it fails, are because of the profile URL, headers, and extra columns.

First, you need to identify what the issue may be. Down below, you can find the reasons and how to solve it.

How to check the profile URL

To check the profile URL, simply take a close look to it, and if it starts with http instead of https, then that may be the cause why the file failed to import. Also, this URL may also be a Sales Navigator URL, and it needs to be a public profile URL.

How to solve invalid profile URL

In this case, the file is failing to upload because the Linkedin profile URL starts with a http, instead of https as the image below.

To solve this, you need to replace the http with https. One way to do it is using google spreadsheets.

Upload the CSV file into google drive, then open the file in spreadsheets
Hover over edit, and click Find and Replace
A window will open. In the find field, place http: and in the replace with field, place https: because we are replacing http: with https:
Once the fields are filled, click replace all, and click done.
Now you need to export the file by hovering over the file tab, click download, and download the file as CSV
Once the file is downloaded, try to upload the file into the campaign as you did earlier. Or click here to learn how.

How to change from Sales Navigator URL to Public URL

Select the Linkedin URL column
Click on Data
Click on Split text into columns. This will separate the data that we don't need in the URL.
Remove the 2 extra columns that have been populated with the unnecessary data
Click the Linkedin URL column and go to Edit in the menu
Click Find and replace. Here you will want to find the following text /sales/profile/ and replace with /in/, then select find and replace all, and click done.
An extra step to do is to remove the hyperlinks. This is why you will see the links going from blue to black in the video. This is not always necessary but we would recommend it.

Example video here.

Ho to check for invalid headers

To check for invalid headers, take a close look to the caps in them. Usually, the common mistake is to incorrectly place caps, or not to place spaces between words. Example: to place "First name" instead of "First Name". Make sure to always follow the template.

How to solve invalid headers

When it comes to headers, they need to be in the exact same way as in the image below.

To solve this, simply place the header with the correct cap or lower case according to the header.