Using Microsoft Excel with large CSV files is a breeze
June 07, 2022

Using Microsoft Excel with large CSV files is a breeze

Huseyin Yagli | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Software Version

Microsoft Office (Installed)

Overall Satisfaction with Microsoft 365

We tried using lots of software for our CSV file operations but none was as good as Excel. It lets us edit, view and create beautiful charts using the data. It was a pain to try using online solutions with our large CSV files. Excel handled all these large files like it was nothing. We could search and add columns and notes all over the data.
Microsoft Word is also used daily for our documents and it is very useful to have the Save as PDF feature. The compatibility between office versions is also really stable.
It was a very nice surprise that Office 365 software is also working on my Mac. I requested for a license from my company and installed the software and it saved me from lots of trouble in my Mac computer. I had all of the feature on my mobile computer too. The fonts and the icons look a bit off but it should be due to the MacOS environment. I didn't have any trouble installing or using it. It is a shame that we don't have integration with OneDrive while using Mac but I can just do the uploads manually.

Pros

  • Handle large CSV files gracefully.
  • The formattin of the files are not lost between different Office versions.
  • Works perfectly on a MacOS computer.

Cons

  • While using it on MacOS, the UI is not as good as it looks on Windows.
  • On MacOS, it is not integrated with OneDrive.
  • The updates may not work sometimes on MacOS.
  • Compatibility between MacOS and Windows versions.
  • Local editing of large data files.
  • Preparing charts using data.
  • Lots of our development teams spend efforts working on data files. The time spent has been reduced greatly thanks to Excel.
Google Sheets is better for sharing and collaborative editing. Versioning of the same file is also one of Google Sheets strong points.
Microsoft 365 is better for working with local files. It is much easier to store the file in multiple places and backup multiple versions in multiple places.
LibreOffice is free but the usage is much counter intuitive than Microsoft Office. OpenOffice is worse when it comes to UI.
Microsoft Excel's performance with larger files is much better. When opening huge files, excel loads it asynchronously and I can start working right away.

Do you think Microsoft 365 delivers good value for the price?

Yes

Are you happy with Microsoft 365's feature set?

Yes

Did Microsoft 365 live up to sales and marketing promises?

Yes

Did implementation of Microsoft 365 go as expected?

Yes

Would you buy Microsoft 365 again?

Yes

When working with CSV data files, if you don't have a local software, it is a hassle to upload it to an online service. It takes too much time to upload it and to display it. If the file is too large, it cannot even be processed online. When you Excel on your local computer, everything becomes simple. The file is opened instantly. You can search and process the file as you want. The modifications are done instantly.
When you prepare a long document, it is much faster to work locally and the formatting is kept very well.
As the downside, it is not very well suited for collaboration. Some online competitors are much faster to use. Sharing, commenting and collaborative editing needs improvement.

Comments

More Reviews of Microsoft 365

  1. Home
  2. Office Suites Software
  3. Microsoft 365 Reviews
  4. User Review of Microsoft 365