Upload Data into a Table
Copy a prompt, paste it into NocoAI in any base, and replace the words in [brackets] with your own.
- Import the attached file into this table
- Import the attached file into [Contacts], matching its columns to the existing fields
- Import the attached file into this table and tell me how many records were added
Import data from CSV / Excel
Accessing import modal
- In the toolbar, click the
⋮context menu. - In the dropdown menu, select
Upload. - Select
CSV/Excel.

Importing file data
-
Select the file to upload
Add the source file in one of two ways:
- Upload : Upload a file from a local directory. Click 'browse file', or drag and drop the file.
- Add from URL : Enter the URL of the file.
-
(optional) Select the character encoding. The default is
UTF-8. -
Advanced Settings : Use first record as header
- Enabled by default. If selected, NocoDB uses the first record in the spreadsheet as the header. Its contents become the field names.
-
Click
Upload files. -
Mapping Fields (Optional)
- To change the mapping, click the destination field and select a field in the dropdown menu.
- The NocoDB field column (on the right) lists the existing field names. The Field column (on the left) lists the new fields found in the import file.
- NocoDB maps the field names in the import file to the NocoDB field names automatically.
- You can map a source column that does not match an existing field to a new field. Refer to Mapping a column to a new field.
-
Exclude fields (Optional)
- To exclude a field from the import, clear its checkbox.
-
Allow create missing select field options (Optional)
- If enabled, NocoDB creates the select field options that are not already in the table.
-
Initiate Import
- Click
Upload. The file import starts.
- Click


When the import is complete, NocoDB adds the imported data to the end of the existing table.
A column that you map to an Attachment field imports only when its values hold attachment data. A CSV or Excel file that was exported from NocoDB writes each attachment as text, so the Attachment field stays empty for those records. The rest of the record imports as usual.
Mapping a column to a new field
If a source column does not match a field in the destination table, you can create a field for it. You then do not lose the column.
- Open the destination dropdown for that column.
- Select Create new field. The row shows the field name with a New badge. This tells you that NocoDB creates the field during the import.
Notes:
- NocoDB creates new fields as
Single line text. You can change the field type after the import is complete. - If the title of a source column matches an existing field, the column maps to that field. NocoDB does not create a duplicate.
- If NocoDB cannot create a field, it skips that column and continues the import. For example, this happens when your plan's field limit is reached.
Excluding sheets from a multi-sheet Excel workbook
When you upload an Excel workbook with more than one sheet, each sheet has a checkbox next to its name. Use the checkbox to exclude a sheet from the upload. An excluded sheet shows the label Won't be imported. At least one sheet must stay included, or the upload cannot continue.
Last updated on