How to obtain foreign field values?
There are a few options you have when it comes to exporting data from Drupal 7. A few have been mentioned in this post. Hope this helps!

How to export/import all nodes of a specific content type?