Leaving Airtable? Bring your bases to Artavolo, checked record by record. See how

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
Preparation

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.
Step by step

Moving from Grist in 5 steps

  1. Export from Grist

    You get: Excel (.xlsx), the whole document.

    1. Open the document, then Share, then Download, then Export XLSX.
    2. Every table is a sheet of the file: bring it in as it is.
  2. Bring the files into Artavolo

    The files are read in your browser.

    1. In Artavolo, choose Import data on Home, then Excel (this link opens it for you).
    2. Pick or drop the files, all at once: each becomes a table, linked where one names the other’s records.
    3. 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.
  3. 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.

  4. Check the new base

    1. Compare the number of records in each table with Grist.
    2. Open a few records and check their links, dates and selects.
    3. Write each formula again and compare a few results with Grist’s.
    4. Go through the report’s list of what is different, and decide what to rebuild.
  5. Rebuild and switch over

    1. Rebuild what the export leaves out: the table below lists it, and so does the import report.
    2. Invite the team, and set who sees which tables and records.
    3. Set Grist to read-only, or stop using it, and keep it for a month rather than deleting it.
Words

Grist’s words in Artavolo

What each part of Grist becomes after the move.

In GristIn Artavolo
Team siteWorkspace
DocumentBase
TableTable
RowRecord
ColumnField
Reference columnLink field
Python formulaFormula field
Access ruleRow rule or permission
Page with widgetsInterface page
The result

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 GristResult
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
Migration help

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.

Ask for a fixed quote
Questions

Moving from Grist: questions and answers

Yes: in the Excel export a reference shows the referenced row’s name, and the import links them again.

Formulas use spreadsheet functions ({Price} * {Qty}, IF, SUM...). Python formulas are rewritten; in a fixed-price move we do it.

Set them again as row rules (who sees which records), hidden or read-only fields and table permissions.

No. You only export from Grist, and the files are read in your browser. Keep using it until the team has switched.

Yes. We move a base or a whole workspace for a fixed price, agreed by e-mail before we start: we run the import, rebuild what the export leaves out and check the result against the report with you.