“ Spreadsheets were not designed for such tasks,”
What alternative would you suggest?
Spreadsheets are designed exactly for such tasks, it’s just that spreadsheet manufacturers felt it was helpful to auto format some data on import/input, if that default behaviour could be changed then problem solved.
A spreadsheet is a computer application for organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. A spreadsheet may also refer to one such electronic document.