Export SVN logs to Excel

4 Dec 2019, by Justin MASSIOT

Did you ever wonder how can you export your SVN activity/logs to a table, such as an MS Excel spreadsheet?
I did, and I found a simple solution that I wanted to share with you. This takes the form of a Windows script which does everything for you!

After having downloaded the below *.bat file on your computer, just double-click it. Paste or type the URL you want to extract SVN logs from and hit Enter. MS Excel will open automatically, asking you how to do: choose “As an XML table” then “OK” and “OK” again.

You should obtain a table which has automatically been filled in with information from the SVN server. Nice!

Example SVN logs in MS Excel

Note that a “logs.xml” file will be created right before opening MS Excel. If you have saved the Excel file, you’re safe deleting the *.xml one.

Do you need to export only the logs of your tags? No problem: just add /tags at the end of the URL right after having launched the script.

To advanced users: you can edit the script parameters to better fit your specific needs (revisions, log order, …).

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: