Using SQL statements in Excel enables you to connect to an external data source, parse field or table contents and import data – all without having to input the data manually.

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.