Getting TimeMyDay data into Excel
A user asked me whether I could implement 'Export to Excel'. So I created this little tool that takes the XML file exported by TimeMyDay and makes an xlsx file. This is version 2.
The link below allows you to download a Mac disk file, which can be downloaded and mounted on your system.
Drag and drop the Tmd2Xls icon somewhere suitable - your Applications folder or your desktop.
Export the data from TimeMyDay - ensuring that the filename ends in .xml - say tmd.xml
Drag and drop the file onto the Tmd2Xls icon - and a new file should be created next to the original file but named tmd.xlsx (the name of your source file with the .xml replaced by .xlsx). The output has one main worksheet containing all the events, and then separate worksheets for each project.
On the way, the program will ask you if you want to start the information at a particular day. Enter the date in YYYY-MM-DD format. The program will also send notifications when conversion has started and ended.
Beware, conversion of large TMD databases can take some time, so sometimes patience is needed.
By default, the date format is UK style:
you can convert the date format in Excel into something that suits your local preference.
Where does this work?
Well I've tested it with Excel 2008 - which is my version of the Office tools. I can read it with Excel and Open Office, and Numbers.
This tool is really an Automator wrapper around a PHP program using the PHP that is installed on your system. So if you are PHP literate, you can fiddle with it. It uses:
- PHP's internal XML reading code to import the XML file
- PHPExcel - this wonderful package generates lots of formats and does the business for Excel generation from PHP. It can be slow when dealing with lots of data.
Right click here to download the zipped disk image, it's a little over 4Mb.
This is version 2 and replaces the original version because PHP has moved on, and the package code for Excel writing in Version 1 didn't keep up with that.