CSV Data
Import point data from CSV (comma-separated values) files. This is useful for converting spreadsheet data with addresses or coordinates into map features.
Required Columns
Your CSV file must include columns for geographic coordinates. MapEdit supports two formats:
- Separate columns — One column for latitude, one for longitude
- Combined column — Single column with "lat,lng" values (e.g., "40.7128,-74.0060")
Column names are flexible. MapEdit auto-detects columns named "lat", "latitude", "lng", "longitude", "coordinates", "coords", "latlng", etc.
Importing CSV
- Open the Import/Export panel
- Click the Import tab
- Drag and drop your CSV file
- Review the column mapping preview
- Select which columns contain latitude and longitude
- Click Import
Column Mapping
The import dialog shows a preview of your data and lets you choose between:
- Separate columns — Select individual latitude and longitude columns
- Combined lat,lng — Select a single column with comma-separated coordinates
- Name column (optional) — Choose a column for feature labels
- All other columns become feature properties
Coordinate Formats
MapEdit accepts decimal degree coordinates (e.g., 40.7128, -74.0060).
Make sure your coordinates use the correct sign. Western longitudes and southern latitudes should be negative (e.g., -74.0060 for New York). DMS (degrees/minutes/seconds) format is not currently supported — convert to decimal degrees before importing.
Example CSV
Separate columns:
name,latitude,longitude,category Central Park,40.7829,-73.9654,Park Times Square,40.7580,-73.9855,Landmark Empire State,40.7484,-73.9857,Building
Combined column:
name,coordinates,category Central Park,"40.7829,-73.9654",Park Times Square,"40.7580,-73.9855",Landmark Empire State,"40.7484,-73.9857",Building
Tips for CSV Import
- Include a header row with column names
- Use UTF-8 encoding for special characters
- Avoid empty rows or inconsistent columns
- Check that coordinates are in the right columns
After Import
Imported CSV data becomes point features. Each row creates one point with:
- Location from the coordinate columns
- Properties from all other columns
- Use data-driven styling to color by any property