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.
Unfortunately, I have a Windows 8.1 PC and I downloaded the update for it from the official website, but unfortunately the installation LibreOfice failed , so I stayed with OpenOffice.