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

Move from Excel or Access

Updated

Artavolo turns a whole Excel workbook or Access database into a base: each sheet or table becomes a table, relationships and lookups become links, and repeated formulas become formula fields checked against the file's own results. The file is read in your browser; only the base you make is sent.

Bring an Excel workbook

  1. On Home, click Import a spreadsheet and open the Excel tab.
  2. Pick or drop the workbook. Several files at once are fine.
  3. Check the tables found, each with its records and fields. Untick a table to leave it out.
  4. Name the base and press Make the base.

Every Excel since 2.0 is read: .xls of every version, .xlsx, .xlsm, .xlsb, the 2003 XML format, OpenDocument (.ods) and CSV. Take any password off the workbook first.

What Excel brings

  • Each sheet as a table, with the header row found even under title rows. Merged cells are filled down and a totals row is left out.
  • Field types from the values and number formats: currency with its symbol, percent, dates, checkboxes, e-mail, links, and a status column as a single select.
  • A formula repeated down a column as a formula field, written with field names, such as {Qty} * {Unit price}.
  • A column naming another sheet's rows as a link, and a VLOOKUP through it as a lookup.

Bring an Access database

  1. Close Access and copy the .mdb or .accdb file.
  2. On Home, click Import a spreadsheet and open the Access tab.
  3. Pick the file. If it has a database password, type it under The database's password and press Open it.
  4. Check the tables, untick any to leave out, name the base and press Make the base.

Access 97 to 2019 is read, one database at a time. Linked tables live in other files: import those files too.

What Access brings

  • Every table, typed from Access's own types: AutoNumber, Currency, Yes/No, Date/Time, Memo, Hyperlink and rich text.
  • Relationships as links: Orders.CustomerID becomes a link to the customer's record. Records whose parent is gone are counted in the report.
  • Attachment fields with their files.
  • A readable first field to name each record.

Read the report

When the base is made, the report shows the records per table and:

  • Formulas and lookups, checked against Excel (or Access): each formula worked out here and compared with the file's own result, record by record.
  • What is different: anything to look at, such as a formula that reaches other rows (a running total, say). That comes over as its values, never as an error.
  • For Access, the queries, forms, reports, macros and modules, listed by name to rebuild.

What to rebuild

  • Excel charts and pivot tables: as dashboard views and grouped views.
  • Macros and VBA: as automations.
  • Access queries: as views with filters. Forms and reports: as forms, interfaces and dashboards.

Good to know

Related