Every device that connects to the Internet is assigned an IP, or Internet Protocol, address. The IP address consists of numbers that determine the identity of the device and the country where the connection originated. Knowing the country of an IP address can be useful for website administrators who wish to compile reports based on the number of worldwide hits. Finding the country of an IP address can be done using Microsoft Excel's built in filtering tools.
- Skill level:
Navigate your Web browser to a website that has a database of country IP codes. The details of one such site can be found in this article's Resources section.
Download the database as a CSV file; save it on your computer.
Open Microsoft Excel by clicking "Start," "All Programs," then "Microsoft Excel." Click "File" then "Open" and navigate to the CSV file. Double-click to open it.
Click "Data," "Filter," then "Auto Filter." The data will be displayed as filtered columns.
Click the first column and from the drop-down list click the IP address you want to know about. The data will be filtered to display the country name associated with the address; for example, "22.214.171.124" is associated with "Russia."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for