A CSV format file with locations data can be used to import them in bulk. To use the feature navigate to "Others" > "Location CSV Import" on admin panel.
This will bring up the first step of wizard for you.
Initially you will be required to select the file you want to import the data from.
The CSV file is expected to have data under these heads for every location :
Name - It is the only mandatory field
Latitude - A numeric value to denote the latitude for location
Longitude - A numeric value to denote the longitude for location
Visible on locations page - It can be either "Yes" or "No" ; a blank value means "No"
Parent Location - A numeric value representing the id of parent location , you need to refer the existing locations to get their id visible on the locations index ; a blank value means the location will be imported at the top most level
A CSV file with sample data for a few states of USA has been attached with this article.
Check "Has Headers" if your file has column headers in the first row.
On this step you will be asked to map each column of your CSV against field for location on the website.
Next screenshot shows the values available in drop down.
Once the mapping is done and you hit the "Next" button, the import process would start.
Please note that if you close the tab that shows the import progress then in the future whenever you return to locations import page, you will be asked whether you want to continue with the incomplete import (this is applicable only when application cache is not cleared).
Hint: Try importing 4-5 locations in your first attempt and make sure all data is imported correctly, before doing a bulk import.