Cool video. I like Looker Studio but have an annoying problem with Google Sheets. Why can't I upload Excel files (which automatically convert to Google Sheets with that option in Settings) to the folder where my Google Sheets reside without any changes to the report? People at Google recommend making changes directly in the Google Sheets, but this is not convenient when a report is based on several of these sheets. I thought it would be so easy to just replace the Google Sheets and reconnect, but no, it is not that simple. Any recommendations?
Hey JJ, thank you for the explanation. It was quite easy to understand. I am having trouble with a Google Sheet with several worksheets and formula behind it. The worksheets header does not start from 1st row of the sheet. The header of one table starts from 4th row and after 9th row there is some text and then another table and its respective header. Both tables are in same sheet. Similar tables in other worksheets as well. All the cells have different formula behind it. How can I import import such sheets in Looker studio along with its formula. Could you please help me? Thank you.
You can use a range import and use something like C4:H which will start at C4 and take the range to H But if you have text and formatting below that it might not work. Let me know if that works! - JJ
Hey! Can you create a video where you show. How to take google sheets and send it looker studio and recreate the type of visual presentation you are showcasing in your cheatsheets. A step by step tutorial. Just something simple so the workflow becomes clear.
Great Video, thank you so much. My question is, I'm creating a report for each grade level. I want the same information and just change the filter to change grade levels. what I am doing re connecting the same google sheet data for each page. Then I have to Drag and drop the fields to recreate my table and charts. Am I missing something? Each page needs a new set of data? Thank you so much..
Hey! Great video. I am having toubles adding data from my Sheets, since those have the data transposed, and have not found the way to make Looker Studio to take them. Any suggestions? 😅
Hey! What I would suggest is that you use functions in Sheets to transpose that data back in a new tab. Then connect that to looker studio. Best of luck! - JJ
@@Vision-Labs but this one is a sheet that is continuously updated, any pther ideas on how to do this? Or in how to solve it on the Looker Studio side?
@@valeria-flexfire honestly, there are a lot of options & possibilities You could Import Range into another sheet & Trasnpose table in a different tab. Or use the Query= function Its hard to say without seeing things.
I am trying to create a searchable company directory. I tried different controls but can't figure out how to allow the user to search without case sensitivity. Any suggestions?
Hey Brittani! The easiest way is to lower case the search field ust for that chart So you can use lower(YOURFIELD) which will lowercase the directory search :) Hope that helps! -JJ
Hey thanks for the video, I have created a dynamic database in google sheet, which everyday user input data to it. It also contain formula that I used to give label each row. Can I connect a dynamic and formula contained google sheet to looker studio?
Hi JJ! maybe you can help me with this situation. I have problems with the data sources. I have a report for company A that pulls data from their Analytics account and a googlesheet for company-A. Today, I have "made a copy" this report (using that feature) to make a similar for company B but with the data of company B (of course ;) using a different analytics and a different googlesheet. The problem that I have now is that the report A is using the data sources of company B. Have you had this problem? How do I "unlink" this situation so they are independent regarless of the changes I do in each of them? Or how should I do this duplication process correctly? I hope my explanation was clear. thanks in advance!
Most likely you have a problem of the data source in Looker Studio being linked to the wrong sheet once you made a copy. Simply go into Looker Studio > Manage Data Sources > Edit connection & make sure you have the data connected to the correct sheet. Best of luck! - JJ
appreciate your help. The problem was that all the data sources were set are "reusable" and you can't undo that setting unfortunately. I had to add the sources as new @@Vision-Labs
@@ChotaMusonda if connecting to Google Sheets, try to refresh looker studio & sheets to make sure the latest version is showing up. Then make sure they are both in the same Google Account. LMK if that helps! - JJ
A good resource for making data sets is actualy chat gpt. You can give it columns and rows to build tables for you. There will not be a ton of data, but a few dozen rows is usually enough to play with. - JJ
Recently i started working with looker studio and spreadsheet, this is awesome thank you :)
Great to hear!!! Love it!
If you have not joined the email list & cheatsheet yet you can always do that here -> LookerStudio.VIP/TH-cam
17 minutes well spent.. thank you!
So glad this was helpful for you!
- JJ
Great info...thanks for digging into the "optional range" feature of connecting to the data source.
this was very helpful!!
thank you so much for the introduction 🔥
Of course! and if you need a deeper dive just let us know the questions you have!
- JJ
Great video, very good explanation. Thanks a lot 👍
Thank you!
-JJ
Cool video. I like Looker Studio but have an annoying problem with Google Sheets. Why can't I upload Excel files (which automatically convert to Google Sheets with that option in Settings) to the folder where my Google Sheets reside without any changes to the report? People at Google recommend making changes directly in the Google Sheets, but this is not convenient when a report is based on several of these sheets. I thought it would be so easy to just replace the Google Sheets and reconnect, but no, it is not that simple. Any recommendations?
Very helpful video, thanks for making it
Glad you enjoyed it!
Thanks. Very helpful. How would I sort the "Transaction Date" column in your example, please?
Worked it out, thanks!
Time well spent. 👍
Thank you!
- JJ
Super helpful, thank you!
Glad I could help!
- JJ
Thanks. Great content!
Glad we can help!
- JJ
thanks this is super helpful!
Yay! So glad it helped you out @Matthew!
- JJ
Hey JJ, thank you for the explanation. It was quite easy to understand. I am having trouble with a Google Sheet with several worksheets and formula behind it. The worksheets header does not start from 1st row of the sheet. The header of one table starts from 4th row and after 9th row there is some text and then another table and its respective header. Both tables are in same sheet. Similar tables in other worksheets as well. All the cells have different formula behind it. How can I import import such sheets in Looker studio along with its formula. Could you please help me?
Thank you.
You can use a range import and use something like
C4:H
which will start at C4 and take the range to H
But if you have text and formatting below that it might not work.
Let me know if that works!
- JJ
Hey! Can you create a video where you show. How to take google sheets and send it looker studio and recreate the type of visual presentation you are showcasing in your cheatsheets. A step by step tutorial. Just something simple so the workflow becomes clear.
Hey!
Yeah I will try to do something here on TH-cam like that.
Just a side note is we do this a lot in The Lab -> visionlabs.com/lab
-JJ
Great Video, thank you so much. My question is, I'm creating a report for each grade level. I want the same information and just change the filter to change grade levels. what I am doing re connecting the same google sheet data for each page. Then I have to Drag and drop the fields to recreate my table and charts. Am I missing something? Each page needs a new set of data? Thank you so much..
I would try to put all the information into a single sheet and use filters and parameters to limit by grade or instructor etc.
Hey! Great video. I am having toubles adding data from my Sheets, since those have the data transposed, and have not found the way to make Looker Studio to take them. Any suggestions? 😅
Hey!
What I would suggest is that you use functions in Sheets to transpose that data back in a new tab.
Then connect that to looker studio.
Best of luck!
- JJ
@@Vision-Labs but this one is a sheet that is continuously updated, any pther ideas on how to do this? Or in how to solve it on the Looker Studio side?
@@valeria-flexfire honestly, there are a lot of options & possibilities
You could Import Range into another sheet & Trasnpose table in a different tab.
Or use the Query= function
Its hard to say without seeing things.
I am trying to create a searchable company directory. I tried different controls but can't figure out how to allow the user to search without case sensitivity. Any suggestions?
Hey Brittani!
The easiest way is to lower case the search field ust for that chart
So you can use lower(YOURFIELD) which will lowercase the directory search :)
Hope that helps!
-JJ
❤❤❤❤❤❤❤❤
Hey thanks for the video, I have created a dynamic database in google sheet, which everyday user input data to it. It also contain formula that I used to give label each row. Can I connect a dynamic and formula contained google sheet to looker studio?
Yes, you can. Shouldn't be any problems referencing a sheet containing formulas.
Hi JJ! maybe you can help me with this situation. I have problems with the data sources. I have a report for company A that pulls data from their Analytics account and a googlesheet for company-A. Today, I have "made a copy" this report (using that feature) to make a similar for company B but with the data of company B (of course ;) using a different analytics and a different googlesheet. The problem that I have now is that the report A is using the data sources of company B. Have you had this problem? How do I "unlink" this situation so they are independent regarless of the changes I do in each of them? Or how should I do this duplication process correctly? I hope my explanation was clear. thanks in advance!
Most likely you have a problem of the data source in Looker Studio being linked to the wrong sheet once you made a copy.
Simply go into Looker Studio > Manage Data Sources > Edit connection & make sure you have the data connected to the correct sheet.
Best of luck!
- JJ
The issue is that when I update it to correct it, then it also updates it in the other report and I don't want that to happen.@@Vision-Labs
You will need to "duplicate" the Looker Studio data source as well @@milimann2739
appreciate your help. The problem was that all the data sources were set are "reusable" and you can't undo that setting unfortunately. I had to add the sources as new @@Vision-Labs
Hey man, failed to access my google sheets docs from my drive? Any help
It kept on telling me "spreedsheet not found" any help
@@ChotaMusonda if connecting to Google Sheets, try to refresh looker studio & sheets to make sure the latest version is showing up.
Then make sure they are both in the same Google Account.
LMK if that helps!
- JJ
hi, could I import more than one google sheet in one looker document? thank you.
Yeah! You can have up to 50 data sources (sheets) in a single looker studio document
Hi I have 3 lakh record how can I load that google sheet in gds
Hey there, I’m not 100% sure what you are asking
-JJ
Does anyone have a favorite app for generating fake data?
A good resource for making data sets is actualy chat gpt. You can give it columns and rows to build tables for you.
There will not be a ton of data, but a few dozen rows is usually enough to play with.
- JJ
where's waldo?
Usually Waldo is hiding 🙈
-JJ