Excel XML

Here you can post your opinions, ask questions and share information regarding GPI (Searching the EPO’s worldwide bibliographic, legal event and full-text data sets via the “Patent information services for experts” user interface).

EPO / EPAL Team
Posts: 139
Joined: Mon Dec 22, 2014 8:30 am

Re: Excel XML

Post by EPO / EPAL Team » Tue Jan 11, 2022 1:46 pm

Dear Edward,

we may not have the necessary Microsoft Power BI and Excel expertise to guide you through the process of creating a collaboration network.

What we did with GPI (for test purposes) is the following:
- Install Power BI desktop version and import from the internet the custom visual NetworkNavigator
- Download a GPI result list in XML format including publication numbers and applicant names
- Import the XML result list in Excel and transform it (create pivot table, use of Excel VLOOKUP function)
- Import the XLSX in Power BI desktop and use the XLSX columns to create a network of applicants:

collaboration network.png

We hope this information was of assistance to you.

GPI user support


Post Reply