You can check this excel add-in if this could help you: IP2Location Excel Add-in ...
Geolocation using IP?
On one of Tutorials we can see nice map in excel with cities where users come from.
But there is one hidden issue – it the tutorial, we have CITY attribute provided.
Is there any pig function (UFD) to resolve City name from IP address from a log file?
I’ve searched the Internbet, but the only solution I found was to download an IP database with cities attached.
Thanks for your replies.
Support from the Experts
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Become HDP Certified
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world