Forum Discussion
Solved
Web csv plus api key
Hi I have a url that points to a CSV download from an cloud based CRM system Workbooks. I can successfully using Excel point to this external URL from the Data tab and selecting From Text. This r...
Duplicate post??
Try using Get Data -> Web. It will detect that it's a delimited file and load in the CSV for you.
HTH
Sacha
Sacha
Hey really sorry about the duplicate post. I seem to have lost the first one and then it came back. I did try the Web option yesterday but it didn't work. Today I tried after seeing your reply and it now works. Maybe yesterday was a bad day all round? Anyway it seems to be working now thanks very much for your help.
Peter
Duplicate post??
Try using Get Data -> Web. It will detect that it's a delimited file and load in the CSV for you.
HTH
Sacha