How to Import Table Data into Displayr

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

...directly 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 and go to Properties > APPEARANCE > Number format and select the desired format (e.g., % or currency) and the number of decimal places. 
4. OPTIONAL: If at any point you wish to amend your data, select the table and in the object inspector go to Inputs > 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 Home > Paste Table.
3. In the object inspector, go to Inputs > 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 and go to Properties > APPEARANCE > Number format and select the desired format (e.g., % or currency) and the number of decimal places. 
7. OPTIONAL: If at any point you wish to amend your data, select the table and in the object inspector go to Inputs > DATA SOURCE > Edit data.

Method 3 - Import as a Table

1. Go to Home > New Data Set.
2. Either click My Computer and select your Excel file, or drag and drop the file into the Drop your file here or click to browse window.
3. When Displayr detects tabular data, you will be prompted to choose between adding your data as a table or adding it as a data set. Select Add as a table and select Next. 
4. OPTIONAL: To change the formatting, select the table and go to Properties > APPEARANCE > Number format and select the desired format (e.g., % or currency) and the number of decimal places. 
5. OPTIONAL: If at any point you wish to amend your data, select the table and in the object inspector go to Inputs > DATA SOURCE > Edit data.

See Also

How to Import Data into Displayr