A Quick Introduction to EtherCalc

(Note: This post was first published, in a slightly different form, at Opensource.com and appears here via a CC BY-SA 4.0 license.)

Even though I'm not their most enthusiastic user, I do realize that spreadsheets can be very useful. And they're not just tools for people working in finance or in data science. Anyone can use spreadsheet to keep track of their personal finances, to catalogue a personal library, and more.

Desktop spreadsheet editors have their limitations. The biggest is that you need to be at your computer to use one. On top of that, if you need to share a spreadsheet, it can quickly become a messy affair.

Enter EtherCalc, an open source, web-based spreadsheet. While not as fully featured as a desktop spreadsheet, EtherCalc packs enough features for most people.

Let's take a look at how to get started using it.

Getting EtherCalc

If you're self-hosting, you can download the code or use npm (the Node.js package manager) to install it on a server.

But what if you don't have a server? You can use one of the many hosted instances of EtherCalc — for example, at EtherCalc.net, the instance hosted by the folks at Framasoft, or the one hosted by Disroot.

What Can You Use EtherCalc For?

Just about everything you'd use a desktop spreadsheet editor for. That could be to balance your budget, track your savings, record your income, schedule meetings, or take an inventory of your possessions.

I've used EtherCalc to track time on freelance projects, to create invoices for those projects, and even to share article ideas with people I've collaborated with. How you use EtherCalc is up to your needs and your imagination.

Working with EtherCalc

The first step is to create a spreadsheet.

A new, empty spreadsheet in EtherCalc

If you've used a desktop or web-based spreadsheet before, EtherCalc will look somewhat familiar. As with any spreadsheet, you type what you need to type in the cells on the sheet. The includes column headings, labels, and functions (more on those in a moment).

Before you do anything else, bookmark the URL to your spreadsheet. EtherCalc uses randomly generated URLs—for example, https://ethercalc.org/9krfqj2en6cke—which aren't easy to remember.

Formatting Your Spreadsheet

To add formatting to your spreadsheet, highlight the cell or cells that you want to format and click the Format menu.

Adding formatting to an EtherCalc spreadsheet

You can add borders and padding, change fonts and their attributes, align text, and change the format of numbers, for example to dates or currency formats. When you're done, click the Save to: button to apply the formatting.

Adding Functions

Functions enable you to add data, manipulate data, and make calculations in a spreadsheet. They can do a lot more, too.

To add a function to your spreadsheet, click a cell. Then, click the Function button on the toolbar.

The Function button in EtherCalc

That opens a list all of the functions EtherCalc supports, along with a short description of what each function does.

A list of functions in EtherCalc

Select the function you want to use, then click Paste. EtherCalc adds the function, along with an opening parenthesis, to the cell. Type what you need to after the parenthesis, then type a closing parenthesis. For example, if you want to total up all the numbers in column B in the spreadsheet using the \=SUM() function, type B1:B21 and close the parenthesis.

Example of a function in EtherCalc

You can also add functions by double-clicking in a cell and typing them. There's no reference in the documentation for EtherCalc's functions. However, it does support OpenFormula (a standard for math formulas that spreadsheets support).

If you're not familiar with spreadsheet functions, you can look up what you need in the OpenFormula specification or this handy dandy reference to LibreOffice Calc's functions.

Collaborating with Others

Back in 2019, I worked with two friends on a content strategy project. I'm in New Zealand, one friend is in British Columbia, and the other is in Toronto. Since we were working across time zones, each of us needed access to the spreadsheet we were using to track and coordinate our work. Emailing a LibreOffice Calc file wasn't an option. Instead, we turned to EtherCalc. Doing that worked very well.

Collaborating with EtherCalc starts with sharing your spreadsheet's URL with your collaborators. You can tell when someone else is working on the spreadsheet by the blue border that appears around one or more cells.

Collaborating via EtherCalc

You and your collaborators can enter information into the spreadsheet simultaneously. All you need to remember is to respect the sanctity of those blue borders.

The Comment tab comes in handy when you need to ask a question, include additional information, or make a note to follow up on something. To add a comment, click the tab, and type what you need to type. When you're finished, click Save.

Adding a comment to an EtherCalc spreadsheet

You can tell when a cell has a comment by the small red triangle in the top-right corner of the cell. Hold your mouse pointer over that corner to view the comment.

Viewing a comment in an EtherCalc spreadsheet

Final Thoughts

EtherCalc doesn't do everything that, say, LibreOffice Calc or Gnumeric can do. And there's nothing wrong with that. In this case, the 80/20 rule applies.

If you need a simple spreadsheet and one that you can work on with others, EtherCalc is a great choice. It takes a bit of getting used to, but once you do, you'll have no problems using EtherCalc.

#opensource #web #productivity