So with the development made by Kiva it is now possible to export an Excel Spreadsheet with all you loans – a great step forward but it did leave a little to be desired, and the format made it hard to analyse…

I have created a spreadsheet (in Microsoft Excel and OpenOffice.org Calc formats) which will analyse the data further, splitting fields to allow better sorting, and fields that contain numeric information are now formatted as proper currency or date fields.

Basically you just copy a fresh download of your Kiva Export into a ‘My loans’ tab in the spreadsheet – it does all the necessary using functions, formulas and calculations. No macros are used for those worried about security risks.

The various versions can be downloaded from here.

Screenshots:

no images were found