Measurements Page
CSV Import
The CSV Import tab on the Measurements page lets you upload a CSV file containing coordinate data, map the columns, preview the points on a map, and save them as a point set for use across the site. It supports automatic coordinate system detection and flexible file formats.
![[Screenshot: CSV Import tab showing a file upload area, column mapping dropdowns, a detected coordinate system badge, and a Leaflet map preview with imported points plotted]](/images/placeholder.png)
Uploading a CSV File
Click the upload area or drag and drop a CSV file onto it. SiteView reads the file and displays the first few rows in a preview table so you can verify the data looks correct before proceeding.
Supported Formats
| Format | Details |
|---|---|
| Comma-separated (CSV) | Standard CSV with commas between values |
| Tab-separated (TSV) | Values separated by tab characters |
| Header row | Optional — if present, column names are used in the mapping dropdowns. If absent, columns are labelled Column 1, Column 2, etc. |
| Encoding | UTF-8 (recommended), ASCII, and Latin-1 are supported |
💡 Tip
If your CSV file was exported from survey software, check that it uses a standard delimiter (comma or tab). Some survey software exports with semicolons or spaces as delimiters — convert these to commas before uploading.
Column Mapping
After the file is loaded, the column mapping interface appears. You need to assign each required field to a column from your CSV:
| Field | Required | Description |
|---|---|---|
| Point ID / Name | Optional | An identifier for each point (e.g., "CP01", "BM-A") |
| Easting / Longitude | Required | The X coordinate or longitude value |
| Northing / Latitude | Required | The Y coordinate or latitude value |
| Elevation / Height | Optional | The Z coordinate or height value |
| Code / Description | Optional | A classification code or description for each point |
Use the dropdown selectors to match each field to the appropriate column in your CSV. If your file has a header row, the column names appear in the dropdowns to make mapping easier.
Coordinate System Detection
SiteView analyses the coordinate values and attempts to auto-detect the coordinate system:
| System | Detection Logic |
|---|---|
| WGS84 (Decimal degrees) | Values in the range of typical latitude (-90 to 90) and longitude (-180 to 180) |
| MGA2020 | Easting values in the range 100,000 to 900,000 and Northing values in the range 1,000,000 to 10,000,000 |
| NZTM2000 | Easting values in the range 1,000,000 to 2,200,000 and Northing values in the range 4,700,000 to 6,400,000 |
The detected system is shown as a badge above the map preview. If the auto-detection is incorrect, you can manually override it by selecting the correct system from a dropdown.
ℹ️ Did you know?
For MGA2020 coordinates, SiteView also attempts to detect the zone from the Easting and Northing ranges. If multiple zones are possible, you will be prompted to select the correct zone manually. See Auto-Detection for more details on how detection works.
Map Preview
Once columns are mapped and the coordinate system is confirmed, the imported points are plotted on a Leaflet map preview. This gives you a visual check that:
- Points are in the expected geographic location
- The coordinate system detection is correct (points in the wrong system will appear in the ocean or on the wrong continent)
- No obvious outliers or data errors exist
The map auto-zooms to fit all imported points. Hover over a point to see its coordinates and any mapped attributes (ID, elevation, code).
⚠️ Watch out!
If the map preview shows points in an unexpected location, the coordinate system is likely wrong. Use the manual override to select the correct system before saving. Importing with the wrong coordinate system will result in incorrect positions on the site map.
Saving as a Point Set
When you are satisfied with the import, click Save as Point Set. You will be prompted to:
- Name the point set (e.g., "Ground Control Points", "As-Built Survey March 2026")
- Assign to a site — select which site this point set belongs to
- Set a category — optionally categorise the points (e.g., "Control", "As-Built", "Design")
The points are saved and become available on the selected site's map and in the Measurement Register.
Handling Large Files
For files with many thousands of points, the map preview may initially show a clustered view. Zoom in to see individual points. The import process handles large files efficiently, but extremely large datasets (100,000+ points) may take a moment to parse and render on the preview map.
What's Next?
- Measurement Register — view and manage imported point sets alongside other measurements
- Coordinate Converter — convert coordinates between systems before or after import
- Calculator — perform calculations with imported coordinates
- Auto-Detection — learn more about how SiteView detects coordinate systems