The data from any view can be exported as a CSV file with comma delimiters and quotes.
A CSV file is a comma delimited ASCII data file that can be read directly by Microsoft Excel spreadsheet. In fact, if you have Microsoft Office installed on your computer and double click a CSV file in Windows explorer, it will launch Microsoft Excel and open the file.
Every line in a CSV file must be formatted the same and every item in a line forms a column in Excel.
Here is an example of a Traverse View added to the current report:
Point Type Bearing HorizDist Radius ArcLength Delta Northing Easting Description
1 0.000 0.000 FND 1" IRON
2 N90°00'00"E 284.880 0.000 284.880
3 N23°27'00"E 163.500 149.996 349.945 FND 5/8" RE
4 S90°00'00"W 291.030 149.996 58.915
5 PC S30°40'00"W 14.080 137.885 51.733
1:1 PT S20°34'10"W 147.270 -420.000 148.035 20°11'41" 0.004 -0.009
Here is that same traverse exported as a CSV file:
"Point","Type","Bearing","Horiz Dist","Radius","Arc Length","Delta","Northing","Easting","Description"
"1","","","","","","","0.000","0.000",FND 1" IRON
"2","",N90°00'00"E,"284.880","","","","0.000","284.880",""
"3","",N23°27'00"E,"163.500","","","","149.996","349.945",FND 5/8" RE
"4","",S90°00'00"W,"291.030","","","","149.996","58.915",""
"5","PC",S30°40'00"W,"14.080","","","","137.885","51.733",""
"1:1","PT",S20°34'10"W,"147.270","-420.000","148.035",20°11'41","0.004","-0.009",""Notice how blank fields still have quotes, but no data.
TPC uses the format of the view to define the format of the CSV file. Every column creates a data item for every row in the view, even if that particular cell is blank.
TPC uses commas to delimit the data items in a row and places quote marks around each data item except those that already include a quote in their formatting, like angles and bearings. These items are not quoted. The use of quotes allows point descriptions, traverse names and other text items to be read as a single data item, even if they include embedded commas.
The Traverse View has two modes that affect how the CSV file is written.
Display Raw Data – If you choose to display raw data then export a CSV file, the raw data will be exported to the CSV file, not the inverses. The rule to remember is that the CSV file includes the exact same data you see in the view.
Single Row – If you choose the Single Row option in the Traverse View, you will get one line per point in the CSV file. If you do not have Single Row selected in the Traverse View, the CSV file will use two lines per point. Again, the CSV file includes exactly what you see in the view.
Personal, Premium, Professional