JavaScript Functions Now Supported in Excel Spreadsheets

In: BlogDate: Jul 04, 2018By: Billy Burgess

JavaScript is the programming language responsible for interactivity on web pages — it is behind such prevalent features as multimedia items and form submissions.

Hi, we are Happy

We are leading a movement to create happy, empowered and productive workplaces.

How can we help you and your people to find joy in at least 80% of your work?

More about Happy

Having long been central to the functioning of the World Wide Web, JavaScript engines are now also present in a variety of non-web programs (such as word processors and PDF software).

At Microsoft’s recent Build 2018 conference, they announced that custom JavaScript functions will soon be supported in Excel spreadsheets. You’re probably familiar with Excel — it’s an almost indispensable tool in the modern workplace, with everyone from glossy magazine publishers to high street banks relying on it day-in, day-out.

What will support for JavaScript functions bring to Excel?

You’ll have the option of creating custom Excel formulas using JavaScript code, and these will be stored in the program’s formula database. Once created you can insert the formulas within the spreadsheet, this will stimulate the JavaScript code (which a JavaScript interpreter will process).

The addition of custom JavaScript functions gives Excel further versatility when working with data, as well as the capacity to incorporate a larger pool of information from web and third-party services.

At the Build conference, Microsoft underlined the primary benefits of custom JavaScript functions as the ability to “Calculate math operations, like whether a number is prime; bring information from the web, like a bank account balance; and stream live data, like a stock price.”

How does it work?

JavaScript functions are to be accessed in the same way as Excel’s already-existing functions — you know, =SUM(), =AVERAGE(), =MIN(), =MAX() etc.

Only, there is a slight difference. To activate JavaScript functions in the first place you need to manually load them via the Excel add-ins feature. Once this is done they’ll remain active every time you open that spreadsheet on the same computer.

At present, JavaScript functions are only available in Developer Preview on Windows, Mac, and Excel Online, but availability for all users isn’t far off.

If you’re on Developer Preview, than a detailed account of how to get JavaScript functions up and running can be found here.

Why not sign up to our newsletter?

Sign up to our monthly newsletter, full of tips, tricks and news to help you to be happier and more productive at work.

Sign up here
5 out of 5 stars

Just the info I needed, great

Emma Morgan66 days ago

Billy Burgess

Billy has been writing blogs for Happy since 2017, covering mindfulness, stress management, confidence building and emotional intelligence as well as offering handy tips for Office 365 users. As an arts, culture and lifestyle writer, his work is regularly published in Music Feeds, VICE, RedBull.com, Beat magazine and Mixdown.

More by Billy

Improve your productivity in Excel with happy

Happy has high-quality, learner-focused Excel training courses for all skill levels, designed to improve your confidence and productivity.

Our learners tell us that they save an average of 32 minutes a day with our Excel training courses. How much time could you save with us?

Learn more about Happy's Excel courses

Your post-course support package

  • 2 years of free access to our IT Helpline
  • Unlimited access - call or email our team as often as you need
  • Ask about any content covered on your course
  • Included in the price of our training sessions