|
|
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 corresponds with a column in Excel.
Here's an example of traverse data exported as a CSV file.
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.
Exporting Survey Data as a Microsoft Excel File
You can export data from TPC's Views to CSV files. This is a handy way to make a copy of the data.
Generic Data Files
TPC has a file type it calls Generic (Raw) Data that uses the CSV file format and extends it to cover both coordinates and raw data.
In TPC, you can both Import Generic files and Export Generic files.
ASCII vs CSV
In TPC Desktop, ASCII files handle just coordinates and geodetic positions, while CSV files can handle both, but are used primarily for raw field data.
See ASCII vs CSV.
Related Topics
Exporting Data Export data from TPC's Views to CSV files Import Generic Export Generic
Editions
Personal, Premium, Professional
|
|