This video explains how to import external data using a URL in Excel for Mac. A couple extra steps than the Windows version. Hope this helps.
No download links available.
