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.
Note:
Only
.xlsxand.csvfiles 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, andTrigger webhooksare 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.
Importdoesn'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 memberorOnly workspace admins. Learn more about workspace settings →To import into an existing database app, you need
Full accessto it.
Create a new database app from a file
To turn a spreadsheet into a database:
In the sidebar, hover over the workspace name and click
+. You can also click+in the tab bar of the workspace.Select
Import. Its description readsExcel, CSV.Choose an Excel or CSV file from your computer. Tape shows
Generating preview….In the
Create a new appwindow, select the app name to rename the app.Check the preview table. Select a field name in the table to rename the field or change its type under
Type.Select
Import.
Tape picks a field type for every column for you. You can change the choice in the preview before you import.
Import into an existing database app
To add records to a database you already have:
Open the database, open the app menu, and select
Import. The tooltip of the app menu readsFollow, export and more….Choose an Excel or CSV file from your computer.
In the window, check the preview and the mapping. Its title names your database app, for example
Import into Tenants.Select
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.
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 readsExclude first rowand 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: showsSend notifications,Trigger automations, andTrigger webhooks. All three are off by default.
For a CSV file, two more settings appear:
Character code:UTF-8,UTF-16, orISO-8859-1. Change it if special characters look wrong.Seperated by:CommaorSemicolon. 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
Startand another toEnd, for example a start date and an end date.Phone field: map each column to a type, such as
Mobile,Work, orHome.Email field: map each column to
Work,Home, orOther.
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.
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.
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.
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:
She clicks
+next to her workspace, selectsImport, and choosestenants.xlsx.In the preview she renames the app to "Tenants" and checks that the column "Monthly rent" became a
Numberfield.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 byinCustomize 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
.xlsxor.csvand 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 useRestoreto bring back the settings. Then import the corrected file withUpdate.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?
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?
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?
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?
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?
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?
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?
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 →
