# Copy or export data

Whether you need to quickly copy a few cells or export a full dataset, the Copy and Export features allow you share insights, build reports, or continue analysis in other tools. 

{% embed url="<https://phocassoftware.wistia.com/medias/by30fkgf9v>" %}
Gain more screen space and other tips (includes how to copy and export data)
{% endembed %}

## Copy data

{% hint style="info" %}
User permissions:  Query > Export > Clipboard
{% endhint %}

You can copy rows of data or individual cells in the grid to paste into another application, such as Microsoft Excel.

Select the row(s) or snippet of data, then either:

* Right-click the selection and click **Copy.**
* Press **CTRL**+**C** (or **CMD**+**C** on a Mac).&#x20;

{% embed url="<https://phocassoftware.wistia.com/medias/by30fkgf9v>" %}
Gain more screen space and other tips
{% endembed %}

## Export data

{% hint style="info" %}
User permissions:  Query > Export plus specific permission is required for each file type
{% endhint %}

You can export data as an email, PDF, XLSX, or other file type. Whatever data is displayed on your screen will be exported, with some limits on the size of the dataset.&#x20;

Click the **Export** button in the top right bar above the grid, then in the **Export** window, select the required export file type and click **Export**.

<div align="left"><figure><img src="https://content.gitbook.com/content/itAvDF3MljQXV0rjHRP7/blobs/oRzML7UdMi6F8rKmbpxY/3077243057.png" alt="" width="374"><figcaption></figcaption></figure></div>

### Export limitations <a href="#exportdata-exportlimitations" id="exportdata-exportlimitations"></a>

If you try to export too many rows or columns, some export options in the dropdown list will gray out and not be available. For example, if you tried to export 70,000 rows you might only see the CSV option.

Very large exports may return an error message. If this occurs, check that you really want to export the entire dataset. You can filter or make selections and focus to reduce the dataset to the information you require.

{% hint style="info" %}
XLSX exports support up to 1,048,576 rows and 16,384 columns.
{% endhint %}

### Export file types <a href="#exportdata-exportfiletypes" id="exportdata-exportfiletypes"></a>

The options that are available depend on the type of analysis you are doing.

<table><thead><tr><th width="131">Option</th><th>Description</th><th>Use</th></tr></thead><tbody><tr><td><strong>Print</strong></td><td><p>Converts the data currently on your screen into a print-friendly format.</p><p>Only data can be printed. The status bar displays automatically.</p></td><td><p>Select <strong>Export</strong> > <strong>Print</strong>. Then follow your usual printing process.  </p><p>You can also select <strong>Options</strong> > <a href="../get-more-options-for-viewing-data#getmoreoptionsforviewingdata-monochromeexports">Monochrome exports</a> to export and print in 'black only'.</p></td></tr><tr><td><strong>PDF</strong><br> </td><td><p>Exports as a PDF. </p><p>Only the data is exported. Selections or period ranges may not be visible in the exported file. Formatting, such as red data for negative values, carries across.</p></td><td>Select <strong>Export</strong> > <strong>PDF</strong>. Different browsers will handle an exported file differently. You may be prompted to open or save the file, or it may appear at the bottom of your screen or in your downloads folder.</td></tr><tr><td><strong>XLSX</strong><br> </td><td><p>Exports as a Microsoft Excel worksheet</p><p>Only the data is exported. Formatting such as red data for negative values carries across.</p><p>Sheet 1 of the worksheet contains the data and Sheet 2 contains information relating to the export such as selections and period ranges.</p></td><td><p>Select <strong>Export</strong> > <strong>XLSX</strong>. You may be prompted to open or save the file, or it may appear at the bottom of your screen or in your downloads folder.</p><p>See note on this page about limits on number of rows and columns.</p><p> </p></td></tr><tr><td><strong>CSV</strong></td><td>Exports as a CSV (Comma Separated Value) file, a  file format commonly used as an alternative import/export format.</td><td>Select <strong>Export</strong> > <strong>CSV</strong>. You may be prompted to open or save the file, or it may appear at the bottom of your screen or in your downloads folder. See note about limits on number of rows and columns.</td></tr><tr><td><strong>Email</strong></td><td><p>Emails your current analysis (data, chart or map) to a specified recipient. Only users with a valid username and password will be able to open the hyperlink to view the data. Permissions also apply, i.e., if a user is emailed data they would not normally have permission to view, they won't be able to open the hyperlink.</p><p>The 'from' name will be your username and the reply address your email address.</p><p>Administrators may need to add SMTP settings for this feature to function correctly.  </p></td><td>Select <strong>Export</strong> > <strong>Email</strong>. A screen will appear containing your own email address – you can replace this with another recipient's email address or enter multiple email addresses separated by a semicolon.</td></tr><tr><td><strong>KML</strong></td><td>Exports as a KML (keyhole markup language) file, a format used to display geographic data in an Earth browser or open source map. Use this option when exporting a map chart.</td><td>From a map chart, select <strong>Export</strong> > <strong>KML</strong>.</td></tr><tr><td><strong>Image</strong></td><td>Exports a chart as an image file. </td><td>From any chart, select <strong>Export</strong> > <strong>Image</strong>.</td></tr><tr><td><strong>Embed View</strong></td><td>Generates a link for embedding a favorite into another website (such as an intranet, or another product) for authenticated users to view. </td><td>From any favorite, select <strong>Export</strong> > <strong>Embed View</strong>. A new browser window opens with a unique embeddable URL, which can be copied and shared.</td></tr></tbody></table>