Paste CSV or tab delimited data into the box below and click Analyse.
Only one record type can be imported at a time. It is best to break large files into blocks of a couple of thousand lines
geographic data is accepted in OpenGIS WKT format, e.g. POINT(x y). See this Wikipedia article for more details.
To specify multiple values for a repeatable field, separate the values with a | (pipe) symbol within the field, eg. 1,2,"3|4",5
Select record type or select saved mapping. Then select column assignment and click Prepare Records.
Duplicate records: ignore
In order to normalise the data, eg. to extract a list of persons (entities) as records and then point to these person records rather than including names repetitively in the main data records, start by importing only those fields relating to the entities to be normalised. After import, the data will be redisplayed with the ID numbers for the extracted records, which can be used as a pointer field in the subsequent import of the remaining columns of data.
You needn't assign all the columns - unassigned columns will be ignored.
Duplicated records will be treated as you specified.
Invalid records are marked in red. If no specific message is shown, the most likely cause is that the data contains no value for a required field.
After click 'Save records' it updates the database (irreversible, except by editing the database).