How to connect Microsoft Excel to Flowsite 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

⚠️ Important to note:

You will need to have the URL, Username and Password provided during the flow creation on hand

1 . Open Excel

2. Go to Data tab and click 'Get Data (Power Query)'

3. Select 'Blank query'

4. You will be brought to a script page. You'll need to overwrite the existing script with the script from below

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

5. Replace where it says "INSERT" with the values for URL, username, password

6. Hit next

7. Click "Configure connection"

8. Select "Basic"

9. Paste in Username and Password again

10. And click the 'Connect' button to finalise the connection

How to connect Microsoft Excel to Flowsite on Mac

Step-by-Step instructions: