Results 1 to 7 of 7

Thread: API pull data into excel

  1. #1
    Millennial Club mydanes's Avatar
    Join Date
    Jul 2013
    Location
    Of course on my Ipad Clashing!
    Posts
    1,049

    Post API pull data into excel

    Hello - can someone direct me to a sample excel file - I use to have one and my computer crashed I dont remember where I got it but it was great - I had to put my api token in (which is not a problem) but it had a ton of awesome data i used to help me with my clan. Any help much appreciated. I do not know how to recreate what i had. Thanks a bunch.

    Justice - Leader of Lethal Demise #9QJJU9J8
    Level 22!!!

    Click Here to join the Lethal Family of Clans

  2. #2
    AdvoCat Extraordinaire meonhoc's Avatar
    Join Date
    Jun 2013
    Location
    Stay healthy, you all!! *hugs*
    Posts
    4,624
    You probably have the same source as the person posted here
    https://forum.supercell.com/showthre...-Data-in-Excel

    He provides his source link, follow the light....

    Nb: I asked my favourite search engine with keywords "clash excel api"
    Last edited by meonhoc; February 21st, 2020 at 01:55 PM.
    Welcome to the forum *Meow* ! Official Support : Choose your game. Report abuse/spam - UTC Time conversion (add your city)

    Valley info : Season 9 - Map - Basic rules - Chicken - Fuel station - Lucky bonus

    #AdvoCat :: Hay Day Lv 143♩♬ :: Defenseless TH10 :: Rushed TH12 ::

  3. #3
    Millennial Club mydanes's Avatar
    Join Date
    Jul 2013
    Location
    Of course on my Ipad Clashing!
    Posts
    1,049
    Thanks for the reply but that is what I also found with Google (My friend) but the link is no good anymore for the required spreadsheet. I spent hours with all different searches and no luck to the excel sheets that use to be out there. Hoping someone here can help.

    Justice - Leader of Lethal Demise #9QJJU9J8
    Level 22!!!

    Click Here to join the Lethal Family of Clans

  4. #4
    AdvoCat Extraordinaire meonhoc's Avatar
    Join Date
    Jun 2013
    Location
    Stay healthy, you all!! *hugs*
    Posts
    4,624
    Ah I see. File not found.


    1. Would it worth reaching out to the poster there if you absolutely want to do it with excel on local file?

    2. The poster make a VBA script on Excel to retrieve data from API in a JSON format. If you feel like programming with VBA, may be this can suit you: http://vba-tools.github.io/VBA-Web/
    3. Or while waiting for the next genius clasher/programmer to post here, I have seen people using a "donwload CSV" link provided by Clash of Stats (need to personalized the Player tag in each URL) to get player data directly in Google spreadsheet with a formula similar to this one

      Code:
      =importData("http://example.com/activities.csv")
      Drop this to a cell in google Spreadsheet.
    4. Import CSV into Excel via URL. Haven't tried but found a guide: http://www.kimgentes.com/worshiptech...spreadshe.html


    Ok, those are what I would try. Good luck!
    Welcome to the forum *Meow* ! Official Support : Choose your game. Report abuse/spam - UTC Time conversion (add your city)

    Valley info : Season 9 - Map - Basic rules - Chicken - Fuel station - Lucky bonus

    #AdvoCat :: Hay Day Lv 143♩♬ :: Defenseless TH10 :: Rushed TH12 ::

  5. #5
    Millennial Club mydanes's Avatar
    Join Date
    Jul 2013
    Location
    Of course on my Ipad Clashing!
    Posts
    1,049
    Thanks for the thoughtful response - I am sure someone besides me uses excel . I have tried the download player data but it is not quite what i am after and know what I am trying to do as a leader perspective hopefully someday I can get it figured out hehe

    Justice - Leader of Lethal Demise #9QJJU9J8
    Level 22!!!

    Click Here to join the Lethal Family of Clans

  6. #6
    Millennial Club mydanes's Avatar
    Join Date
    Jul 2013
    Location
    Of course on my Ipad Clashing!
    Posts
    1,049
    problem solved - i just learned with sidekick II i can type /export and it sends everything to excel for me that i wanted SUPER great news

    Justice - Leader of Lethal Demise #9QJJU9J8
    Level 22!!!

    Click Here to join the Lethal Family of Clans

  7. #7
    AdvoCat Extraordinaire meonhoc's Avatar
    Join Date
    Jun 2013
    Location
    Stay healthy, you all!! *hugs*
    Posts
    4,624
    Sidekick the Discord bot? And the code is maintained by its developpers.

    Great news indeed, thanks for sharing you solution, surely it will help others in the similar case.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •