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

How to move from Excel to Artavolo

A step-by-step guide: what to export from Excel, how to bring it in, what comes over, what you rebuild, and how to check the result.

Last reviewed

In short

You bring the workbook itself, any version back to Excel 2.0, and it is read in your browser. Each sheet becomes a table, the header row is found under any title rows, a formula repeated down a column becomes a formula field checked against Excel’s results, and a VLOOKUP into another sheet a link with a lookup. Charts, pivot tables, macros and formulas that reach other rows are rebuilt; the report names each one. The workbook itself is not changed.

You export
The workbook itself: .xlsx, .xls of any version (Excel 2.0 on), .xlsm, .xlsb, or CSV
You import with
Import data, then Excel
It costs
Nothing: the importer is free
Preparation

Before you start

  • Take any password off the workbook.
  • Make sure each list has one header row, even under a title.
  • Make a free Artavolo account and a workspace: the free plan has no limit on people or records.
  • Keep Excel running. Nothing in it changes, and the team switches once the new base is checked.
Step by step

Moving from Excel in 5 steps

  1. Export from Excel

    You get: The workbook itself: .xlsx, .xls of any version (Excel 2.0 on), .xlsm, .xlsb, or CSV.

    1. Save the workbook as it is: no conversion needed, old .xls files included.
    2. Take any password off the workbook first (File, Info, Protect Workbook).
  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 Excel’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 Excel.
    2. Open a few records and check their links, dates and selects.
    3. Read the report’s formula checks: each formula field is compared with Excel’s own results.
    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 Excel to read-only, or stop using it, and keep it for a month rather than deleting it.
Words

Excel’s words in Artavolo

What each part of Excel becomes after the move.

In ExcelIn Artavolo
WorkbookBase
WorksheetTable
RowRecord
ColumnField
Formula repeated down a columnFormula field
VLOOKUP or XLOOKUPLink field with a lookup
Data validation listSingle select field
Pivot table or chartGrouped view, or a dashboard tile
MacroAutomation
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 ExcelResult
Every sheet, a table each, with the header row found under any title rows Comes over
Formulas repeated down a column, as formula fields checked record by record against Excel Comes over
A column naming another sheet’s rows as a link, and a VLOOKUP through it as a lookup Comes over
Currency, percent and dates in the workbook’s style; merged cells filled down; a totals row left out Comes over
Charts and pivot tables (as dashboard tiles and grouped views) You rebuild
Macros (as automations) You rebuild
Formulas that reach other rows (running totals, say) You rebuild
Migration help

Rather we did the move?

We move a base or a whole workspace from Excel 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 Excel and roughly how much data; we answer with a price within one business day.

Ask for a fixed quote
Questions

Moving from Excel: questions and answers

Yes: every Excel since 2.0, including .xls files from Excel 95 and 97-2003, and .xlsb. It is read in your browser.

A formula written the same way down a column (=B2*C2) becomes a formula field, {Price} * {Qty}, and the report checks its results against Excel’s, record by record. Formulas that reach other rows come over as their values, said in the report.

A VLOOKUP into another sheet becomes a link to that sheet’s record and a lookup of the value, so it follows the record when it changes.

No. You only export from Excel, 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.