Spreadsheet FAQ

Is the data preview limit 10,000 rows?

Yes. To preview more than 10,000 rows, apply filter conditions to narrow your results.

Additionally, the Professional Edition's self-service data retrieval feature lets you export up to one million rows.

Why can I only preview 1,000 rows?

You can change the number of rows displayed in the Preview Rows setting. The default is 1,000 and the maximum is 10,000.

For details, see Overview.

Do spreadsheets support multiple sheets?

You can create spreadsheets with multiple sheets only in the Professional Edition. For more information, see Configure a spreadsheet.

Do spreadsheets support wrap text?

Can I use colors for value ranges?

How to count unique values in a field?

Create a new calculated field that uses a CASE WHEN expression to assign a value of 1 if the target field is not null. Then, add both this new calculated field and the original field to your spreadsheet. Alternatively, you can use custom SQL to count the occurrences of each value.

Do spreadsheets support snowflake models?

Yes.

Do spreadsheets support public access?

Yes.

Do spreadsheets support ownership transfer?

Yes. You can transfer ownership of a spreadsheet in a group workspace by changing the owner in its Properties. For more information, see Manage a spreadsheet.

Why is data missing after filtering?

When applying a filter, select the entire column to ensure all possible values appear in the filter selection list.

What are the download and export limits?

You can download a maximum of 20,000 rows across all sheets. If your data exceeds this limit, download it in batches. The maximum export file size is 2 MB.

How to remove the .00 format?