# Move from Excel or Access

> Turn an Excel workbook (any version back to Excel 2.0) or an Access database (97 to 2019) into a base with links, formulas and a report.

Source: https://artavolo.com/page/move-from-excel-or-access

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](https://artavolo.com/page/automations).
- Access queries: as views with filters. Forms and reports: as [forms](https://artavolo.com/page/forms), [interfaces](https://artavolo.com/page/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](https://artavolo.com/page/import-data).
- Step by step pages: [Move from Excel](https://artavolo.com/migrate/excel) and [Move from Access](https://artavolo.com/migrate/access).

## Related

- [Import a CSV, Excel or JSON file](https://artavolo.com/page/import-data)
- [Link records between tables](https://artavolo.com/page/link-to-another-record)
- [Formula fields](https://artavolo.com/page/formula-field)
