I get an error when I try to install an add-in for MacOS Catalina (10.15.5) and Excel for Mac (16.37 2005 1002)
As a sample, you can try Microsoft People Graph.
Despite the error, I opened the My Add-ins dialog and after clicking the Refresh button the add-in appeared on the list. Then I was able to add it.