Export CSV files
Export any cell as a CSV file.
Last updated
Export any cell as a CSV file.
Last updated
After selecting any SQL, Python or visual cell, the option to download results as a CSV file will appear in the floating cell controls. If all cell results are available locally, a CSV file will be generated and downloaded immediately. If the result set is too large to be held locally, Count will execute a new query with no row limit, and the results will be downloaded as a formatted CSV file. (Result size limits of 128MB apply, so if your result set is very large, your download may not contain all rows).
This option will not be available if it has been disabled in your workspace settings.
If your visual has multiple marks, only the first mark will be downloaded.
Right-clicking on a cell (or using the canvas menu in the upper-left) will present the option to Copy as CSV. This action will never execute a new query (unlike the Download CSV option above), but will instead copy the current results for that cell to the clipboard. The copied CSV text will only contain the number of rows that are currently indicated in the cell footer.
Once CSV data has been copied, pasting back into the canvas using the keyboard shortcut will create a new CSV cell . This is a useful shortcut to save a copy of some cell results at a certain point in time.
Copied CSV data is designed to be compatible with popular spreadsheet applications, such as Microsoft Excel or Google Sheets. Pasting CSV data from Count into a spreadsheet will add the pasted data as new cells, and pasting copied spreadsheet ranges into Count will add a new CSV cell.
