NoSQL data to Excel

Hi

Has anyone on this forum ever successfully extracted data from a NoSQL database and imported it to an Excel in a sensible, readable format? I am trying to create some code to re-format just such an extract, but the data looks such a mess compared to anything from a relational database that I just don't know where to start! Any ideas very welcome!

The attached example workbook shows the data as it is output, it relates to family data for parents, children and extended family members (grandparents, parent's siblings etc) living at a single address. The file as output is in .txt format.

The second sheet in the attachment shows the format I woudl like to achieve - I would prefer not to have to use Excel for this, but I have no choice unfortunately.

(I've just added the borders to try to make it a bit easier to follow).

Thanks

Ed

(Whose great idea was NoSQL anway!?)

Thanks for the input guys. Kyle123, isn't NoSQL sometimes referred to as "Not Only SQL"? (Doesn't help in this instance though because there is no way of writing SQL queries in this particular database, at least not that I've found so far). The trouble is the organisation I work for is not that proficient with replacing its staff sometimes, and we currently (since December) have no DBA for this system (until their replacement starts in May!) so I can't talk to them - it's just been handed to me, and I've got no experience with this type of database (I can't agree that they're easier than relational dbs!!) I think I'll just give up and say sorry, can't do it! Thank you for your replies.

isn't NoSQL sometimes referred to as "Not Only SQL"?

Yes, but you can't write sql for them cos they ain't sql based

Do you know which db it is? Mongo, couch etc..