Forum Discussion
export a hyperlink in a csv file
Thanks for your response, I think you've understand what I'm trying to achieve.
So if I have cells like A3 on your example and save them as a csv they would be saved as text?
The other part that I'm still struggling with and I'm not sure I've explained is how I create your A3 from A2, I've tried <a href="$A2">Preview</a> and various derivatives, but without success
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
- TaofeekNov 15, 2019Copper Contributor
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_RosarioNov 25, 2019Silver Contributor
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
- LiveandcaptureJul 19, 2022Copper Contributor
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
- RichardRabbittSep 30, 2019Copper Contributor
- Keep CalmMar 02, 2018Copper Contributor
worked great, thanks
- Damien_RosarioMar 05, 2018Silver ContributorGlad to help!
All the best friend.
Cheers
Damien