Skip to main content

CSV import

Import your data from a CSV file.

First line of the CSV file must contain field names. Fields must be comma-separated, lowercase ("title", not "Title"), text fields that contain comma must be surrounded with double quotes "...".

Before importing the CSV file create all fields in Database > Edit fields section.

Also, if you import the Location field, first choose the language of addresses in Database > Edit fields > Location > Language.

Formatting

MapSVG field typeHow to import from CSV
Select, RadioImport as "value" numbers or text "labels". Whatever works for you. Example: if you have an "area" select field with the following options in MapSVG:
North:1 South:2 East:3 West:4
These would be correct CSV values
area
1
2
East
West

Incorrect CSV values
area
South-West
64

CheckboxImport as 1/0 or true/false.

Correct CSV values
my_checkbox_field
1
0
true
false

Incorrect CSV values
my_checkbox_field
yes
no

LocationImport as "lat,lng" coordinates or as an "address" string. If you import an address - it gets converted to coordinates. If you import coordinates - they get converted to an address. And then both values (address & coordinates) are stored in the _Location_ field.

Please note that Google allows only 50 requests per second to the Geocoding API (which converts address to coordinates or the other way around) so if you're importing many locations - it can take quite a long time, so be patient and don't reload the page. Also, Geocoding API has a limit of 2500 requests per day.

Correct CSV values
location
45.1233, 56.9812
Main st. 1, New York, USA
London
Paris

Incorrect CSV values (coordinates are outside of the correct range -90,-180 .. 90,180)
location
99.1211,199.2323
RegionsImport as comma-separated list of region IDs.

Correct CSV values (on example of /geo-calibrated/usa.svg file)
regions
US-TX,US-AL,US-NY
US-OR

Incorrect CSV values
regions
Texas,Oregon
US-TX US-AL US-NY