Skip to main content

Import data from Excel or CSV

Create a new database app from an Excel or CSV file, or add and update records in an existing one. Map columns to fields, handle duplicates, and import.

Written by Leo

An import moves the rows of an Excel (.xlsx) or CSV (.csv) file into Tape as records (each row becomes one record, each column becomes a field). It's meant to help you bring data from spreadsheets into one place without typing it in again.

You can use imports for many things, including:

  • Loading a list of property owners from a spreadsheet into a new CRM database app.

  • Updating the prices of your solar panel catalog from a fresh file every month.

The Create a new app window with the app name Properties, Customize import, Duplicates, the ••• button, a preview table with field names and types, and the Cancel and Import buttons

Note:

  • Only .xlsx and .csv files work. Tape shows a message for any other format, and for a file that's too large.

  • Imports are quiet by default. Send notifications, Trigger automations, and Trigger webhooks are off, so an import doesn't notify people or start automations unless you turn them on.

  • Unmapped columns aren't imported. Only columns with a field next to them are saved.

  • You can't import on a phone. Import doesn't appear in the app menu on a smartphone. Use a browser on a computer or a tablet.

Who can import data?

  • Import is available on all plans: Free, Plus, and Premium. Learn more about plans →

  • To create a new database app from a file, you need to be allowed to edit apps in the workspace. The workspace setting Who can edit workspace apps? decides this: Any workspace member or Only workspace admins. Learn more about workspace settings →

  • To import into an existing database app, you need Full access to it.

Create a new database app from a file

To turn a spreadsheet into a database:

  1. In the sidebar, hover over the workspace name and click +. You can also click + in the tab bar of the workspace.

  2. Select Import. Its description reads Excel, CSV.

  3. Choose an Excel or CSV file from your computer. Tape shows Generating preview….

  4. In the Create a new app window, select the app name to rename the app.

  5. Check the preview table. Select a field name in the table to rename the field or change its type under Type.

  6. Select Import.

Tape picks a field type for every column for you. You can change the choice in the preview before you import.

Hovering over a workspace in the sidebar, selecting +, then Import (Excel, CSV), and choosing a file opens the Create a new app window with a preview

Import into an existing database app

To add records to a database you already have:

  1. Open the database, open the app menu, and select Import. The tooltip of the app menu reads Follow, export and more….

  2. Choose an Excel or CSV file from your computer.

  3. In the window, check the preview and the mapping. Its title names your database app, for example Import into Tenants.

  4. Select Import.

Selecting Import in the app menu and choosing a CSV file opens Import into Expenses with the preview of the rows, Customize import, and Import

Tape matches columns to fields by name when it can. Select Customize import to change the mapping.

Customize import

Customize import holds the settings of the import and the mapping of columns to fields.

The Customize import panel in Import into Expenses with Character code, Seperated by, Create missing select options, Exclude first row, Show more settings, and the CSV columns mapped to fields
  • Use first row as headers: for a new database app, the first row of your file gives the field names. For an existing database app, the same switch reads Exclude first row and skips the first row, so a header row isn't imported as a record.

  • Auto-select field types: only when you create a new database app. Tape picks a field type for every column from the data in the file.

  • Create missing select options: only when you import into an existing database app. Tape adds options that are in your file but not in the select field yet. It's on by default.

  • Show more settings: shows Send notifications, Trigger automations, and Trigger webhooks. All three are off by default.

For a CSV file, two more settings appear:

  • Character code: UTF-8, UTF-16, or ISO-8859-1. Change it if special characters look wrong.

  • Seperated by: Comma or Semicolon. Change it if all values land in one column.

Under CSV columns (or Excel columns for an Excel file), every column of your file has a field next to it. Select Map field to search for the field that should receive the column with Search for a field…. Select Clear mapping to remove all mappings. The button then reads Reset mapping, and selecting it brings back the suggested mapping. A field that was left unmapped isn't imported.

Some fields can take several columns. When you map a column to such a field, choose which part of the field it fills:

  • Date field: map one column to Start and another to End, for example a start date and an end date.

  • Phone field: map each column to a type, such as Mobile, Work, or Home.

  • Email field: map each column to Work, Home, or Other.

If a column doesn't fit its field, Tape shows May have data loss next to the mapping. Check the preview before you import.

Handle duplicates

Select Duplicates to decide what happens with rows that match a record that's already there. This matters most when you import into an existing database app:

  • Create: adds every row as a new record, even if the same data is already in the database.

  • Skip: doesn't add a row if its data matches a record that's already there.

  • Update: updates the whole record if its data matches.

