Excel data automation using shell script

I guess the original input had fields with embedded newlines, and finally caused the input that you share?
Embedded newlines can be replaced with spaces, see

Now it is a little more difficult...