An assortment of useful scripts for CSV files.
ChangeColumnHeaders
This script Changes the Column Headers of an existing Worksheet to Headers of your choosing.
ReplaceTextCSV
This script replaces special characters and hex characters to text in an entier Workbook.
ConsolidateRows
This script consolidates all Rows with the same unique Cell input into one Row. Example- you have a worksheet with multiple items associated with a parent ID number and need to consolidate all the like items into one Row.
SplitCSV-by1001Rows
This script splits a Workbook with a large number of Rows into individual CSV files limited to 1001 Rows, or whatever number you choose.