XML Query - Result returned to Excel

I have this list of phone numbers and I need to find out if they are local to me.

Is there anyway to take this list of phone numbers and run it against this XML Query and return the <islocal>N</islocal> part to a cell in excel? My list has 144 phone numbers (NPA/NXX's).

NPA1 and NXX1 is my originating end, and NPA2, NXX2 is the terminating end:

http://localcallingguide.com/xmlrcdist.php?npa1=416&nxx1=423&npa2=212&nxx2=733

Thank you,
Brandon
  <?xml version="1.0" encoding="UTF-8" ?>
  <!DOCTYPE root (View Source for full doctype...)> 
- <root>
- <rcdist>
  <npa1>416</npa1>
  <nxx1>423</nxx1>
  <rc1>Toronto</rc1>
  <region1>ON</region1>
  <v1>4981</v1>
  <h1>2488</h1>
  <lata1>888</lata1>
  <npa2>212</npa2>
  <nxx2>733</nxx2>
  <rc2>New York City Zone 01</rc2>
  <region2>NY</region2>
  <v2>4997</v2>
  <h2>1406</h2>
  <lata2>132</lata2>
  <distance miles="342" km="550" />
  <islocal>N</islocal>
  <effdate />
  <plantype />
  <calltype />
  <monthly />
  <note />
  </rcdist>
  </root>

Open in new window

bccramerAsked:
Who is Participating?
 
jkpieterseConnect With a Mentor Commented:
See this small article on how to work with XML in Excel:

http://www.jkp-ads.com/Articles/XMLAndExcel00.asp
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.