I'm looking at moving blog content from the MetroPublisher platform to WordPress.

They have provided a dump of the database, but it is made up of multiple .json files - basically one .json file for every blog record.

I didn't expect it to be plain sailing, but I did as least expect one big messy file, most likely .csv that could then be massaged before importing into WordPress.

If anyone could give me me any pointers as to what to do with all these files, presumably to somehow combine them into one file with all the data, that would be much appreciated.