Working with external data in Excel 2016 for Mac
Excel 2016 for Mac adds native support for ODBC data connections and an all new Connection Manager and Microsoft Query to enable you to build, share and use workbooks that work on both Windows and Mac right out of the box.