How to Import Data or Tables from Google Drive

Requirements

Please note this requires the Data Stories module or a Displayr license.

• If you are relatively new to analyzing survey data and plan to import data rather than tables, please read Find the Best Possible Data File before proceeding, as a lot of time can be saved by making sure 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.)
• A Google Drive account with a data set or data tables (.sav, .zsav, .xml, .sss, .mdd, .xls, .xlsx, .csv) saved in it.
• A Displayr document.

Method

1. Select Data Sources > Plus (+) > Google Drive.

2. Click Sign in with Google.

3. Enter your Google user credentials or select the correct user account if already signed in.

4. Click Allow.

5. Select the appropriate folder and then click the file you wish to import. Make sure that you have the file set up to be shared with Anyone with the link.

6. OPTIONAL: To update your file, select your data set in the Data Sources tree and press Update > Google Drive in the object inspector.

Next

Once you've imported your data, it's always a good idea to Check Your Data.