Related Articles

Using the External Data Connection feature in Excel, you can acquire information from external sources, such as Access and SQL Server. The data remains stored at its original source, but the data connection allows you to use the information in your spreadsheet. One way to make connections is to use the Query Wizard, which will walk you through the connection process. You can even perform multiple queries to connect to several sources and create a custom worksheet with all of the information you need.

1.

Start Excel and open a new or existing spreadsheet. Go to the "Data" tab and click on "From Other Sources" in the Get External Data group. Choose "From Microsoft Query" in the drop-down list.

2.

Choose the type of data source you want to connect with and click "OK." Navigate to the location of the source in the "Directories" list. Click on the file or database to which you want to connect and click "OK."

3.

Click on the name of the table or column you want to retrieve data from and then click the "Add" button, which looks like a right-pointing arrow, to add it to the Columns in Your Query list. Click "Next." Choose a column by which to filter the data if desired and click "Next" again.

4.

Select one to three options by which you want the data sorted and click "Next." Select "Return Data to Microsoft Excel" and click "Finish." Choose the type of table you want to create and where you want to place it. Click "OK" to add the data to the spreadsheet.

5.

Repeat the procedure to perform additional queries and connect to other data sources. Save the changes to your spreadsheet before you close Excel by pressing "Ctrl-S" or clicking the "Save" button on the Quick Access Toolbar.

Tip

Clicking the "Refresh All" button in the Connections group on the Data tab will instantly update the information from all data sources connected to the spreadsheet.

References (2)

About the Author

Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine. She is certified in Microsoft application and served as the newsletter editor for OfficeUsers.org. She has also contributed to The Dollar Stretcher, Life Tips and Childcare Magazine.

Photo Credits

Comstock/Comstock/Getty Images

bibliography-iconicon for annotation tool Cite this Article

Choose Citation Style

Goss, Tricia. "How to Perform Multiple Queries on an Excel Spreadsheet." Small Business - Chron.com, http://smallbusiness.chron.com/perform-multiple-queries-excel-spreadsheet-41892.html. Accessed 25 May 2019.

Goss, Tricia. (n.d.). How to Perform Multiple Queries on an Excel Spreadsheet. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/perform-multiple-queries-excel-spreadsheet-41892.html