Follow the steps below to import data from a Google Spreadsheet:

 

Bring up the Data Source Creation Wizard, by navigating to Data->New Connection.  Connect to a Google Spreadsheet by clicking on Google Spreadsheet.

 

Enter your Google account credentials and select the spreadsheet you wish to connect to.

 

Select the sheet you wish to import.

Component	Description
1	Preview the data
2	Define the culture that will be used when parsing dates, numeric values and currencies

 

Before you click OK to complete the process, make sure field types are set correctly.  The type of a field directly affects the type of Dimensions created on it, and therefore affects the type of analyses it can be used with.  The type of field is indicated by an icon which is placed next to its name in the Preview box:

Icon	Meaning
	Text field
	Numeric field
	Date/Time field

In some scenarios, the automatically assigned type for a field may be incorrect.  If this happens, you can change the field’s type manually by right-clicking the field header and setting the correct field type.

See Also