Microsoft Power Query 

Establish a connection between external databases and Microsoft Excel X with the dedicated utility managing data import operations by creating and processing queries, editing the existing ones and ensuring compatibility between X and older Excel versions.

Microsoft Query X for Mac uses Open Database Connectivity (ODBC) to allow you to import data from databases into Microsoft Excel X. You can use Query X to create new queries or refresh existing queries that were created in other versions of Excel, such as Excel 98, Excel 2001, and Excel for Windows.