How to export data to Google Sheet/Excel

Competition Scouting
1

I’m working on my app right now and I don’t know how to export the data to either Google Sheet/Excel. Is there any way or tutorial video that I can watch in order to do it?

2

Knowing what language you’re programming your app in might help.

3

What we did in the past was generate a csv file.

4

As @AriMB mentioned, it depends on what your app is programmed in and capable of. However, when going in to Google Sheets, you can get live data from an external source if it is pushing in one of these formats:

  • RSS or ATOM using the =importfeed function
  • HTML lists or tables using the =importhtml function
  • CSV or TSV using the =importdata function
  • XML (plus HTML, CSV, TSV, RSS, and ATOM) using the =importxml function
  • Data in another Google Sheet using the =importrange function
  • As a bonus if you would like to import data from a JSON file, you can use a custom script to create the =importjson function

Those all assume you are posting data in real time (or at least on a regular basis) to a location on the web. If you are looking to export a file and import the data manually into Google Sheets or Excel later, it is easiest to export a CSV and import that later.

1 Like
5

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.