huanix

chown -R huanix /

huanix header image 1

Export wii fit data to a csv for import into excel or database

April 3rd, 2010 · wii, wii fit

These steps allow you to take data from your wii fit or wii fit plus and export it into a form that is text readable. This is useful for lots of reasons – for people tracking their weight, for physical therapists taking care of patients, or for people who just like to play with data. When you understand the process, a full data extraction takes less than 5 minutes from Wii to excel.

1. Save the game data to an SD card, transfer the resulting data.bin file to a linux computer.

2. Use the tachtig tool for the first round of data extraction. The tachtig tool is part of Segher’s suite and needs to be compiled from his git repository. After you compile the tool it will look for some wii keys in ~/.wii/ ; yes, the keys go in a folder in your home directory, not the bin path. You do NOT need to extract keys from your Wii. The pubicly available keys on the internet are fine. (note: look at jansenprice’s instructions for compiling tachtig in the resources below)

4. This will leave you with several files in a numerically named folder. The file that contains wii fit weight and balance information is RPWiifit.dat or FitPlus0.dat

3. Use the wiifitparser.py tool from the git repository on this google code site to extract the data.

The parser extracts a lot of data, but it needs to be tweaked. This is a modified wiifitparser that correctly parses weight (in pounds) and BMI. Here is my current wiifitparser.py as of April 3, 2010

4. The resulting data is xml, which is easily understood and simple to convert to csv.

Wii Fit data.bin parse

Wii Fit data.bin parse

(The workflow in the screenshot is real, but i trimmed the contents of the output file so you could see the actual weight output.)

My eventual goal will be to create an online parser where people can upload data.bin files from their wii fit save and have that data file converted into a csv that can be downloaded. Right now, this is a simple log of my sources – if you have ideas or other knowledge, please share it!

The best overall start guide:

http://jansenprice.com/blog?id=9-Extracting-Data-from-Wii-Fit-Plus-Savegame-Files

Google code page with an excellent introduction:
http://code.google.com/p/wiifit/source/checkout

Segher’s tachtig tool is the initial data.bin parser:

http://git.infradead.org/?p=users/segher/wii.git;a=blob;f=tachtig.c

StackOverflow thread on parsing wii fit data.bin:

http://stackoverflow.com/questions/616249/wii-fit-data-format

Oudtated but useful:

http://wiibrew.org/wiki/Wii_Savegame_Parser

→ 3 CommentsTags: ···