search

osrsbox / osrsbox-db

A complete and up-to-date database of Old School Runescape (OSRS) items, monsters and prayers
https://www.osrsbox.com/projects/osrsbox-db/
GNU General Public License v3.0
223 stars 80 forks source link

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

Open 218835 opened 2 years ago

218835 commented 2 years ago

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 commented 2 years ago

@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 commented 2 years ago

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 commented 2 years ago

Do these work for you?

f2p.csv p2p.csv