Skip to main content
Oneprofile can build a new table straight from a CSV file. Upload it, check the columns Oneprofile matched, adjust anything that looks wrong, then add the rows.

​
Bring in your file

1

Open the Import a CSV card

On the Tables page, choose the Import a CSV card. Its description reads “Bring a spreadsheet in as a new table.” This opens the Import a CSV dialog.
2

Add your file

Drag a CSV onto the dialog, or click to choose one from your computer. Oneprofile treats the first row of the file as the column names, and files must be under 50MB. While it reads the file, the dialog shows Reading the file….
3

Review the column mapping

Oneprofile shows a table with Column name, Type, and Sample values for every column it found, with a type already guessed for each, such as Text, Number, Date, or Email.Edit a column’s name directly in its field, or change its type from the dropdown if the guess is wrong. Untick a column’s checkbox to leave it out. Unticked columns are not added to the table.
4

Check the sample values

The mapping table only shows the start of a few values per column. Click the expand icon next to a column (“See all sample values”) to open a dialog titled Sample values for ”…”, with the column’s name in place of the ellipsis. It lists every sampled value with its row number, and names how many rows of the file it’s showing. Click Close when you’re done.
5

Name the table and set how many rows to add

Set the Table name field. Oneprofile suggests the file’s name to start, and asks for one if you clear it. The Rows to import field is seeded with the whole file. Lower it to add only some of the rows.
6

Create the table

Click Create table. It stays disabled until every included column has a name and no two share one, for example “Every included column needs a name.”
If a file has more rows than your plan holds in one table, Oneprofile names both the file’s size and how many rows fit, and adds only the rows up to that limit. An Upgrade chip next to the message takes you to raise it.
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.

​
After you create the table

Oneprofile takes you straight to the new table. Adding the rows runs in the background as a run, so you can start working, such as adding a column, before it finishes.

​
Next steps

  • Enrichment columns: Add columns that fill themselves in from multiple sources
  • Quickstart: Go from a new workspace to your first table
  • Find leads: Search for people or companies to fill a table