Hey there stranger!

Sign up to get access.

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

About this Tutorial

Combine Databases and Backup Your Information Effortlessly - Learn how to merge two databases and compare backups with ease. Get all the information you need from past years and multiple sheets. Follow our step-by-step guide and simplify your data management today! 

Featured Formulas

Video Transcript

 Hey, so I have this database here in a sheet and I'm updating it every day. And I have another database in another sheet that is other information, but it's formed in exactly the same way. And I want to get those two together. Maybe this is useful if you have backups, if you want to compare backups or if you want to not backups.

In addition to backups, if you want to have extra information like from years past or something, maybe you have a database every year and now you're in 2020, or you're preparing for 2021 and you're like, oh, how do I grab 20 20, 20, 20 19, 20 18 data and put that all together? So here's. How I would do it.

Let's see if it works, because it's fun. We're gonna use some curly brackets. We're gonna create a settings page. It's gonna be really fun. So here's where we want, wanna put all data. We have a database one here. Now, if we had two sheets I could tell you exactly how to do that. You would just do equals you put in curly brackets.

Import range. Import range, not import range. And in import range, we're gonna have the spreadsheet url, something like. This can take the entire URL or just the id? We're gonna get the range, which is db. Nope. It's all, I think all and then exclamation point a. And then what we'd do is we would just combine these, right?

We would end this where is it? Here we go. We would end this, and then we would just do that all again for the next. Next one. Same exact thing, but we want to get from here. So let's look at that. And we also want to make this a lot less intense. Okay? So let's not do that. Let's do this. Let's make our lives a little easier.

We're gonna add a settings. I'm gonna call it settings. We're gonna go and this might work well too, abstract way. How, if you have a ton of different sheets, if you have 20 sheets for the last 20 years. So we're gonna do, let's do DB two. We're just gonna label that DB two.

We don't need all of these. Let me just quickly get rid of all of these. Things there. So we want URL in here, and then we want our SH here. Okay, so let's go here. I don't even want the entire url. I just want this. ID Really? Yeah, give me that id. It's called all, so I don't need to remember that. All A to B.

And then here we're gonna put the id. Okay. So we know we can label these. Absolutely. I'm just saving a little time here. We're just gonna have a label and now we can do DB three, DB four, as many as we want. But let's go back here. Let's do this equals, and we're gonna put in, actually, let's look at import range first.

What's gonna happen? I know what's gonna happen, but let's go walk through it. Settings U URL is B one and the range is settings. C one I missed something here. There we go. And so this is the exact same thing as in port range, except we are now abstracting a way that the information is over here, B one and B and C one.

And it gives us a reference and it says, allow access cuz we need to allow access to that sheet. That's cool. We're gonna do that. I'm gonna do that in a second. But let me show you what happens if we put this in a curly bracket already. We have not given access to it, and we're gonna try this. We're gonna try to add this here A to B to it.

So now we're gonna have two everything all in one, but it's gonna give us an error and this error is because we haven't yet given it access. So we, I'm gonna delete all of this stuff. So if you don't give it access it, you're gonna have errors. So just allow access and then we get truths, right? But we don't want just that.

We want everything. We want to add it. We wanna add in series import range. We're gonna ha use a semicolon here. If you have a different language setting, you might be different. And we're just gonna do DB one eight A. A no, A to B, that's what we're doing. And end curly bracket. And now we get a, we almost got another error.

Okay, we have this and then let me see how many, cuz we, I put the same name just so we would be able to tell. And now there's only one, there's two now. That was, there we go. So this one is false. And then I think this one is true, so we'll know if they're both on there. It's true and false. Okay, so let's go.

Is there only one? There's two one's true and one's false. There you go. So now we have all of our data from both sheets. The sheet that's on this, the tab that's on this sheet, and a sheet that's on a completely separate sheet, we've now combined them. With these curly brackets, import range, we have also created a settings tab that we can add many more.

We can add many more sheets here, and then we can create them in series, not create, smush them together in series here. And now we have a way to, combine all that data. We can sort it in another tab, we can say. Sort by name. We can get counts. We can start our data crunching and munging not munging crunching here, bite.

Courses

Better Than Happy | Redesign of The Feelings Wheel

Best Header Font Ever

Learn to Love Your Sheets

How Starter Story Designs Data

Sheet Review! 150 Active VCs by LemonIO

Anika Asks: How To Set Text Overflow All The Time

Introducing: Brutal Calendar

Add a Checkbox to Turn on Dark Mode

00:05:10

Create Drop Shadows! This makes your dashboards pretty.

00:12:04

10 Things I Hate About Your Spreadsheets

Merge Cells for Dashboards

00:05:29

Dark Mode / Better Font Color

00:09:35

Better Font Colors

00:02:45

Magical Things You Can do with Checkboxes in Google Sheets

00:12:31

How To Export Your Beautiful Sheets to PDF

00:04:06

Consider Labels as Opposed to Headers

00:04:02

Add Icons To Your Sheets With a Domain Name

00:04:21

How To Color Cell Blocks So Others Enter Data Easily

00:10:30

Great Sheets! Corona Hiring Sheet

00:10:43

Great Sheets! Community Information Board by Seedtable.com

00:07:35

Roast: Hotel PPC Channel Cost Calculator

00:11:25

Better Header Fonts - Best Fonts To Use In Google Sheets

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

00:09:49

Basic Keyboard Shortcuts To Speed Up Your Productivity

00:13:44

Basics - 5 Ways to Change Row Height

00:05:08

How to Refer to Other Cells - A1 and R1C1 Explained

00:13:22

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

00:09:31

Change the Default Font

00:03:33

Biggest Flaw In Dashboards with Dark Colors

00:07:45

Basics - 4 Ways to Change Column Width

00:05:48

Basics - Structure of a Sheet: Index() Row() and Column()

00:06:49

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

00:08:55

Use Cmd + Y To Do It Again, and Again, and Again

00:03:03

Create an Auto-Update Sales Chart: Trailing 12 Months

00:09:57

Google Sheet Basics - The Absolute Basics

00:09:48

Secure Your Sheets by BetterSheets.co

00:11:07

How To Create An AutoFill in Google Sheets

00:06:07

Build a Thermometer for Savings Goals

Make Your Lists Spicy Hot in Google Sheets

00:01:47

Restrict Access to a Cell if Another Cell is Blank

How to Use Smarket

00:03:28

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

00:06:23

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

00:53:31