---
schema_version: "1"
id: d3ff35805a262247f062e3f980ceafca91d597b1ded6ff3ecddb41203113c047
title: Create a Data Source or Add a New Connection with Clipboard Data
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/public/desktop/clipboard_datasource.md
canonical_url: https://help.tableau.com/v0.0/public/desktop/en-gb/clipboard_datasource.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 9a3430716e39c87fb3663c93416c6134d48ab8c430dddc6f937a224955fbc19e
description: Copy and paste data directly into Tableau to create a data source for quick analysis.
---
[Skip to main content](#main-content)

# Create a Data Source or Add a New Connection with Clipboard Data

Sometimes you want to pull in data from an outside source for some quick analysis. Rather than create a whole data source and then connect in Tableau, you can copy and paste the data directly into your workbook. Tableau automatically creates a data source that you can begin analysing.

When you paste data on the data source page, Tableau creates a new connection in the existing data source.

When you paste data on the sheet, Tableau creates a new data source that you can begin analysing.

You can copy and paste data from a variety of office applications including Microsoft Excel and Microsoft Word. You can also copy and paste HTML tables from web pages. Tables that are copied as comma separated values or tab delimited can be pasted into Tableau.

Note: Not all applications use these formats when copying.

1. Select the data you want and copy it to the clipboard.
2. Open Tableau Desktop and do one of the following:
    
    1. On the data source page, select Data > Paste Data as Connection or Paste Data as Data Source.
        
        ![The Data dropdown menu showing the Paste Data as Connection and Paste Data as Data Source menu options.](/tableau/next/en-gb/public/desktop/en-gb/Img/clipboard_datasource_datasourcepage.png)
    2. On the sheet, select Data > Paste to paste the data as a data source.
        
        ![The Data dropdown menu showing the Paste menu option.](/tableau/next/en-gb/public/desktop/en-gb/Img/clipboard_datasource2.png)