Replacing Spreadsheets with Task-Specific Software

Ventana Research

This research is brought to you from our partner, Ventana Research.

Click here to learn more about this Knowledge Network partner.


Using spreadsheets causes problems in many collaborative enterprise activities, our benchmark research reveals. One way to eliminate them is to replace your spreadsheets in a given process or functional area with an application dedicated to the particular task. The ability to manage the process and workflows, in addition to eliminating the problems associated with rolling up multiple spreadsheets (which is time-consuming and prone to error), can make a dedicated application the best option. In cases such as budgeting, incentive compensation management and sales and operations planning, to name just three, ditching spreadsheets for a dedicated application from a software company may be the way to go, particularly for larger organizations. For smaller companies, there is a growing list of software-as-a-service (SaaS) options that are affordable and easy to deploy.


To see more best-practice findings and learn how to access the benchmark research and recommendations from "Requirements for 21st Century Spreadsheets."


To learn how Ventana Research can help you turn smarter use of spreadsheets into a competitive advantage.


About Ventana Research

Ventana Research is the leading benchmark research and advisory services firm. We provide expert guidance to help organizations manage and optimize performance - to become not only more efficient but more effective. Our unparalleled insights and best practices guidance are based on our rigorous, research-based benchmarking of people, processes, information and technology across business and IT functions worldwide. The combination we offer of benchmark research, thorough market coverage and in-depth knowledge of hundreds of technology providers means we can deliver business and technology education and expertise to our clients where and when you need them. Ventana Research provides the most comprehensive analyst coverage in the industry; more than 2.5 million business and IT professionals around the world benefit from Ventana Research's insights. To learn how our benchmark research and assessment and advisory services can improve your organization's performance, visit

Add Comment      Leave a comment on this blog post

Jun 1, 2009 1:40 AM Peter Peter  says:

Ditching spreadsheets is usually good idea, but not always.  In my IT shop, I have developed my own code generation tools for a number of language platforms right in Excel.  Macros and COM objects give the platform power and flexibility that the average user doesn't tap, but in my situation, it works great.  IDE add-ons were expensive and not as flexible.  Yes, I must treat it like any other application in terms of maintenance and upgrades, but that's what we do.  Forms and database connectivity are no-brainers in Excel for those who know VBA.

Apr 22, 2010 12:42 PM Ronan Ronan  says: in response to Peter

The problem is that most companies find it difficult to identify what data, and what processes reside in spreadsheet.

We are working on some technology and products that can really help in that regard. Contact us at:

for information.


Post a comment





(Maximum characters: 1200). You have 1200 characters left.



Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.


Resource centers

Business Intelligence

Business performance information for strategic and operational decision-making


SOA uses interoperable services grouped around business processes to ease data integration

Data Warehousing

Data warehousing helps companies make sense of their operational data