How to move from Grist to Artavolo
A step-by-step guide: what to export from Grist, how to bring it in, what comes over, what you rebuild, and how to check the result.
Last reviewed
In short
You download the whole Grist document as one Excel file and bring it into Artavolo as it is. Each table becomes a table, references become links from the referenced rows’ names, and choices, dates and numbers keep their types. Python formulas and access rules are rebuilt as formula fields, row rules and permissions. Nothing in Grist changes while you try it.
- You export
- Excel (.xlsx), the whole document
- You import with
- Import data, then Excel
- It costs
- Nothing: the importer is free
Before you start
- Write down the Python formulas and what each works out.
- Write down the access rules, to set as row rules and permissions.
- Make a free Artavolo account and a workspace: the free plan has no limit on people or records.
- Keep Grist running. Nothing in it changes, and the team switches once the new base is checked.
Moving from Grist in 5 steps
-
Export from Grist
You get: Excel (.xlsx), the whole document.
- Open the document, then Share, then Download, then Export XLSX.
- Every table is a sheet of the file: bring it in as it is.
-
Bring the files into Artavolo
The files are read in your browser.
- In Artavolo, choose Import data on Home, then Excel (this link opens it for you).
- Pick or drop the files, all at once: each becomes a table, linked where one names the other’s records.
- The tables and their fields are shown with their types, and what was found (links, lookups, groups). Untick a table to leave it out, then choose Make the base.
-
Read the import report
It lists the tables and records made, the formulas and lookups checked against Grist’s own results record by record, and what is different, so nothing is dropped without a word.
-
Check the new base
- Compare the number of records in each table with Grist.
- Open a few records and check their links, dates and selects.
- Write each formula again and compare a few results with Grist’s.
- Go through the report’s list of what is different, and decide what to rebuild.
-
Rebuild and switch over
- Rebuild what the export leaves out: the table below lists it, and so does the import report.
- Invite the team, and set who sees which tables and records.
- Set Grist to read-only, or stop using it, and keep it for a month rather than deleting it.
Grist’s words in Artavolo
What each part of Grist becomes after the move.
| In Grist | In Artavolo |
|---|---|
| Team site | Workspace |
| Document | Base |
| Table | Table |
| Row | Record |
| Column | Field |
| Reference column | Link field |
| Python formula | Formula field |
| Access rule | Row rule or permission |
| Page with widgets | Interface page |
What comes over, and what you rebuild
The import report names every item in the second group, so nothing is dropped without a word.
| From Grist | Result |
|---|---|
| Every table, a sheet each | Comes over |
| References between tables, from the referenced rows’ names | Comes over |
| Choices, dates, numbers | Comes over |
| Python formulas (as field formulas; most spreadsheet functions match) | You rebuild |
| Access rules (as row rules and permissions) | You rebuild |
Rather we did the move?
We move a base or a whole workspace from Grist for a fixed price, agreed before we start and quoted by e-mail. We run the import, rebuild what the export leaves out, check the result against the report with you, and walk you through it on a recording.
Tell us what you use in Grist and roughly how much data; we answer with a price within one business day.