Using Microsoft Excel integration on Mac

The Excel web connector is not available on the Apple version of Microsoft Excel. To combat this, the query connector can be used with the Excel integration

Open Excel
Go to Data tab and click "Get Data (Power Query)"
Select "Blank query"
Overwrite existing script with script from below
Replace where it says "INSERT" with the values for URL, username, password
Hit next
Click "Configure connection"
Select "Basic"
Paste in Username and Password again
And connect

let
    baseUrl = "INSERT",

    username = "INSERT",
    password = "INSERT",

    urlWithAuth = baseUrl & "?username=" & Uri.EscapeDataString(username) & "&password=" & Uri.EscapeDataString(password),

    Source = Web.Contents(urlWithAuth),

    ImportedData = Csv.Document(Source, [Delimiter=",", Columns=null, Encoding=1252, QuoteStyle=QuoteStyle.None])
in
    ImportedData