Hi everyone,
Currently all the Notion CSV export that have a 'relation' are exporting the item name + item hyperlink.
Is there a way to avoid this?
Help between Notion users
It's free & easy
Answers, votes & comments
Receive points, vote and give the solution
Hi everyone,
Currently all the Notion CSV export that have a 'relation' are exporting the item name + item hyperlink.
Is there a way to avoid this?
Hi,
You can also use a formula to convert your relation to text:
Create a new column, type formula, and set the formula to "substring([insert relation here],0). This will rewrite the content of the relation column as text.
You can then hide the relation column and do your extract csv.
Also, if you have a lot of relations and it is tedious, once you exported the csv, just select all you columns that have an hyperlink between parenthesis and CTRL+F and replace " (*)" (the space is important before the parenthesis since the export functions this way: item name + space + (hyperlink) ) with... nothing.
These are both annoying fixes but to this day I haven't found anything better.