PK6 to spreadsheet

[euamotubaina]

I was wondering if it's possible to create a script that reads PK6 files data and puts them in a spreadsheet (Google Sheets or Excel)? I'm actually trying to organize my pokemon in a spreadsheet, grabbing the information manually from PKHex. I have more than a thousand pokemon, so I thought that a little automatization would help a lot. If anyone is curious, here's a template https://docs.google.com/spreadsheets/d/1iQ7AXuvWvheHCwQsgfysnbMGEqJsVuurhTR3b1ZdKiQ/edit?usp=sharing

I have absolutely no real coding experience, but this can be a good weekend project to get my mind off real stuff.

Thanks in advance for any direction.

[Kaphotics]

Put them in a 'db' folder, in the same folder that PKHeX is in. Using PKHeX, open the Database (ctrl D is the shortcut).

From there, Tools -> Create Data Report

[euamotubaina]

Awesome! I didn't even thought of using that, Kaphotics. Thanks a lot!

[euamotubaina]

Kaphotics, since we're here, let me ask you

The AltForms field returns a number. How (or where) can I get the correspondent Alternate Form name?

Thanks a lot for the help, man

[Kaphotics]

PKX.getFormList returns a string array of the forms the pokemon has; they are oftentimes the same form order as shown on websites.

Can always read through the comments for the getFormList method to see what form is what.

[euamotubaina]

I got it!

Thanks a real lot, dude!