Use Brandfetch with Microsoft Excel

Sub InsertLogosFromColumn()
    Dim ws As Worksheet
    Set ws = ActiveSheet

    Dim clientId As String
    clientId = "BRANDFETCH_CLIENT_ID"

    Dim lastRow As Long
    lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row

    Dim r As Long, domain As String, url As String, cell As Range
    For r = 2 To lastRow
        domain = ws.Cells(r, "A").Value
        If domain <> "" Then
            url = "https://cdn.brandfetch.io/" & domain & "/w/128/h/128/icon.png?c=" & clientId
            Set cell = ws.Cells(r, "B")

            ws.Shapes.AddPicture FileName:=url, LinkToFile:=msoFalse, SaveWithDocument:=msoTrue, _
                Left:=cell.Left, Top:=cell.Top, Width:=cell.Height, Height:=cell.Height
        End If
    Next r
End Sub