Forum Discussion

Keep Calm's avatar
Keep Calm
Copper Contributor
Mar 01, 2018

export a hyperlink in a csv file

I am trying to create a csv file to import into a website I am building, I need the csv to include a cell which includes a hyperlinked word in html format.   I have a column which contains urls a...
Formulas & Functions
tips and tricks
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Mar 02, 2018

Hi there

 

I've made this Excel file for you that will take the URL and your description and turn it into <a href>.

 

You can populate the spreadsheet to produce your desired tags, then save the file as CSV which will convert your entries to text.

 

Let me know how it goes? 

 

Cheers

Damien

Taofeek's avatar
Taofeek
Copper Contributor
Nov 15, 2019

Damien_Rosario Hello, I need your help. I created a product CSV file and I would like the csv file directory to be opened with World Wide Web like loading a website URL and leads to the CSV file. 

 

Links are majorly accepted for products upload.

 

Could you please help me?

 

Thanks!

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Nov 25, 2019

    Hi Taofeek 

     

    Not sure I follow what you are wanting so let me try to understand.

     

    1. You have a product CSV file.

    2. You want the folder that has the CSV file to open in the web browser.

    3. Presumably there's only the CSV file in the folder so users can click onto it to open the CSV.

     

    If this is true, I'm curious to know:

    a. Where is the CSV currently stored?

    b. Why not just link directly to the CSV instead of the folder view?

     

    Cheers

    Damien

     

    • Liveandcapture's avatar
      Liveandcapture
      Copper Contributor
      Jul 19, 2022

      Hi Damien_Rosario 

       

      I have a CSV file that I am trying to upload to a Woocommerce E-com.

      Each SKU have a specific images link  like this one:

      https://asset.swarovski.com/images/$size_1000/t_swa103/b_rgb:ffffff,c_scale,dpr_auto,f_auto,w_auto/5257516_png/vittore-xl-ring--weiss--rhodiniert-swarovski-5257516.png

       

      When I upload the file WordPress tells me that he cannot find the picture and so I cannot create the SKU.

       

      I try the file you posted above without luck.

      Any chance you can help me out with this?

       

      Thank you so much

      Thomas

       

       

    • iamthemongoose's avatar
      iamthemongoose
      Copper Contributor
      Nov 27, 2021

      Hi Damien,

      Hopefully. you're still around in the forum to answer a quick question! Will your instructions above work for a hidden hyperlink? I have a spreadsheet that's for contact information, I have columns for different social media accounts. One column is say for Facebook with each link just saying Facebook until you click and it takes you that persons account. I'm assuming yes. and I'm also assuming that a hyperlink, is a hyperlink whether or not it's the actual URL or just a word to keep the column neat.

       

      Actually, upon review of your previous reply, I'm thinking what you call the "description" would be equivalent the word Facebook that I used to label the link!

      Thanks for any help you can provide!

      -Jeff

Resources