#3, Python will do it's thing, you might need to convert it to a numeric type because it'll assume it's a string given that it's being pulled out of a string. At least at a guess.

Image: GettyImages/Edwin Tan What you’ll need How to install csvkit sudo apt-get install csvkit -y How to convert an XLS file to CSV in2csv clients.xlsx > clients.csv less clients.csv Our CSV ...