How to get plain link with views-data-export module in CSV?
CSV is not an interactive format. When you export column with literal "link" in it's data, you get link in CSV.

Instead of exporting word column, with link added at rewrite or template level, export column that actually contains the URL you want. For nodes, this issue indicates that you should be able to use 'Path' field, description: 'The aliased path to this node.'.