0

I have a csv file that looks like this :

Attribute_1_0, Attribute_2_0, file_Path_0
Attribute_1_1, Attribute_2_1, file_Path_1

But I would like to convert it to an xls file and translate the file paths to links in the Excel file, so that the user can interact directly with those files. Is there a way to achieve that?

1
  • Create a macro that can open a file, extract each item in the csv file and put it in the correct cell. Loop until complete.
    – unknownSPY
    Mar 2, 2017 at 18:10

1 Answer 1

0

Excel can directly convert paths to hyperlink. Either automatically, either by using a macro "=HYPERLINK(CELL)" and looping it.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .