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 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 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 a column’s distinct and empty counts to read all of them.
  • Table name starts as the file’s name.
  • Every row your plan holds is added. To add only some, pick Custom and list them the way you pick pages to print, such as 1-10, 21-30.
  • Create table says how many rows it will add.
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.
Click a column’s distinct and empty counts. Value distribution shows the most common values with their counts and percentages, plus distinct and empty counts across all file rows. Other values accounts for values outside the top 20.Switch to Raw values to read values in file order. Use Previous and Next to page through the file. Values keep their original spelling, whitespace and leading zeros.Counts cover the entire CSV or selected Excel sheet before row limits. Blank data rows are skipped; whitespace-only cells are empty. Changing sheets recalculates the distribution.You can also ask the AI Assistant to inspect value distributions and raw values in an attached CSV or Excel file before creating a table.
Not here. Attach the PDF to the AI Assistant with Add files and ask for a table. It reads the table off the PDF’s pages and makes a table of every row, its columns named as the PDF names them. See Chat.
Oneprofile names the file’s size and how many rows your plan holds per table, then adds only the rows up to that limit. To add rows from further down the file instead, pick Custom and list them. They count against the same limit.Handing the file to the AI Assistant with Add files works the same way, and its reply names how many rows went in and how many the file had.
An Upgrade chip sits next to the message and takes you to raise the limit.
The banner on the new table says how many rows were added and how many could not be read. Show skipped rows lists each skipped row with the reason.
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.With Custom picked, it waits until the box under Rows to import holds rows to add.Once you leave the box, a typo puts “Use row numbers and ranges, like 1-10, 21-30.” under it. Rows past the end of the file name how many the file has.More than 100 ranges puts “Use at most 100 ranges, like 1-300.” under it. A choice bigger than your plan says how many rows a table holds.
Row 1 is the first row under the column names. Blank lines are not counted, so a row’s number can be lower than the one your spreadsheet shows.Ranges can overlap or run backwards. When you leave the box it tidies them, so 30-21, 5-15, 10-20 becomes 5-30.

​
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.