Skip to main content
Oneprofile builds a new table straight from a CSV or Excel file. Upload it, check the columns Oneprofile matched, fix anything that looks wrong, then add the rows.
The Import from file dialog with a dashed drop area reading "Drop a file here, or click to choose one", and under it "CSV or Excel (.csv, .xlsx), up to 50MB. The first row is used as the column names."

The Import from file dialog, waiting for a file.

​
Import your file

1

Open the dialog

On Tables, choose the Import from file card. You can also click New and pick Import from file.
2

Add your file

Drag a file onto the dialog, or click to choose one. Oneprofile reads .csv and .xlsx, the first row becomes the column names, and files must be under 50MB.
3

Check the mapping, then create the table

Fix anything Oneprofile guessed wrong, then click Create table.
Oneprofile lists every column under Column name, Type and Sample values, with a type already guessed, such as Text, Number, Date or Email.
  • Edit a name in its box, change a wrong Type, or untick a column to leave it out.
  • The mapping shows only the start of a few values. Click the expand icon on a column to read all of them.
  • Table name starts as the file’s name. Rows to import starts at as many of the file’s rows as your table can hold, so lower it to add fewer.
Oneprofile takes you straight to the new table. Adding the rows is a run, so you can start working before it finishes.

​
Choose a sheet

A workbook can hold several sheets, so a Sheet dropdown appears above the mapping when yours does. Pick the sheet holding your data. Each sheet has its own columns, so switching starts the mapping again. Set the sheet first, then edit names and types.

​
Good to know

CSV files and Excel workbooks saved as .xlsx.Older .xls workbooks are refused, and Oneprofile says so. Open one in Excel, save it as .xlsx, and import that.
Oneprofile reads the file itself rather than trusting its name, so a workbook saved with the wrong extension still imports.
While it reads, the drop area says Reading the file…. A large file takes a moment. That message means it is working rather than stuck.
Two reasons, and Oneprofile names both above the mapping.Cells holding an Excel error such as #N/A come in blank, so one broken formula does not turn a whole column into text.Formulas your file has never calculated also come in blank, because the workbook carries no result for them. Open the file in Excel, save it, and import again.
The expand icon on a column is labelled See all sample values. It opens a dialog titled Sample values for ”…”, with the column’s name in place of the ellipsis.The dialog lists every sampled value with its row number, and names how many rows of the file it is showing. Click Close when you are done.
A column can look empty in the mapping table just because its first values are blank. Open its sample values before you trust the type Oneprofile guessed.
Oneprofile names the file’s size and how many rows your plan holds per table, then adds only the rows up to that limit.
An Upgrade chip sits next to the message and takes you to raise the limit.
It stays disabled until the mapping is valid, and the dialog names what is wrong. You will see “Include at least one column.” or “Every included column needs a name.” A column name used twice is called out by name.Table name cannot be blank either. Clearing it puts “The table needs a name.” under the field.

​
Next steps

Export a file

Take a table back out as a CSV or Excel file.

Import from a tool

Add rows from a tool you already use.

Enrichment columns

Add work emails, phone numbers and company facts from outside sources.

Create a table

Every other way to start a table.