An alternative is to provide data as ressources that can be imported using Excel web queries. I don't thnik vanilla excel can be linked to JSON ressources, but a simple HTML table does the trick. Excel Web queries can use parameters, making the use of several ressources faster vs the download of several files. As a bonus you can set the Excel file for the client, with your data ready and up to date in it.