You can use Boda Tool. It’s a complete tool, to parse all vendors raw data.
To install Boda, visit this: Boda Lite - Multivendor/Multitechnologies Network Management Tool (CM, PM and more)
Note: Boda was discontinued (no feedback from users, open source project halted), but you still can use (latest available version there), and can parse it into CSV files, then use VBA macros to work with processed data.