Export workbook data from different files to SP 2013 list

Question

I have a main site from which new subsites are created whenever a new project is started. In each of these sites there's an Excel standard document where people fill in data about that specific project.

My goal is to create a database list in the main site that is automatically update with the content from those Excel files located in each project subsite.

I've seen many ways to transfer data from Excel to a list, but none of them worked so far.

Is this possible to be done?

Answer 1

Hmm... How about adding VBA code to the Excel document? On save, it will sync its content with the SharePoint list on the main site. You'll obviously need to convert the Excel file to .xlsm if it's not already in that format.