Import Station, Offset, and Elevation Files (.csv)

Import a text file (.csv) of station, offset, an elevation values to create points or stored cross-sections associated with an alignment in your project. You can then use the data to create a surface. To import a file, follow the instructions in Import Data.

Note: Before selecting a Station/Offset/Elevation .csv file to import using the Import pane, right-click the file in the Select File(s) list and select the file type Station/Offset/Elevation.

Rules for importing a station, offset, and elevation file:

  • The name of the .csv file must match the name of an alignment in your project, if you have more than one alignment. If you have only one alignment, the indicated .csv file will be imported with respect to that alignment. If you do not have an alignment, the importer will not work.
  • The header (first line) in the file must contain the phrase "TBC Excel" (in English). The header can contain other explanatory text beyond the above key phrase.
  • The second line in the file is expected to contain the first cross-section node data.
  • The order of the data fields associated with each cross-section node is Station,Offset,Elevation,Code.
  • Unless otherwise noted in the header line, the default delimiter between data fields is a comma. However, if the header line is found to contain a semicolon, that is an indication of the fact that the delimiter is expected instead to be a semicolon.

Sample:

  • Alignment in project: First Street
  • File name: First Street.csv

File data showing the header and first two cross-sections:

TBC Excel - Station,Offset,Elevation,Code

20,-8.89,59.36,TIEL

20,-3.8,62.75,SHLDL

20,-2.5,62.83,EOPL

20,0,62.9,CL

20,2.5,62.98,EOPR

20,3.8,63.02,SHLDR

20,8.65,59.78,TIER

30,-8.89,59.36,TIEL

30,-3.8,62.75,SHLDL

30,-2.5,62.83,EOPL

30,0,62.9,CL

30,2.5,62.98,EOPR

30,3.8,63.02,SHLDR

30,8.65,59.78,TIER

Related topics

Import Data

Run an Import Report