Users can upload a CSV or Excel file containing names and be returned with a CSV that includes the probabilities of the names' nationality. The data is the same as provided via the nationality API.

Uploading a CSV or Excel file with the following information:

will produce the following result:

Instructions

Follow the below instructions to enrich your Excel and CSV files with nationality data.

1) Begin an upload

Navigate to the upload page in your account and click the Drag and drop or browse file area. Alternatively you can drag a file to that area.

2) Select a file

Select a file from your computer and press Open.

When it has uploaded you will be shown the following success message.

Refresh the page. Below the upload area the file will appear in a list with the status Pending Analysis. Analysis should be complete in around one minute for uncompressed small to medium sized files.

3) Configure

When analysis is complete the file's status will change to Configure. Under Actions, click Configure to configure your file for processing.

You will be redirected to a page that has several options to configure your file and shows a preview of your file. Ensure your file is displayed correctly - see the sections for controls and encoding.

You will find the following configuration options at the top of the page:

• First Name Field - select the column that contains the first name
• Surname Field - select the column that contains the surname
• Second Surname Field - select the column that contains the second surname (for Spanish and Portuguese names)

The above fields will provide options for the column name (if your file contains a header), otherwise they will contain values from the first row of your file.

• Number of Nationalities To Include in Output - the number of nationalities to add to each row, which can be between 1 and 250

Entering 1 will output a result like:

While entering 3 will output a result like:

• Output Format - whether you would like nationalities to be added to one or multiple columns

The split option will output a result like:

While merged will output a result like:

• Insert After Column - select the column to insert OnoGraph data after

For Column Separator, Column Enclosure and Character Encoding see the relevant sections.

• Ignore first row of file (headers) - select to ignore the first row from processing if it contains the column names

For Sanitize names see the relevant section.

• Trim first name - select to remove middle names from the first name, e.g. if the first name is John Peter the name will be processed as John; particles such as the La in La Tonya and the St in St John are preserved
• Trim surname - select to remove multiple surnames from the surname and second surname, e.g. if the surname is is dos Santos Teixeira the surname will be processed as dos Santos; particles such as the van der in van der Sar and the Abd El in Abd El Rahaman are preserved

Once configured the page will look something like:

The first row is faded as it was selected to be ignored, owing to it containing column names.

The columns containing first name and surname have been highlighted and titles have been added above the columns.

A column with the text OnoGraph data inserted here shows the area where OnoGraph data will be inserted.

Press the Begin Processing button at the top right to queue your file for processing. This will show the following message:

4) Processing

Returning to the upload page your file's status will now be Pending Processing.

Your file may begin processing from one minute after it was configured.

When processing begins its status will be marked as Processing and will show the percentage completed.

5) Download

Once complete the Status will be marked as Complete. Under Actions select Download CSV to download your enriched file.

You should download the file at the earliest convenience, as files may be deleted after seven days.

The result will look something like: