I think you’re right, I just tried it again. I ended up opening up my file from OneDrive and getting the path from Info.
I am though experiencing #N/A errors. See the below screenshot (ignore my chocolate and lottery. 
)
I’m not 100% sure about the formula, but based on the template, I think the first column isn’t bringing everything across.