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.

Not surprisingly, Microsoft itself uses this to provide Big Data services right within Excel – Excel is one of the primary clients to enable big data analytics on Microsoft platforms.