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.

Notes

There are more options listed in How to Paste or Enter a Table. For example, if you want to use the first column in your table as the row headers, and that doesn't happen automatically, via the object inspector uncheck Automatically detect row and column names and check the First column contains row names to use your first column as the row headers.

See Also

How to Import Data Into Displayr

How to Import Excel Tables into Displayr