How to move from Smartsheet to Artavolo
A step-by-step guide: what to export from Smartsheet, how to bring it in, what comes over, what you rebuild, and how to check the result.
Last reviewed
In short
You export each Smartsheet sheet to Excel and bring the files into Artavolo together. Every row comes over as a record, with dropdowns as selects, dates, numbers and checkboxes, and links between sheets made again from the linked rows’ names. Smartsheet’s export keeps values, not formulas, and flattens parent rows, so formulas, hierarchy, reports and dashboards are rebuilt. Nothing in Smartsheet changes while you try it.
- You export
- Excel (.xlsx), one file per sheet
- You import with
- Import data, then Excel
- It costs
- Nothing: the importer is free
Before you start
- List the sheets you bring, and which refer to each other.
- Write down the formulas of each sheet: the export keeps only their values.
- Note which rows are parent rows, if the hierarchy matters.
- Make a free Artavolo account and a workspace: the free plan has no limit on people or records.
- Keep Smartsheet running. Nothing in it changes, and the team switches once the new base is checked.
Moving from Smartsheet in 5 steps
-
Export from Smartsheet
You get: Excel (.xlsx), one file per sheet.
- Open the sheet, then File.
- Choose Export, then Export to Microsoft Excel.
- Repeat for each sheet, then bring the files in together.
-
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 Smartsheet’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 Smartsheet.
- Open a few records and check their links, dates and selects.
- Write each formula again as a formula field, and compare a few results with Smartsheet’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 Smartsheet to read-only, or stop using it, and keep it for a month rather than deleting it.
Smartsheet’s words in Artavolo
What each part of Smartsheet becomes after the move.
| In Smartsheet | In Artavolo |
|---|---|
| Workspace | Workspace |
| Sheet | Table |
| Row | Record |
| Column | Field |
| Dropdown column | Single or multiple select field |
| Cross-sheet reference | Link field with a lookup |
| Report | View, or an interface page |
| Dashboard | Interface dashboard page |
| Workflow | 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 Smartsheet | Result |
|---|---|
| Every row of every sheet | Comes over |
| Dropdowns as selects, dates, numbers, checkboxes | Comes over |
| Links between sheets, found from the linked rows’ names | Comes over |
| Formulas: Smartsheet’s export keeps only their values | You rebuild |
| Row hierarchy (parent rows), which the export flattens | You rebuild |
| Reports and dashboards (as interfaces) | You rebuild |
Rather we did the move?
We move a base or a whole workspace from Smartsheet 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 Smartsheet and roughly how much data; we answer with a price within one business day.