Keywords: bash, spreadsheet, spreadsheet column, positional column, mapping, Excel, Libre Office
Depends on: awk
As a database engineer, I get data in different formats to ingest. Many times it's in a spreadsheet with many columns: 200+. During validation, I need to review certain columns. I may have the column number which needs to be translated to a spreadsheet column (e.g. column number 26 maps to spreadsheet column `Z').
This script prints a column number and its corresponding spreadsheet column. It's best to pipe the results to a pager such as less.