---
agentTools:
  projectIndex: https://docs.thinknum.com/llms.txt
---

# Load data

You will be able to load Thinknum data to Google Sheets using our add-on. From there, you can download the file as different types of file extensions such as xlsx, csv, pdf, etc.

The Thinknum add-on supports all available datasets and tickers.

[block:api-header]
{
  "title": "Setup"
}
[/block]

Run Google Sheets and click "Add-ons" -> "Get add-ons". Search for "Thinknum" at the Google Add-ons pop up page and install it.

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/ec53aad-Screen_Shot_2018-06-11_at_7.47.37_AM.png",
        "Screen Shot 2018-06-11 at 7.47.37 AM.png",
        1986,
        1356,
        "#eeeeee"
      ]
    }
  ]
}
[/block]

Otherwise, you can install it via link.
<https://chrome.google.com/webstore/detail/thinknum/jlcnpleakhldpponcfbllccdbabgipin>

After installing the Thinknum add-on, click "Add-ons" -> "Thinknum" -> "Open". You can see the Thinknum add-on appear in a sidebar on the right side.

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/f3cda7f-Screen_Shot_2018-06-05_at_12.39.58_PM.png",
        "Screen Shot 2018-06-05 at 12.39.58 PM.png",
        2866,
        1642,
        "#f7f8f8"
      ]
    }
  ]
}
[/block]

[block:api-header]
{
  "type": "basic",
  "title": "Authorization"
}
[/block]

In order to load Thinknum data, first authenticate yourself. The `Version`, `Client ID`, and `Client Secret` are required to get an access token.

If you don't have a `client_id` and `client_secret`, then please contact us at <support@thinknum.com>.

[block:api-header]
{
  "title": "Query"
}
[/block]

After authenticating yourself, you can see the token in a text input which means you are authorized to use the Thinknum add-on and load data.

`Dataset`: All datasets are available.
`Tickers`: You can select one ticker or multiple tickers. e.g. `nasdaq:goog`, `nasdaq:mtch`
`Start`: The row number data will be loaded from.
`Limit`: The number of rows that will be loaded.
`Append rows`: Whether to append new rows or not.
`Include header`: Whether to load a header or not.

[block:callout]
{
  "type": "warning",
  "body": "Please note that the existing rows will be disappeared if `Append rows` is unchecked."
}
[/block]

This will load the data for that dataset / ticker combination requested.

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/6ff4f42-screencapture-docs-google-spreadsheets-d-1rVGK67uBvq6KwcUNLYxV6rpFpfaQAsTWW8YpftgUEjw-edit-2018-06-05-14_56_13.png",
        "screencapture-docs-google-spreadsheets-d-1rVGK67uBvq6KwcUNLYxV6rpFpfaQAsTWW8YpftgUEjw-edit-2018-06-05-14_56_13.png",
        2880,
        1652,
        "#ebecec"
      ]
    }
  ]
}
[/block]