LibreOffice Calc - Great for working with data
June 11, 2018

LibreOffice Calc - Great for working with data

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with LibreOffice

I use LibreOffice for data cleaning in Calc. The portable version of this app is very useful for spot-case use where you don't want to fully install or use across multiple devices. This app is being used for data processing, cleaning, and ETL for databases and comma separated file/tab separated file manipulation.
  • Native support for Regular Expression
  • Easy interaction with CSV documents
  • Supports Excel formats
  • Upgrade the user interface, it is looking very mid-2000s
  • Support for structured references
  • No cost makes it easier to adopt.
  • Learning curve for UI when migrating from Sheets or Excel.
Libre Office Calc is better than Excel for data cleaning. It is, however, somewhat worse than Excel for charting "sharing" documents for non-power users since one hundred percent compatibility is not guaranteed. The outdated Libre Office user interface is worse than Excel since it is not often the primary focus for dev updates.
I always recommend LibreOffice for data cleaning practices since Excel tends to have some hiccups that can really hurt your data cleanliness. I do not recommend LibreOffice for standard reporting/charting in corporate environments where Excel is king since there is not 100% support of all features. I find LibreOffice to be more suited for the IT/Web crowd instead of Finance/Supply Chain.