We need to organize an associative inventory together, each from home, without software budget. The reflex would be Google Sheets, but we prefer to avoid entrusting the association’s data to an advertising giant. Framacalc, the online collaborative spreadsheet from Framasoft, meets this specific need: to create a shared table in seconds, for free, without registration or collection of personal data.
Framacalc and automatic deletion: what the homepage doesn’t detail
When discovering Framacalc, everything seems simple: you click, you get a spreadsheet, you share the link. The trap is treating this table as a permanent file on your hard drive.
Framacalc is based on the open-source software Ethercalc, hosted by the Framasoft association. The tables created are deleted after 335 days of inactivity (no access, no modifications). If no one views the document during this period, it disappears without prior warning.
We’ve seen the same principle applied to Framadate, where the standard announced lifespan is 180 days before deletion. This retention policy reminds us of a ground rule: a free associative service is not an archiving space. For any document intended to last (accounting, multi-year tracking), we regularly export to CSV or HTML, the two formats offered by Framacalc.
Even before filling in the first cell, you can create a Framasoft table like Excel by following the naming and sharing steps, then note the URL in an internal document to avoid losing it.
Creating a collaborative Framacalc table: concrete steps
Go to framacalc.org. The homepage displays a text field to name your table and a creation button. No registration form, no password.
Naming and generating the table
The chosen name becomes part of the URL. If you type “budget-asso-2026”, the address will look like framacalc.org/budget-asso-2026. An explicit name makes it easier to locate, especially when managing multiple tables in parallel.
A click on “Create a calc” immediately opens the editor. The grid resembles a classic spreadsheet, with lettered columns and numbered rows.
Available functions and technical limits
Framacalc offers calculation functions covering common needs:
- Statistical, financial, and mathematical functions (sum, average, standard deviation, rate)
- Text functions to concatenate, extract, or format strings
- Basic charts: histogram, lines, scatter plot
- Annotations on cells to leave comments for collaborators
However, importing Excel or OpenDocument files is not possible. It’s also impossible to create multi-sheet workbooks. If the project requires several linked tabs, you create as many separate tables. The maximum capacity is 100,000 rows, which is sufficient for most associative or educational uses, but not for massive data processing.
Anonymous collaboration on Framacalc: governance and security of the shared link
Collaboration works without a user account. Anyone with the link can modify the table in real-time. Changes appear instantly for all participants, with a consultable modification history.
This open model raises a governance question that user guides often do not address. If the link is mistakenly shared (copied in a group email, posted on a forum), anyone can modify or delete the content. There is no user permission system or cell locking.
Some concrete precautions to apply:
- Share the link only via private messaging, never on a public channel
- Keep a local copy exported in CSV after each collaborative work session
- For a sensitive project, consider self-hosting an Ethercalc instance on a dedicated server, which allows controlling network access
Self-hosting Ethercalc: an alternative when Framacalc is no longer sufficient
Framacalc is a public instance of Ethercalc maintained by Framasoft. When needs exceed the scope of a one-off table (confidential data, high volume, guaranteed availability), you can install Ethercalc on your own server.
Self-hosting gives control over the retention policy (no automatic deletion), access restriction by IP or authentication, and backup frequency. It’s a technical approach that requires a minimum of system administration, but Framasoft’s documentation provides the basics to get started.
Feedback varies on the ease of setup depending on the server environment, but for an organization that regularly handles shared data, self-hosting offers a level of control that the public instance cannot guarantee.
Framacalc versus Google Sheets: what we gain and what we lose
Google Sheets offers integrations (Apps Script, connection to other Google services), granular permissions by user, and storage capacity linked to the Google account. Framacalc does not operate in this space.
What we gain with Framacalc can be summed up in three points: no collection of personal data, no advertising, no account required. For a classroom workshop, a quick survey among volunteers, or temporary stock tracking, this simplicity is a real advantage. You send the link, everyone works, you export the result.
What we lose is permanence and granularity. No access control by person, no import of existing files, no advanced formulas like macros. The choice between the two depends on the context: project duration, data sensitivity, number of collaborators.
Framacalc fulfills its role when you need a quick, ethical, and frictionless online collaborative spreadsheet. For one-off or associative use, it is a tool that does exactly what it promises, as long as you don’t expect it to be a permanent storage space.
