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
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.
Moving from Excel in 5 steps
-
Export from Excel
You get: The workbook itself: .xlsx, .xls of any version (Excel 2.0 on), .xlsm, .xlsb, or CSV.
- Save the workbook as it is: no conversion needed, old .xls files included.
- Take any password off the workbook first (File, Info, Protect Workbook).
-
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 Excel’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 Excel.
- Open a few records and check their links, dates and selects.
- Read the report’s formula checks: each formula field is compared with Excel’s own results.
- 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 Excel to read-only, or stop using it, and keep it for a month rather than deleting it.
Excel’s words in Artavolo
What each part of Excel becomes after the move.
| In Excel | In Artavolo |
|---|---|
| Workbook | Base |
| Worksheet | Table |
| Row | Record |
| Column | Field |
| Formula repeated down a column | Formula field |
| VLOOKUP or XLOOKUP | Link field with a lookup |
| Data validation list | Single select field |
| Pivot table or chart | Grouped view, or a dashboard tile |
| Macro | Automation |
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 Excel | Result |
|---|---|
| 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 |
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.