Forum Discussion

Peter14South's avatar
Peter14South
New Member
9 years ago
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...
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

  • Peter14South's avatar
    Peter14South
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

Peter14South's avatar
Peter14South
New Member
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    No problem - not a complaint.  Just wanted to make sure it wasn't a separate issue, rendering my duplicate answer redundant :)

     

    Glad it worked, today !

     

    Thanks

    Sacha