If you have downloaded your CSV/Excel file from Popular Chips and wish to convert the IG usernames/handles into clickable link, please follow this simple steps:

STEP 1

Download the CSV file from Popular Chips.

STEP 2

Open the file.

Depending on your Excel version and your language settings, the content in your excel file might appear like this:

If you don’t know how to convert text to column, please, follow this: How to Convert Text to Columns in Excel

STEP 3

Insert a column after the Username/Handle column, and name it: IG Link.

STEP 4

Copy& Paste this formula into the cell next to the first username/handle of the list: =CONCATENATE("https://www.instagram.com/",A2)

ATTENTION! 

  • Make sure that A2 is referring to the cell containing the first username/handle of the column. If your usernames/handles are in another column, change A2 with that column name ( B2 or C2 etc.).
  • Make sure that A2 is activated. If it is, it will be coloured, and the related cell will be highlighted.

STEP 5

Then drag and copy this formula to the cells you want to transform. Et voilà:

Did this answer your question?