Export cards with hyperlinks, edit in Excel and import again

I have a card deck that has hyperlinks in Anki. Now I would like to export it and add additional info via Excel Vlookup (Sverweis) formula.
When I export as plain text, the link is gone from the txt file.
When I export as .apkg, I can`t open it with Excel.
Do you have any suggestion for me?

Ok, now I can give myself an answer… The understanding was simply wrong about Anki. The links are not transported to and from Anki via the text file. Instead, the text file can feed Anki and the Link can be defined in the Card Layout. If the link shall be different PER CARD, then it is possible to enter a variable in the link of the fixed CARD Layout and value of this variable depends on a value in a column of the text file.