From time to time, I’ve needed to create a template file and populate it from a spreadsheet. In Microsoft Word, this is pretty simple, using a feature called Mail Merge. However, sometimes I’m not working with a Word document. So, I created a script that provides that same functionality for any plaintext or zip encoded file.
If you go to http://gschoppe.com/projects/universal-merge/ and upload a template file and CSV, it will replace any tags found in the template, of the form [[heading]], with the data from a matching column from the CSV, based on the column heading.