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.
This version is version 3 and has been updated (29/April/2019) to the last version of PHPExcel 1.8.1, which works with the most recent versions of PHP. PHPExcel has been superseded by a new system, but it appears to work OK here.
Well I've tested it with Excel from 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:
Right click or Alt-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.