Use Case

Syntax

Sample Usage

Troubleshooting

Additional Reso...

> Function to pull all possible providers available in Cryptosheets

![Overview](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csproviders-autocomplete.png)

![Syntax](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/google/functions/csproviders-autocomplete.png)





## Use Case

> **When you need to quickly look up a list of all available data providers using only a formula**

## Syntax

```
=CS.PROVIDERS( [provider], [globalArgs])
```

<div class="markdown">

**Parameter**|**Description**|**Required?**|**Example**
:-----:|:-----:|:-----:|:-----:
`provider` | Data provider, ex. Cryptocompare. | false | `Cryptocompare`
`globalArgs` | Optional: Global arguments, ex. limit, fields | false | `A10:B13`

</div>


## Sample Usage

**PROVIDERS All Available Providers Integrated with Cryptosheets**

Get a list of All Available Providers Integrated with Cryptosheets

*Excel*
> <typography-paragraph code copyable>&#x3D;CS.PROVIDERS(&quot;~&quot;,{&quot;_limit&quot;,&quot;500&quot;;&quot;_orderBy&quot;,&quot;name&quot;})</typography-paragraph>

*Google Sheets*
> <typography-paragraph code copyable>&#x3D;CSPROVIDERS(&quot;~&quot;,{&quot;_limit&quot;,&quot;500&quot;;&quot;_orderBy&quot;,&quot;name&quot;})</typography-paragraph>

![PROVIDERS All Available Providers Integrated with Cryptosheets](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPROVIDERS-example1.png)

**PROVIDERS with &#x27;coin&#x27; in their name**

Get a list of integrated Cryptosheets providers with &#x27;coin&#x27; in their name

*Excel*
> <typography-paragraph code copyable>&#x3D;CS.PROVIDERS(&quot;~coin&quot;,{&quot;_limit&quot;,&quot;100&quot;;&quot;_orderBy&quot;,&quot;name&quot;})</typography-paragraph>

*Google Sheets*
> <typography-paragraph code copyable>&#x3D;CSPROVIDERS(&quot;~coin&quot;,{&quot;_limit&quot;,&quot;100&quot;;&quot;_orderBy&quot;,&quot;name&quot;})</typography-paragraph>

![PROVIDERS with &#x27;coin&#x27; in their name](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPROVIDERS-example2.png)

**PROVIDERS with &#x27;crypto&#x27; in their name**

Get a list of integrated Cryptosheets providers with &#x27;crypto&#x27; in their name

*Excel*
> <typography-paragraph code copyable>&#x3D;CS.PROVIDERS(&quot;~crypto&quot;,{&quot;_limit&quot;,&quot;100&quot;;&quot;_orderBy&quot;,&quot;name&quot;})</typography-paragraph>

*Google Sheets*
> <typography-paragraph code copyable>&#x3D;CSPROVIDERS(&quot;~crypto&quot;,{&quot;_limit&quot;,&quot;100&quot;;&quot;_orderBy&quot;,&quot;name&quot;})</typography-paragraph>

![PROVIDERS with &#x27;crypto&#x27; in their name](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csPROVIDERS-example3.png)


> For a full list of global parameters, [Click Here](/functions/common/).



## See Also

[ENDPOINTS](https://docs.cryptosheets.com/functions/endpoints/) - Function to pull all possible endpoints by provider  
[EXCHANGES](https://docs.cryptosheets.com/functions/exchanges/) - Get all possible exchanges that are available for Cryptosheets core functions  
[PARAMETERS](https://docs.cryptosheets.com/functions/parameters/) - Function to pull all possible parameters by provider and endpoint  
[PROVIDERS](https://docs.cryptosheets.com/functions/providers/) - Function to pull all possible providers available in Cryptosheets  
[SYMBOLS](https://docs.cryptosheets.com/functions/symbols/) - Reference endpoint to pull all symbols supported by Cryptosheets core and non core functions  

---

### Troubleshooting

1. Check your formula syntax for carefully, different functions for the same data may have slightly different required syntax
2. Check the **required arguments** for your function vs the **optional arguments**
3. Check your data & API quotas and limits
4. Check your formulas carefully
5. Check your relative references
6. Use Excels **error checking tools**
7. <a href="https://support.office.com/en-us/article/function-arguments-65b29fb5-ec7b-4c0b-a54b-a67923571519" rel="noopener noreferrer" target="_blank">Check Excels help sections</a>
8. Error Response Codes Reference

   - **#N/A** OK – Everything worked as expected
   - **#BUSY** Heavy query and/or unauthorized – Your User/Password API Keys are incorrect
   - **#LIMIT** Forbidden – You are not subscribed to the data feed requested
   - **Other** Something else? Reach out to us directly

## Additional Resources

_For Microsoft Excel_

- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins" rel="noopener noreferrer" target="_blank">Web browsers used by add-ins</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets" rel="noopener noreferrer" target="_blank">Office versions and requirement sets</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version" rel="noopener noreferrer" target="_blank">How to check your Office version</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version" rel="noopener noreferrer" target="_blank">Install the latest version of Office</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture" rel="noopener noreferrer" target="_blank">Custom Function Requirements</a>

_For Googlesheets_

- <a href="https://developers.google.com/apps-script/guides/services/quotas" rel="noopener noreferrer" target="_blank">Throughput Quotas & Limits</a>


How to use the PROVIDERS custom function in Excel and Google Sheets