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
- On Home, click Import a spreadsheet and open the Excel tab.
- Pick or drop the workbook. Several files at once are fine.
- Check the tables found, each with its records and fields. Untick a table to leave it out.
- 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
- Close Access and copy the .mdb or .accdb file.
- On Home, click Import a spreadsheet and open the Access tab.
- Pick the file. If it has a database password, type it under The database's password and press Open it.
- 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
- Only owners of a workspace make bases from a file, within the plan's number of bases.
- To add one sheet to a base you already have, use Import a file as a table in the base: see Import a CSV, Excel or JSON file.
- Step by step pages: Move from Excel and Move from Access.