I’m trying to extract biographies from profiles on Instagram.
I have been trying to find the xpath of the biography on an Instagram profile to put in the ImportXML function but it always says “content empty”.
Does anyone know how to do it, also using different functions etc..
Thanks for reading,
Carlo
I want to extract the biographies but I can’t do it
New contributor
Locatelli Acquisition is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
You may try:
=let(Σ,importxml(A2,"//meta[@name='description']/@content"),
regexextract(Σ,"(?s)ons*Instagram:s*(.*)"))
0