EXTRACT BOM from SW

Hello. I am looking for a way to extract BOM from a batch (1,000+) of Solidworks Assemblies and import them into one excel file? I will upload the excel file into an MRP system. I appreciate your suggestions/help. Thank you.