API pulls using Excel/Power Query | API Development | TORN
API pulls using Excel/Power Query
  • IP MrRightSA [2652679]MrRightSA [2652679]
    • MrRightSA [2652679]
    • Role: Civilian
    • Level: 32
    • Posts: 157
    • Karma: 150
    • Last Action: 57 minutes
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Thread created on 18:41:52 - 28/06/21 (3 months ago)
    |
    Last replied 23:48:17 - 28/06/21 (3 months ago)
    I done a search of the forum for "Excel" and the last mention was over a year ago. Google Sheets on the other hand had lots of mentions.  

    What can Google Sheets do (or do better) that Excel/PQ can't? Or is it just that everyone prefers Sheets?
  •   Father [2131687]Father [2131687]
    • Father [2131687]
    • Role: Civilian
    • Level: 81
    • Posts: 1219
    • Karma: 3700
    • Last Action: 1 hour
    • Quote
    • Report
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:48:17 - 28/06/21 (3 months ago)
    Post link copied to clipboard Copy post link
    It is because Google Sheet uses platform called Google App Scripts. It is based on JavaScript so easier to use for people who are already familiar with JS. It effortlessly connects to most of Google's platforms. And it is cloud based. So, if your PC is off and you have a Google Sheets spreadsheet connected to Google App Scripts it would still update in the cloud. I believe the fact that Google Sheets are cloud based and Google app Scripts can run while you are not around, is the reason why it is so much more popular here rather than Excel.
    .
Reply
Thread Title: