Home

export a hyperlink in a csv file

%3CLINGO-SUB%20id%3D%22lingo-sub-166943%22%20slang%3D%22en-US%22%3Eexport%20a%20hyperlink%20in%20a%20csv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166943%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20csv%20file%20to%20import%20into%20a%20website%20I%20am%20building%2C%20I%20need%20the%20csv%20to%20include%20a%20cell%20which%20includes%20a%20hyperlinked%20word%20in%20html%20format.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20a%20column%20which%20contains%20urls%20and%20I%20need%20to%20create%20another%20column%20which%20includes%20the%20html.%20So%20cell%20A2%20contains%20%3CA%20href%3D%22https%3A%2F%2Fexample.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexample.com%3C%2FA%3E.%20I%20want%20cell%20A3%20to%20contain%20%3CA%20href%3D%22%26quot%3B%26lt%3BSPAN%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fexample.com%26quot%3B%26gt%3BPreview%26lt%3B%2Fa%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexample.com%22%26gt%3BPreview%3C%2FA%3E%26gt%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI%20am%20a%20bit%20lost%2C%20any%20help%20is%20appreciated%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-166943%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881937%22%20slang%3D%22en-US%22%3ERe%3A%20export%20a%20hyperlink%20in%20a%20csv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881937%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks.%20Has%20helped%20me%20as%20well%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167657%22%20slang%3D%22en-US%22%3ERe%3A%20export%20a%20hyperlink%20in%20a%20csv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167657%22%20slang%3D%22en-US%22%3EGlad%20to%20help!%3CBR%20%2F%3E%3CBR%20%2F%3EAll%20the%20best%20friend.%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3EDamien%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167158%22%20slang%3D%22en-US%22%3ERe%3A%20export%20a%20hyperlink%20in%20a%20csv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167158%22%20slang%3D%22en-US%22%3E%3CP%3Eworked%20great%2C%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-167069%22%20slang%3D%22en-US%22%3ERe%3A%20export%20a%20hyperlink%20in%20a%20csv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-167069%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20made%20this%20Excel%20file%20for%20you%20that%20will%20take%20the%20URL%20and%20your%20description%20and%20turn%20it%20into%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E.%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20populate%20the%20spreadsheet%20to%20produce%20your%20desired%20tags%2C%20then%20save%20the%20file%20as%20CSV%20which%20will%20convert%20your%20entries%20to%20text.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet%20me%20know%20how%20it%20goes%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheers%3C%2FP%3E%0A%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166968%22%20slang%3D%22en-US%22%3ERe%3A%20export%20a%20hyperlink%20in%20a%20csv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166968%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20your%20response%2C%20I%20think%20you've%20understand%20what%20I'm%20trying%20to%20achieve.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%20if%20I%20have%20cells%20like%20A3%20on%20your%20example%20and%20save%20them%20as%20a%20csv%20they%20would%20be%20saved%20as%20text%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20other%20part%20that%20I'm%20still%20struggling%20with%20and%20I'm%20not%20sure%20I've%20explained%20is%20how%20I%20create%20your%20A3%20from%20A2%2C%20I've%20tried%26nbsp%3B%3CA%20href%3D%22%26quot%3B%24A2%26quot%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EPreview%3C%2FA%3E%20and%20various%20derivatives%2C%20but%20without%20success%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166959%22%20slang%3D%22en-US%22%3ERe%3A%20export%20a%20hyperlink%20in%20a%20csv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166959%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20attached%20something%20similar%20to%20what%20you%20have%20asked%20(assuming%20I%20understand%20you%20right).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECSV%20files%20don't%20do%20hyperlinks%20as%20it's%20text%20based%2C%20so%20all%20cells%20are%20whatever%20you%20make%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20if%20this%20is%20helpful%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheers%3C%2FP%3E%0A%3CP%3EDamien%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Keep Calm
Occasional Contributor

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 and I need to create another column which includes the html. So cell A2 contains https://example.com. I want cell A3 to contain <a href="https://example.com">Preview</a>

 

I am a bit lost, any help is appreciated

6 Replies

Hi there

 

I have attached something similar to what you have asked (assuming I understand you right).

 

CSV files don't do hyperlinks as it's text based, so all cells are whatever you make them.

 

See if this is helpful?

 

Cheers

Damien

 

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

worked great, thanks

Glad to help!

All the best friend.

Cheers
Damien

@Damien Rosario 

 

Many thanks. Has helped me as well

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies