4 4
4 4

Default Alternative to excel for pulling api data

by
chini
chini
Profile picture of chini
chini
Posts: Threads: Thanks: Account age: less than a second
3 replies
Hi Guys,

Pulling lots of data from semrush and moz, currently using excel its choppy as hell. Freezes, slow and crap.

Is there any alternative tools out there which i can look at for pulling huge amounts of api data?

Any suggestions would be very much appreciated and thanked!

Cheers,
Chini
#alternative #api #data #default #excel #pulling
  • Profile picture of the author elcidofaguy
    elcidofaguy
    elcidofaguy
    Profile picture of elcidofaguy
    elcidofaguy
    Posts: Threads: Thanks: Account age: less than a second
    Then in that case you need to know about databases and programming... You could try ms-access/vba for starter's which will be an improvement over excel any day... Going beyond that you're now looking at real robust RDMS like SQL-Server or Mysql... Btw - there probably are some COTS tools out there that meets most of your needs....
    Signature
    Clickbank Affiliates. Are You One Of The 95% That Struggle To Make An Online Income? Introducing The Game Changing Strategy That You Need to Know About... Click Here!
  • Profile picture of the author MikeFriedman
    MikeFriedman
    MikeFriedman
    Profile picture of MikeFriedman
    MikeFriedman
    Posts: Threads: Thanks: Account age: less than a second
    Netpeak Checker might work for what you want.
  • Profile picture of the author Rembo
    Rembo
    Rembo
    Profile picture of Rembo
    Rembo
    Posts: Threads: Thanks: Account age: less than a second
    There are several ways in which you can use Excel to pull data from websites.

    The easiest and most straight forward method is by using the website query option which is available right from the menu. But as you already noticed that can be a bit unreliable.

    A more sophisticated way is to use VBA to do the extracting. Again, there are several options available.
    I mostly use XMLHTTP object for this type of task. I wrote a small piece of code that you can find for free on (one of) my website(s).

    Good luck!

    Originally Posted by chini View Post

    Hi Guys,

    Pulling lots of data from semrush and moz, currently using excel its choppy as hell. Freezes, slow and crap.

    Is there any alternative tools out there which i can look at for pulling huge amounts of api data?

    Any suggestions would be very much appreciated and thanked!

    Cheers,
    Chini
    Signature
    Smarter Affiliate Money. Work Smarter, Earn More.

Trending Topics