Google Sheets Query: How To Select Multiple Columns - - Statology

• About
• Course
• Basic Stats
• Machine Learning
• Software Tutorials
  • Excel
  • Google Sheets
  • MongoDB
  • MySQL
  • Power BI
  • PySpark
  • Python
  • R
  • SAS
  • SPSS
  • Stata
  • TI-84
  • VBA
• Tools
  • Calculators
  • Critical Value Tables
  • Glossary

by Zach Bobbitt Posted on Last updated on April 30, 2021

You can use the following syntax to select multiple columns using the Google Sheets query function:

=query(Range, “select A, B, C“, 1)

This particular query selects columns A, B, and C in a dataset and the 1 specifies that there is 1 header row at the top of the dataset.

The following examples show how to use this function in practice with the following dataset:

Example 1: Select Multiple Columns

We can use the following syntax to select all rows from the Player and Team columns:

Example 2: Select Multiple Columns Based on Condition

We can also select multiple columns based on some condition.

For example, we can use the following syntax to select the Player and Team columns where the Team is equal to Mavericks.

Example 3: Select All Columns

We can use the following syntax to select all of the columns in the dataset:

You can find more Google Sheets tutorials on this page.

Zach Bobbitt

Hey there. My name is Zach Bobbitt. I have a Masters of Science degree in Applied Statistics and I’ve worked on machine learning algorithms for professional businesses in both healthcare and retail. I’m passionate about statistics, machine learning, and data visualization and I created Statology to be a resource for both students and teachers alike.  My goal with this site is to help you learn statistics through using simple terms, plenty of real-world examples, and helpful illustrations.

Post navigation

Prev Google Sheets: How to Sum Values by CategoryNext Google Sheets: How to Query From Another Sheet

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Δ

Search

Search for: Search

ABOUT STATOLOGY

Statology makes learning statistics easy by explaining topics in simple and straightforward ways. Our team of writers have over 40 years of experience in the fields of Machine Learning, AI and Statistics. Learn more about our team here.

Featured Posts

• Building an Automated Invoice Generator in Excel with Client Database IntegrationDecember 18, 2025
• Shapley Values Explained: Seeing Which Features Drive Your PredictionsDecember 17, 2025
• Mastering VLOOKUP and XLOOKUP in Excel: From Basics to Advanced TechniquesDecember 16, 2025
• 5 Statistical Terms Everyone Gets Wrong (and What They Actually Mean)December 15, 2025
• Propensity Score Matching: Should You Use It for Your Study?December 12, 2025
• Collider Bias in Causal Inference: Definition, Examples, and InterpretationDecember 11, 2025

Statology Study

Statology Study is the ultimate online statistics study guide that helps you study and practice all of the core concepts taught in any elementary statistics course and makes your life so much easier as a student.

Introduction to Statistics Course

Introduction to Statistics is our premier online video course that teaches you all of the topics covered in introductory statistics. Get started with our course today.

You Might Also Like

• Google Sheets Query: How to Use Order By
• Google Sheets Query: How to Use Group By
• Google Sheets Query: How to Sum Multiple Columns
• Google Sheets Query: Select Rows that Contain String
• Google Sheets Query: How to Use the Label Clause
• Google Sheets Query: How to Remove Header from Results

Join the Statology Community

Sign up to receive Statology's exclusive study resource: 100 practice problems with step-by-step solutions. Plus, get our latest insights, tutorials, and data analysis tips straight to your inbox!

By subscribing you accept Statology's Privacy Policy.

Leave this field empty if you're human: