Have you given Libre Office a try? I use their spreadsheet all the time. You can paste in data and actually get it into cells the way you want. Excel is terrible at this.

Development Comparison: https://www.libreoffice.org/discover/libreoffice-vs-openoffi...