I worked with an editorial team for this project. And editorial teams love working in Google Docs.
But managing them can be a bear because sometimes you have to have multiple Google Docs open in different tabs to provide context for the research you’re doing. So I’ve been exposing the team to crazy techniques like dynamically pulling a data set from one spreadsheet in Google Sheets into another using the IMPORTRANGE function in Google Sheets.
If you’d prefer to watch the process I created a video walkthrough. However, there are some adult keywords in the spreadsheet, so if you’re easily offended, you might want to pass.
For those who don’t want to watch a video, I will provide a rough sketch of the steps I took below. If they don’t make sense watch the video. (Duh.)
Grab the key from the URL of the Google Doc you want to import.
Take note of the columns or range you want to import. You can import entire columns by entering something like Tab Title!A:F. Or, for a specific range, something like Tab Title!A6:F100.
In the cell you want the data to import into, enter the following formula:
Of course, you’ll switch out my key and range for your own. Alternatively, you can drop each of these values into a cell and just reference the cells. If you do that, you won’t need the quotation marks. It would look something like:
Format your data. I demonstrate how I formatted mine in the video. (For those of you who know I’m not a big fan of the color pink, those are YourTango’s [current] branded colors. We have an updated look coming though, which I’m all too relieved about!)
You can learn more about data formatting in my Annielytics Dashboard Course, a video course that will teach you how to put your data in stilettos and work the pole. 🙂
If you would like to learn more about Excel, check out my Excel dashboard course. 24 instructional videos, totaling 6+ hours of instruction for $95.