Sometimes a CSV has a text string in a number column, causing an "Error." Use (right-click column > Replace Errors) to change all errors to 0 or null with one click.
Have you tried Microsoft Power Query for Excel? Share your most impressive transformation in the comments below. microsoft power query for excel