Optionally, uncheck Use first row as headers.

In the connectors panel, select Google Sheets.

In the top left, click, then select Data Source.

The first step in creating a data source is to connect to your data set. In this case, it's best to not include the totals row in the data source and instead, let Data Studio calculate the totals. Scorecards in Data Studio would display inflated numbers for each of the fruit dimensions (because it adds the totals to the un-aggregated metrics): For example, let's say the wide table above included a Totals row: Date If you do, the numbers in those charts might not be correct. If your Sheet includes aggregated data, such as sums, averages, medians, etc., be careful not to mix that data with unaggregated data in Data Studio charts. For example, in the long table example, it's easy to build a filter on Fruit = 'Apples.' In the wide table example, you can't filter by type of fruit. Grouping your data series into dimensions also makes filtering in Data Studio easier. This would be impossible to display in a Data Studio chart. If you sold 100 varieties of fruit, you'd need 100 dimensions to measure them all using the second example. In the long table example, your data source only requires one dimension for the Fruit category, whereas the wide table example requires one dimension for each type of fruit. For example, if you are measuring sales of fruit from a grocery store, doing this: Date Limit the number of dimensions by grouping data into categories, rather than having columns for each possible value. Organizing your data in certain ways can make it easier to work with in Data Studio. Learn more about handling dates and times in Data Studio. Other ways of handling dates are possible, but may require more work on your part. Date fields should be formatted as dates (using the Format > Number > Date menu option in Sheets).If you have time data, it should be combined with the date field, for example, 11:55:30.

Dates in your Google Sheet should contain the full day, month, and year, for example, or .

$answer key for all worksheets$

These will become the field names in your data source.

The first row of the data should contain column headers.

Cells should only contain data: you can't import graphs or images, for example.

Each column should contain only single cells: merged cells may cause your data to appear incorrectly.

The worksheet or range you connect to should have a simple tabular format.

Answer key for all worksheets