Data Studio
4.9K members online now
4.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Using sheets to bring in data - can I get data studio to read across the rows?

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

I'm using Data Studio to visualize my MailChimp metrics. To do this I download the MailChimp's CSV and load it into Data Studio. The problem is, the CSV reads left to right across the rows rahter than down the columns. So the title of each metric is at the beginning of the row rather than at the top of the column. Data Studio defaults to reading these files via the column header. Is there a way to change this so it reads left to right? 

Using sheets to bring in data - can I get data studio to read across the rows?

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

Data studio don't support any transformation at all, you need to use a tool to clean your data and shape it in a tabular format, personally I use PowerQuery/Excel for that

Using sheets to bring in data - can I get data studio to read across the rows?

Explorer ✭ ✭ ☆
# 3
Explorer ✭ ✭ ☆

Don't think it's possible. You would better use Sheets to convert your rows to column and then connect your spreadsheet to Data Studio.

Re: Using sheets to bring in data - can I get data studio to read across the rows?

Follower ✭ ☆ ☆
# 4
Follower ✭ ☆ ☆
you can convert columns to rows in sheets?



--
*Dennis Driscoll *l senior manager, digital marketing l
401.453.4748 l ddriscoll@addventures.com

*(add)ventures* *is a multidisciplinary brand culture and communications
firm.*

www.addventures.com l www.facebook.com/addventurists l
www.twitter.com/addventures

Using sheets to bring in data - can I get data studio to read across the rows?

Explorer ✭ ✭ ☆
# 5
Explorer ✭ ✭ ☆