Filtering Data

Sheet Best lets you filter rows directly from the URL using exact values and wildcard matching (*). For numeric or date comparisons (>, <, >=, <=), see the querying guide.

Filter by a single column

Append /<Column Name>/<Value> to the sheet URL.

cURL

# Exact match
curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/Jane Doe'

# Contains "John"
curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/*John*'

# Starts with "Jane"
curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/Jane*'

# Ends with "Jane"
curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/*Jane'

JavaScript

fetch('https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/Jane Doe');
fetch('https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/*John*');
fetch('https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/Jane*');

Python

import requests

requests.get('https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/Jane Doe')
requests.get('https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/*John*')
requests.get('https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/Jane*')

Wildcard summary

Pattern	Matches
Jane	Exact value Jane
*Jane*	Anything containing Jane
Jane*	Starts with Jane
*Jane	Ends with Jane

Filter multiple columns

Use the /search endpoint and pass each column as a query parameter. Wildcards work here too.

cURL

# Rows where Name contains "John" AND Age = 56
curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/search?Name=*John*&Age=56'

JavaScript

fetch(
  'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/search?Name=*John*&Age=56'
);

Python

import requests

requests.get(
    'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/search',
    params={'Name': '*John*', 'Age': 56},
)

Case-insensitive search

Add search_ci=true to make matches case-insensitive.

curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/Name/*jane*?search_ci=true'
curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/search?Name=*JOHN*&search_ci=true'

Combine with tabs

Filters work on any tab. Place /tabs/<Tab Name> before the filter suffix. See the tabs guide for more.

# Single column on the "Admin" tab
curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/tabs/Admin/Name/*Arthur*'

# Multiple columns on the "Admin" tab
curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/tabs/Admin/search?Age=21&Name=*Mick*'

Next steps

• Querying data for numeric and date comparisons (__gt, __lt, ...).
• Pagination to limit how many rows are returned.