Is there some reason you need to use Excel for this? CSV processing is
more quickly and effectively handled by a full blown language like
python.

I work with python to manipulate CSV files on a routine basis. Excel
is limited to 65,536 records which can be quite small at times. The
operations you describe above can be quite easily handled by about 10
lines of python script.