To import and ensure your Common Separated Values (CSV) file is compatible with Virtual Surveyor, you'll need to organize the data in the .csv file for Virtual Surveyor to read it properly.


Overview


How to Import a CSV

To import a .csv (or .txt) file, you can use one of two options:

  1. Drag and drop your data anywhere in the Virtual Surveyor window.
    or
  2. Click or choose files and load your data from the File Explorer.


The information is loaded instantly and can be viewed on your Elevation Terrain as well as in the Project View.



CSV File Format

You can preview and change the .csv file information in programs like Excel or Notepad. Virtual Surveyor can read a .csv file that contains the following rows and columns of information:

  • Column Headers
  • Coordinates
  • EPSG Code (optional)



Column Headers

You will need to make sure the .csv file has column headers. The point file must contain X, Y, and fields at a minimum. You can also include optional fields under the P, D, Photo, Layer, or Number headers. Virtual Surveyor uses the PXYZD column headers by default. 

  • P - Point number
  • X - Easting/Westing coordinate of the point
  • Y - Northing/Southing coordinate of the point
  • Z - Elevation of the point
  • D - Descriptor 
  • Layer - Point layer


 

  Header Terminology! You can use the following terminology for the column headers:



Column HeaderSupported Terminology (not case sensitive)
P (Point Number) (can include both point numbers and descriptors)p
name
label
tag
title
Xx
xcoord
x coord
x-coord
x coordinate
x-coordinate
longitude
easting
westing
long
Yy
ycoord
y coord
y-coord
y coordinate
y-coordinate
latitude
northing
southing
lat
Zz
zcoord
z coord
z-coord
z coordinate
z-coordinate
height
elevation
altitude
D (Descriptor) (does not include point numbers)d
descriptor
Photo pathphoto
image
path
Layerlayer
group
Number (does not include descriptors)number


Column Order and Optional Headers

The order of the columns is not significant, just make sure that the column header is over the appropriate information in each respective column. It's not an issue if the files contain extra columns generated by the survey equipment as Virtual Surveyor only reads the data in the columns with PXYZD, along with the additional headers Photo, Layer, and Number.


Below is an example image that includes the Layer column. Using a Layer column will automatically create a new layer (or multiple new layers) in the Project View. You create multiple layers in the Project View by using different names for different rows of coordinate data, or name all the rows under one Layer name to keep all your .csv data as a single layer in the Project View.



EPSG Code

The EPSG code is completely optional to include as part of your .csv file import. It is a simple yet powerful method for including your data coordinate system to your project when you upload your points so that they are more accurately located on your Elevation Terrain. If you do plan to include an EPSG number, place it in the first row of your .csv file without any spaces, and ensure it includes the "#" symbol, "EPGS", the colon ":", followed by the area number, e.g. "#EPGS:1234".



Regional Format Settings

Keep in mind that the .csv file is formatted according to your Windows regional settings. Before importing a .csv file, be sure to set different symbols for decimals and list separators. Have a look at that Windows support article to learn more about how to tune those settings. If you change your regional settings, don't forget to restart Virtual Surveyor before importing more point files.