How to dump data into tabular view in .csv or .xls formats?

[218835]

I am trying to use the static JSON to convert the monster-drops data into tabular format, but the free online JSON to CSV tools I found on the web are not converting the file as I had hoped/expected. Could anyone help me understand how to do this?

My end goal is to have a tracking sheet in Excel with rows being unique monster & combat level combinations and columns being unique drops. I would like to build separate tables for F2P only attackable NPCs and P2P (i.e. all attackable NPCs).

[atye]

@218835 You could probably write something to do this yourself if you have some programming experience. If not, maybe I can help. Can you provide an example output of CSV you want?

[218835]

Thanks for the reply. I do not have programming experience, but what I was hoping to accomplish was a table like the following:

MonsterID---MonsterName---MonsterLevel---Drop1---Drop2---Drop3 ...etc.

The "Drop" columns would be all the possible drops for that unique monster-level combination (unique row). Ideally I would like to have one for F2P only (meaning only F2P-killable NPCs and F2P-only drops for those NPCs) and members.

I attempted to manually create the F2P one in GoogleSheets but I believe I may have made multiple errors doing so. Also, manually creating the members version would be even more absurd than the F2P one was... Anyways, here is the one I tried to manually create for F2P: https://docs.google.com/spreadsheets/d/1eeMNU28_7eKNcoN93KAeGBTx5mEeNdLfT9IjZ1gcBdo/edit#gid=0

[atye]

Do these work for you?

f2p.csv
p2p.csv