Frankly, IMHO, using Text::CSV for such a simple problem is overkill, since it can be done without any regard to the fact that your file contains CSV data. only need to add a trailer to each line.

Update: see my post below for a simple solution.