Bash: Find files, export as CSV

I needed to find/list files in a folder with some attributes (size) for a customer who needs those information in excel… Oh dear. Let’s do it:

# find . -type f -printf '"%h","%f","%s"\n'

-printf takes a format-string. In my example:

  • %h is the files folder
  • %f is the filename itself
  • %s is the filesize in bytes
  • every piece of information is separated by a single comma
  • and enclosed by doublequotes

This gave me a nice CSV-representation i just had to throw into OpenOffice in order to save it as Excel.