Import Venues from CSV

Updated 2 min read

Applies toBandArtist profileRequiresContributor or higher

Import Venues from CSV imports a UTF-8 CSV file through column mapping, preview and import. It adds new entries and reports duplicates that were skipped. Contributor or higher.

Open the import

  1. Open Venues under Network.
  2. Select Import in the page toolbar.

The title is Import Venues from CSV.

Choose the file

Select Choose CSV file. The file needs a header row. Empty lines are skipped. Header aliases such as name, email and phone are mapped automatically when recognized. Review those mappings before importing.

Map columns

FieldMapping
Venue nameRequired. Select the column containing a name for each entry.
CategoryOptional. Select a source column or leave (not mapped) selected.
TitleOptional. Select a source column or leave (not mapped) selected.
Given nameOptional. Select a source column or leave (not mapped) selected.
Family nameOptional. Select a source column or leave (not mapped) selected.
Organization nameOptional. Select a source column or leave (not mapped) selected.
Street and numberOptional. Select a source column or leave (not mapped) selected.
Street additionalOptional. Select a source column or leave (not mapped) selected.
Postal codeOptional. Select a source column or leave (not mapped) selected.
CityOptional. Select a source column or leave (not mapped) selected.
RegionOptional. Select a source column or leave (not mapped) selected.
CountryOptional. Select a source column or leave (not mapped) selected.
WebsiteOptional. Select a source column or leave (not mapped) selected.
PhoneOptional. Select a source column or leave (not mapped) selected.
EmailOptional. Select a source column or leave (not mapped) selected.
LatitudeOptional. Select a source column or leave (not mapped) selected.
LongitudeOptional. Select a source column or leave (not mapped) selected.

Select Preview to continue.

Category cells accept venue or festival, ignoring case. Other values or an unmapped category become Venue.

Preview and import

  1. Review the first five rows and the total number of importable rows. Rows without a name are excluded from import.
  2. Select Import n rows.
  3. Read the number imported and the number skipped as duplicates, then select Close. The list reloads.

Cancel closes before import. Importing needs an internet connection.

Actions

ActionWhereWhat it does
Choose CSV fileUpload stepOpens the CSV file picker.
PreviewMapping stepChecks the required mapping and opens the preview.
Import n rowsPreview stepAdds rows with names.
Cancel / CloseBottom of the dialogCloses the import.

Next steps