How can I do a bulk caller ID lookup (reverse phone lookup) on a list of phone numbers? [closed]

I have a tab-delimited text file with all of the phone numbers I've called or received calls from in the past year. The phone numbers are all based in the US, so the format is ###-###-####. For tax purposes, I need to know which calls were personal and which ones were business-related. I could enter them all one-by-one into Google, but that will take forever because there are hundreds of numbers to check.

Is there a program, MS Office plugin, or website that I can use to look up all of the numbers at once? If not, is there some way to create an Excel macro to do the lookups for me?

Take a look at Sobolsoft. I do not know anything about the company or their software, but if it does what it says, it is what you are asking for. It was the only bulk solution I was able to find.

In the future, it might be a good idea to keep a phone log as you go.

You need to look for a database for your local country, or perhaps ask your ISP. If no such database exists then you could opt to OCR a phone book, in case there is no electronic version available. Alternatively, a call log with such information could do the job, most only contain phone numbers though. Some might not give information to you out of privacy reasons, so it might be that this is impossible.

Once you get access to an API or database, you can query it for more details. How to do this depends on the database you gain access too, it would be too tedious to summarize that all...

Lesson learned: Keep track of something that might become valuable in the future...

What you need is a Reverse Phone Lookup API. There are several out there however I have yet to see one that is free for the volumes you are looking for or is not some form of closed alpha/beta.

You can upload up to 10,000 phone numbers via a tab delimited text or csv file into the searchbug reverse phone batch append tool. The fee is only charged for hits (matches) so if nothing is found for one or more numbers their is no charge for those.