{"id":1065,"date":"2022-10-04T15:16:30","date_gmt":"2022-10-04T14:16:30","guid":{"rendered":"https:\/\/lix-it.com\/blog\/?p=1065"},"modified":"2022-10-04T15:16:31","modified_gmt":"2022-10-04T14:16:31","slug":"convert-sales-navigator-urls-to-linkedin-urls","status":"publish","type":"post","link":"https:\/\/lix-it.com\/blog\/convert-sales-navigator-urls-to-linkedin-urls\/","title":{"rendered":"How To Convert Sales Navigator URLs To Linkedin URLs"},"content":{"rendered":"Reading Time: <\/span> 3<\/span> minutes<\/span><\/span>\n
<\/div>\n\n\n\n

There are a number of reasons you might need to convert Sales Navigator URLs to LinkedIn URLs. Thankfully, there are a number of ways to do it!<\/p>\n\n\n\n

<\/div>\n\n\n\n

The first method involves manually copying and pasting the bit of the URL you need. It works better when you have a small number of URLs to convert. The second method uses an Excel \/ Google Sheets equation. This is a great option for when you already have a large list of URLs to convert. The third method converts Sales Navigator URLs to LinkedIn URLs automatically, as you export from sales nav – using Lix! Skip to the method that suits your needs.<\/p>\n\n\n\n

<\/div>\n\n\n\n
  1. Manual URL Conversion<\/a><\/li>
  2. Excel \/ Google Sheets Equation<\/a><\/li>
  3. Automatic conversion during export<\/a><\/li><\/ol>\n\n\n\n
    <\/div>\n\n\n\n

    Manual URL Conversion<\/h2>\n\n\n\n
    <\/div>\n\n\n\n

    This is a super-simple and quick way to get the standard LinkedIn URL from the Sales Nav version. Essentially, it\u2019s just removing a small section of the Sales Navigator URL and copy & pasting it into the standard format.<\/p>\n\n\n\n

    <\/div>\n\n\n\n
    1. Select and copy everything that comes after lead\/<\/em> and before the first comma:<\/li><\/ol>\n\n\n\n
      <\/div>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      <\/div>\n\n\n\n
      1. Paste this on the end of the standard LinkedIn profile URL format www.linkedin\/com\/in\/<\/em><\/li><\/ol>\n\n\n\n
        <\/div>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        <\/div>\n\n\n\n

        You can also replace sales\/lead<\/em> with in<\/em> and delete everything after the comma – both methods give the same result!<\/p>\n\n\n\n

        <\/div>\n\n\n\n

        If you\u2019re converting a handful of profiles, this process is great\u2026 What happens when you have hundreds (or thousands!) of Sales Navigator URLs to convert?<\/p>\n\n\n\n

        <\/div>\n\n\n\n

        Excel \/ Google Sheets Equation<\/h2>\n\n\n\n
        <\/div>\n\n\n\n

        If you have a list of Sales Navigator URLs you need to convert LinkedIn URLs en masse, this is the solution for you.<\/p>\n\n\n\n

        <\/div>\n\n\n\n

        Here is the formula:<\/p>\n\n\n\n

        =LEFT(SUBSTITUTE(A1,\"<https:\/\/www.linkedin.com\/sales\/lead\/\",\"https:\/\/www.linkedin.com\/in\/\"),SEARCH(\",\",SUBSTITUTE(A1,\"https:\/\/www.linkedin.com\/sales\/lead\/\",\"https:\/\/www.linkedin.com\/in\/\")>)-1)\n<\/code><\/pre>\n\n\n\n
        <\/div>\n\n\n\n
        1. Open up your file with the Sales Nav URLs and paste the formula in the next column. Be sure to change the value \u2018A1\u2019 in the formula to correspond with the cell of the first URL to convert. <\/p>\n\n\n\n
        <\/div>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        <\/div>\n\n\n\n
        2. Click the square in the bottom-right corner of the cell and drag all the way to the bottom of the list – this will apply the formula to the correct cells on the left! <\/p>\n\n\n\n
        <\/div>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        <\/div>\n\n\n\n
        3. Voila! A list of converted Sales Navigator URLs to LinkedIn URLs<\/p>\n\n\n\n
        <\/div>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        <\/div>\n\n\n\n
        Automatic Conversion During Export<\/h2>\n\n\n\n
        <\/div>\n\n\n\n
        If you\u2019re regularly converting Sales Navigator URLs to the standard LinkedIn format, it\u2019s probably easier to use a tool that does it for you! When you export data from Sales Nav using Lix, we automatically apply a formula like the one above, so that your spreadsheet comes with both Sales Nav and standard format LinkedIn URLs.<\/p>\n\n\n\n
        <\/div>\n\n\n\n
        It looks like this:<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        <\/div>\n\n\n\n
        You can watch a short video on how to export Sales Navigator data using Lix:<\/p>\n\n\n\n
        \n