Write code to parse and filter uspto patent bulk data into excel

I need code to parse [login to view URL] patent bulk data into excel. The bulk data I need to parse weekly can be found here: [login to view URL]

I need the patents filtered so that the specification includes microprocessor cpu microcontroller or "micro controller". Also the assignee name needs to match the inventor [login to view URL] the inventor country needs to be usa

I need to be able to run the code myself on a weekly basis.

The data is similar to xml but it is not exactly so excel will not import the data natively.

The data i want in the excel file is the inventor name, city, state and country, assignee name, city, state and country, the patent number and the specification.

Skills: Excel, Excel VBA, Programming, XML

See more: parser write code, write code transfer data sql server excel, write code form, java code parse text file database, person write code, php code parse xml, parse uspto patent search, parse patent office data, write code parse web page, write program parse data webpage, jasper bulk data excel format, upload bulk data excel mssql asp net, uspto patent download data java, write macro code export data excel txt file, write macro parse data excel, word bulk data excel, survey data excel number, bulk data excel, write code data entry, vba code to filter data in excel

About the Employer:
( 0 reviews ) United States

Project ID: #17680919

Awarded to:


I checked the xml file and I can filter the data on specifications, name and country and output the results in desired format. I have excellent hold on MS Excel and VBA and have parsed xml data before.

$150 USD in 4 days
(64 Reviews)

9 freelancers are bidding on average $395 for this job


Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 395 + projects with 100% client satisfaction. I can help you More

$500 USD in 6 days
(266 Reviews)

I can provide you web scraping script that will visit above website, download zip archive, unzip it, parse XML and save output into your Excel file. You can use it on weekly basis to get updated information from bul More

$450 USD in 3 days
(118 Reviews)
$888 USD in 1 day
(2 Reviews)

Hello Sir I can perform the task as per ur requirement and deliver you the expected results. Since I want to start working as a freelancer. I will give you a sample XML file from where I have done something similar.

$444 USD in 2 days
(0 Reviews)

Hello, I would like to apply as a software developer in your job post. It says that you are looking for someone who knows how to create a script for excel sheets and also XML. I have [login to view URL] experience in this field, More

$300 USD in 3 days
(0 Reviews)

Starting right away! Relevant Skills and Experience A lot of skills with VBA in big Corporations and Banks.

$305 USD in 5 days
(0 Reviews)

i use various programming languages like R, Python and VBA macro in my daily work. mainly involved in implementing through languages which can do automatically and in a smoother an faster way. i surely can help you More

$500 USD in 6 days
(0 Reviews)

Hello, I can do it easily. It will be grateful to work with you.

$15 USD in 1 day
(0 Reviews)