Can I use Python to read individual cells from a spreadsheet & write a new text file?

Question

I'm talking about very long spreadsheets, 1000 rows or more with about 20 columns. I only need about six of the columns (slightly re-ordered with some added punctuation). I would like to automate this monthly work task that has come before me after an old school 80-year-old data entry clerk retired 2 months ago.

Is Python the best (or at least suitable) language for this or should I study a different language?

Answer 1

sure you can https://automatetheboringstuff.com/chapter12/

Answer 2

I recommend you look into the pandas module with python. It's a great way to work with such documents.

Answer 3

You are good to go with python.... what you can get here you can't get from other languages....👐