UPCOMING WEBINAR: Cluster analysis: Classic, powerful, and still worth knowing This article provides an overview of the different methods for importing data into Displayr. If you are relatively new to analyzing survey data, please read Find the Best Possible Data File before proceeding, as a lot of time can be saved by ensuring you have the best possible file format. Excel and CSV files may require additional setup depending on whether they have been exported as labels or values. Once you have your data, it's easy to import it into Displayr:
Requirements
- If your data file has more than 1,000 rows and 100 columns, you will require a professional Displayr license.
- Any file that's uploaded, regardless of format, must be less than 4GB in size.
- The size of a zipped file when unzipped can exceed 4GB in size.
- A file that takes longer than 2 minutes for Displayr to load will be considered too slow to work with and will time out.
Method
The most common method for importing your data is to go to Data Sources > Add Data or Data Sources > Plus (+) in your Displayr document.
Once clicked, you will see various options to import your data:
Next, select the location where your data is stored. Click on the links below for further details about each.
- Data files (.sav, .zsav, .xml, .sss, .mdd, .xls, .xlsx, .csv) stored on your computer or local drive via the Upload file button or drop your file here option.
- Data files saved in Cloud storage: Displayr Cloud Drive, Google Drive, OneDrive, Dropbox, Box.
- Data files made accessible as a URL.
- Custom R code via URLs and accessing other APIs.
-
Survey platforms:
- Qualtrics, Forsta (Decipher), and Unicom Intelligence. If you select one of these options, you will be prompted to enter your Base URL and API key to connect the data. These options allow you to schedule automatic data updates.
- SurveyMonkey, Alchemer, Question Pro, etc.. If you select one of these options, you will be prompted to log into your account and connect a survey. Note that these options do not allow automatic data updating.
- Database connections: SQL databases.
Using Displayr AI to tidy labels on import
Displayr AI can group and name variable sets in a smarter, more sensible way than our standard pattern matching if you are importing a data set. To do this across all variables in the data set on the initial import, check Use Displayr AI to tidy variable set names before selecting your data source.
Note about importing Excel/CSV data files
If you are importing an Excel or CSV file, you will be prompted with What's the next thing you plan on doing? Select one of the following options:
- Create visualizations, presentations or dashboards: your data will be imported as summary tables and can be used to create tables, calculations, and visualizations. This option is best for files that contain aggregated data tables. See How to Import Excel Tables into Displayr for more information.
- First create crosstabs, pivot tables, text categorizations, or advanced analyses. Then create visualizations, presentations or dashboards: your data will be imported as a data set where each column is a variable, and the variables can be used as inputs for further analyses, calculations, and visualizations.
Other methods for importing data
Here are some other ways to upload your data or project into Displayr:
- QPacks from Q Research Software.
- Pasting tables containing tabular data (e.g., tabular data tables from Excel).
- Custom R code using Calculation
> Custom Code and clicking on the page. The method depends on the data format. See the following for more information:
Next
Once you've imported your data, it's always a good idea to Check Your Data.