---
title: "Spreadsheet"
slug: "spreadsheet"
updated: 2025-03-12T16:28:18Z
published: 2025-03-12T16:28:18Z
canonical: "docs.datajet.app/spreadsheet"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Spreadsheet

Accessed from **Analytics | Spreadsheet**

Spreadsheets provide a quick way of exporting some basic summaries and counts from DataJet desktop into an xlsx file. Think of them like a scratchpad for getting quick data counts.

Note - Spreadsheets and DashboardsSpreadsheets are not currently supported in dashboards.

## Adding Data to a spreadsheet

Data is added to spreadsheets by the following mechanisms:

- Drag and Drop of analytical objects:
  - [Dataset](/v1/docs/spreadsheet#datasets)
  - [Venn](/v1/docs/spreadsheet#venn)
  - [Profiles](/v1/docs/spreadsheet#profiles)
    - Simple Profile
    - Index Profile
    - Multi-Function Profile
- [Copy and Paste](/v1/docs/spreadsheet#copy-and-paste)
- [Enter text manually](/v1/docs/spreadsheet#enter-text-manually)
- [Export from Data Audit](/v1/docs/spreadsheet#export-from-data-audit)

Data PermanenceNote: Once an analytical object is dropped onto a spreadsheet, it will be preserved as part of the spreadsheet data, even if the display text of the object is subsequently deleted.   To remove the object from the spreadsheet, select "Edit Script" and delete the object from the object list:  
![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1741777473494.png)

### Datasets

To drop a [dataset](/v1/docs/dataset) on a spreadsheet, first create the dataset, and drop the dataset object onto the spreadsheet grid. The query tree will be added.

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1741774841260.png)

### Profiles

To drop a [profile](/v1/docs/profiles-1) on a spreadsheet, first create the profile and then drop the profile report onto the spreadsheet. The profile grid will be added.

The following profile types are supported:

- [Profile](/v1/docs/profile)
- [Index Profile](/v1/docs/index-profile)
- [Multi-Function Profile](/v1/docs/multi-function-profile-getting-started)

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1741774250089.png)

### 

### Venn

To drop a [Venn](/v1/docs/venn) onto a spreadsheet, first create the Venn diagram and then drop the Venn report onto the spreadsheet. The Venn grid will be added to the spreadsheet.

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1741776029024.png)

### Copy and Paste

CTRL C and CTRL V will work within the spreadsheet object. Right-click in the spreadsheet to bring up the context menu:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1741795393753.png)

### Enter Text Manually

To enter text manually into the spreadsheet, select the cell and type as normal.

### Export from Data Audit

A new spreadsheet report can be created directly from the Data Audit report by selecting Spreadsheet:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1741795571948.png)

A new spreadsheet will be opened, and the following tabs will be created:

- Fields
- Tables

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1741795678117.png)

## Refreshing data in a spreadsheet

Analytical objects that are added to a spreadsheet will automatically recalculate each time the spreadsheet opens - this means that if the underlying records change, the data in the spreadsheet will also change.

Note:Data Audit tabs are not analytical objects - they contain static text

## Exporting data from a spreadsheet

Data can be "exported" from a spreadsheet by saving the spreadsheet as a *.xlsx file:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1741795284081.png)