We have started working with a client that submits their sales to us in a csv, data is shit so needs cleaning and rearranging before we can import it into our app.

The data contains an EAN13 barcode as one of the columns, obviously this is shown by excel as out of range, which can of course be easily rectified by convert to number, but in practice operators are messing this part up and saving csvs with barcode values of "5.0567E+12" etc

All I need is a simple editor that can represent the csv as rows and columns, no calcs or fancy formatting needed, anything come to mind?

To answer my own question, yes there is:

https://www.moderncsv.com/download/

exactly what I needed and free for the functionality I require

And here I was all impressed with myself because I am such an expert in Excel that I can sometimes get conditional formatting to do what I want, and once in an excess of bravery even got a simple VLOOKUP to work. (I never had the courage to try out the newer XLOOKUP function.)

You're a good bit out of my league, I'm afraid.

tanstaafl.

I think in general you're much more advanced than me, never used a VLOOKUP! This is a simple data entry issue, and obviously my solution means ditching Excel rather than doing anything clever with it

My son (recently graduated with a degree in data science and starting at Bloomberg this coming week - yay!) laughs at my use of Excel for anything. He cleans up data in R.

Kids!