Generating multiple entities from a spreadsheet or CSV
Follow the steps below to extract structured entities from an uploaded spreadsheet within an investigation.
When importing a list of companies, people or similar data objects, it is helpful to convert your raw data into structured entities that Aleph can use to classify those entities for searching, cross-referencing, and many other operations.
For small and mid-size datasets, follow the instructions below to map your data into structured entities using the Aleph mapping editor. To map very large data straight from a SQL database, or to map complicated relationships, you will have to create a mapping file instead.
-
Follow the “Importing documents and files” steps above to import your .csv, .xls, or .xlsx data file to an investigation.
-
Select columns from your data to use as unique keys for each entity.
Keys are usually ID numbers, email addresses, telephone numbers, or other properties of your data which are guaranteed to be unique. The more columns you are able to select as keys, the better, to ensure that Aleph correctly generates an entity for each unique entry in your data.
-
Verify and submit your mapping. When a mapping is submitted, Aleph will automatically generate structured entities based on the instructions you have provided it. It is important to note that any future edits you make to the mapping will re-generate these entities. Additionally, deleting the mapping will delete any entities generated from it.
-
After the entity generation process has finished, you should see your entities in the entities view of your investigation.