The Duplicates menu in Import into Expenses with Create selected, Skip, and Update, and the hint Add all duplicates as new records to the existing app

With Skip or Update, you choose how Tape finds a match. Under Match Tenants by (with the name of your database app), pick one or more fields, and select Add field to add more. A row matches when its values in these fields match a record.

With Update, the switch Skip empty CSV values (Skip empty Excel values for Excel) shows up. Turn it on to keep existing values when the cell in your file is empty, instead of clearing them.

Tip: Use Update with Skip empty CSV values if your file only has some columns filled in. Existing values in the other fields stay as they are.

Import related database apps

When you import into an existing database app that has a relation field, the import can reach the related database too. In the preview, select the app name at the top to open the list. It shows Import app and, below it, Related apps. Select a related database to map columns to its fields.

The app name list in Import into Expenses with Import preview, Expenses under Import app, and Tasks under Related apps

Tape imports the columns you map to the related app first, as records of that database, and then links them to the records of your main database through the relation field. With Skip or Update under Duplicates, Tape looks for matches in the related database with the fields you choose under Match Owners by (with the name of the related database app). A row that matches is linked to the existing record instead of creating a new one.

Undo, restore, and reset settings

The button with the tooltip Undo, history and more holds Undo and Redo. For an existing database app, it also shows All settings with:

  • Restore: lists earlier imports of this database. Select one to use its settings again.

  • Reset: sets everything back to the default.

The menu Undo, history and more in Import into Expenses with Undo, Redo, and All settings with Restore and Reset

Start the import

Select Import at the bottom of the window. The bar at the bottom tells you what you're about to import, for example how many rows come from which file. Select Cancel to leave without importing. If you made changes, Tape asks whether to discard them.

The toast Importing data appears. Select Hide to hide it, and keep working. When the import is done, the toast Imported data successfully appears. Select View to open the database. Large files take a bit longer.

Let's look at an example

Let's say Juliet Adams manages rental properties and keeps her tenants in a spreadsheet. Here's how she imports it:

  1. She clicks + next to her workspace, selects Import, and chooses tenants.xlsx.

  2. In the preview she renames the app to "Tenants" and checks that the column "Monthly rent" became a Number field.

  3. She selects Import.

A few moments later, the database app "Tenants" has one record for each row of the spreadsheet.

Import errors

  • "Can’t import CSV file". The file couldn't be read. Check that it's a valid CSV file, or change Seperated by in Customize import.

  • "Can’t import Excel file". The file couldn't be read. Check that it's a valid Excel file.

  • "Your file exceeds the maximum allowed size". Split the file into smaller files and import them one after another.

  • "Invalid file format provided, only XLSX and CSV are supported". Save the file as .xlsx or .csv and try again.

  • "Importing data failed". Try again. Check the mapping and the file first.

Import from Podio, Asana, HubSpot, Salesforce, or another platform

Moving from another platform? You don't have to export everything into spreadsheets first. Use the free Podio migration tool, work with a Tape Partner, or build a custom migration. Explore all migration options →

Test and edit an import

  • Import a small file first, with a few rows, to check the mapping.

  • To fix an import that went wrong, open the database app, select Import, and use Restore to bring back the settings. Then import the corrected file with Update.

  • To remove records you imported by mistake, delete them in the database. Learn more about deleting and restoring content →

Learn more

FAQs

Can I import into a database app that already has records?

Yes. Open the app menu, select Import, and choose a file. Use Duplicates to decide whether rows are added, skipped, or update existing records.

Can I update existing records with an import?

Yes. Select Duplicates → Update, then choose the fields that identify a record under Match Tenants by (with the name of your database app). Rows that match update the whole record.

Will an import notify people or start automations?

No, not by default. Send notifications, Trigger automations, and Trigger webhooks are off. Select Show more settings in Customize import to turn them on.

Which field types does an import create?

Tape picks a type for every column when you create a new database app, and you can change it in the preview. For an existing database, the columns go into the fields you map them to.

Can I import files or images?

No, an import doesn't fill Files or Image fields. Columns can go into text, number, date, select, status, member, email, phone, link, location, and relation fields.

Can I import on my phone?

No. Import isn't in the app menu on a smartphone. Use a computer or a tablet.

Are you a developer who wants to load data with code?

Yes, the Tape API can create and update records. Full reference: Tape developer docs →

Still have questions? Find answers and get help from community experts in the Tape community →

Did this answer your question?