Compiles most of the useful information in a git log into a chronologically-ordered tab-delimited list using pretty formatting and a combination of shell commands.

git-log2tsv.sh

# Requires GNU's implementation of sed, which is provided by default on Linux. 
# If you are on a Mac try installing gnu-sed using Homebrew and replace
# all instances of `sed` with `gsed` in the script.

# Sets the date format to iso8601. Change it if you need to.

# Note that several fields may contain invalid characters and the script 
# does not check for that. You may have to use an encoding detector to 
# impose the right encoding on the concerned fields.

# Git log reference: http://git-scm.com/docs/git-log

git --no-pager log --all --no-merges --ignore-missing --shortstat --date=iso --pretty=format:\
'"%H"%x09"%T"%x09"%P"%x09"%an"%x09"%aN"%x09"%ae"%x09"%aE"%x09"%ad"%x09"%cn"%x09"%cN"%x09"%ce"%x09"%cE"%x09"%cd"%x09"%s"%x09"%d"%x09"%N"' | \
sed -r 's/^ ([0-9]*) files? changed(, ([0-9]*) insertions?\(\+\))?(, ([0-9]*) deletions?\(-\))?/"\1"\t"\3"\t"\5"/' | \
cat <<(echo '\n"commit_hash"\t"tree_hash"\t"parent_hash"\t"author_name"\t"author_mailmap_name"\t"author_email"\t"author_mailmap_email"\t"author_date"\t"committer_name"\t"committer_mailmap_name"\t"committer_email"\t"committer_mailmap_email"\t"committer_date"\t"subject"\t"ref_name"\t"notes"\t"files_changed"\t"insertions"\t"deletions"') | \
paste -d "\t" - - - | \
tail -r