# Download Data

## The four ways to download data

1\. Download data in a single column of a Visual Spreadsheet In a Visual Spreadsheet, click on the column Hamburger menu, then "Download" to download just the data from the column.

2\. Download data in an entire Visual Spreadsheet In a Visual Spreadsheet, clicking on the download icon in the upper right corner of the spreadsheet.

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-Lscx2cTYVV84ZesgpEe%2F-LscxespX-umQLFNuMs4%2FScreen%20Shot%202019-11-01%20at%202.51.29%20PM.png?alt=media\&token=2cc6bc2a-4f0e-46bb-88c5-71a5a35d67f4)

3\. Bulk download a whole dataset file Click top banner "**Data Sets**" to navigate to the dataset of your interest, where a **download url** link is in the page. You can also reach the dataset page by clicking on the column Hamburger menu, then "**About**".  Click on the **download url** to download the entire dataset. Or use "wget", "curl" to download from command line.&#x20;

4\. Via our APIs:

* [**Python**](https://ucsc-xena.gitbook.io/project/overview-of-features/accessing-data-through-python) &#x20;
* [**R**](https://cran.r-project.org/web/packages/UCSCXenaTools/vignettes/USCSXenaTools.html) &#x20;

## **How do I open the download files?**

Our files are tab-delimited or '.tsv'. We recommend opening them on the command line if you hare able.

If you not able to use the command line then we recommend using your favorite spreadsheet program, such as Microsoft Excel, which will automatically convert the tabs into new columns. Please note that if you have many thousands of samples, Microsoft Excel will likely have difficulty opening the file.&#x20;

{% hint style="warning" %}
Please be careful when using Microsoft Excel to open files with gene names as Microsoft Excel will automatically convert some gene names into dates. For more information see: <https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7>
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://ucsc-xena.gitbook.io/project/overview-of-features/download-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
