I want to import data from following link into Google Spreadsheet


Which formula is appropriate to import?

  • Can you link to any documentation for those query parameters? Commented Jul 12, 2018 at 14:22

1 Answer 1


=GOOGLEFINANCE() is appropriate. But you can also use IMPORTDATA()

  • importdata is better option. Thanks
    – neo269
    Commented Mar 9, 2018 at 13:22
  • Any Idea on how to get the IMPORTDATA() function auto-refresh every 5 or 15 minutes using Google Script?
    – neo269
    Commented Mar 12, 2018 at 10:14
  • You might wanna just try changing recalculation in settings. If that doesn't work,stackoverflow.com/questions/40069891/…
    – TheMaster
    Commented Mar 12, 2018 at 11:54
  • Recalulation settings doesnt work for IMPORTDATA() function.
    – neo269
    Commented Mar 12, 2018 at 17:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.