How to Paste Table Data Into Displayr

This article describes how to paste tabular data from a spreadsheet...

...directly into Displayr as a pasted table.

If you wish to instead import tables directly from an Excel workbook, see How to Import Excel Tables Into Displayr.

Requirements

• A Displayr document.
• A tabular spreadsheet data (e.g. in Excel, or Google Sheets).

Method 1 - Copy and Paste

1. Select your spreadsheet table and copy it (right-click > Copy, or ctrl+c).
2. In your Displayr document, press CTRL+V to paste it in as an R table.
3. OPTIONAL: To change the formatting, select the table, go to Appearance > Appearance > Number format, and select the desired format (e.g., % or currency) and the number of decimal places to show. 
4. OPTIONAL: If at any point you wish to amend your data, select the table and in the object inspector go to Data > Data Source > Edit data.

Method 2 - Paste Table

1. Select your spreadsheet table and copy it (right-click > Copy, or CTRL+C).
2. In your Displayr document, go to Tables > Paste or Enter Table from the toolbar.
3. In the object inspector, go to Data > Data Source > Paste or type data.
4. Paste in the data by selecting CTRL+V.
5. Select OK. 
6. OPTIONAL: To change the formatting, select the table, go to Appearance > Appearance > Number format, and select the desired format (e.g., % or currency) and the number of decimal places to show. 
7. OPTIONAL: If at any point you wish to amend your data, select the table and in the object inspector go to Data > Data Source > Edit data.

See Also

How to Import Data Into Displayr

How to Import Excel Tables into Displayr