You can import data from different sources using Microsoft Office Excel, one of which, as from version 2010, is ODATA.
I'm using Excel version 2013 in the demonstrations and examples. Most of it is also possible in version 2010, but I recommend the 2013 version.
Start Microsoft Office Excel, and create a blank workbook. Then, in the ribbon, look for DATA and select From Other Sources, then select the From OData Data Feed:
You need to enter the OData web service URL and the credentials used to access Dynamics NAV in the popup window that opens:
In the next window you will see the Customer Card web service. Select it and click on Next ...