Skip to main content
Sign in

How to convert CSV file into a Geosoft XYZ file (*.xyz).

Permanently deleted user
  • Updated

Objective:

I have a CSV file that I would like to convert into a Geosoft XYZ file.

Resolution:

  1. Using Windows Explorer create a copy of your CSV file. (Ctrl-C and then Ctrl-V).
  2. Also in Windows Explorer, change the extension of your CSV to XYZ by right-clicking and selecting rename.
  3. Open the file in a text editor.
  4. Add a / to the first line to indicate that it is a header row and save.

For example:

The following is an example of a CSV file

     Line,X_MGA50,Y_MGA50,X_Local,Y_Local,Mag
     441,714660,6532600,0,4300,-125.8231964
     441,714670,6532600,10,4300,-125.9256592
     441,714680,6532600,20,4300,-125.5170517
     441,714690,6532600,30,4300,-124.8635559

The following is an example of a Geosoft XYZ file

     /Line,X_MGA50,Y_MGA50,X_Local,Y_Local,Mag
     441,714660,6532600,0,4300,-125.8231964
     441,714670,6532600,10,4300,-125.9256592
     441,714680,6532600,20,4300,-125.5170517
     441,714690,6532600,30,4300,-124.8635559

Notes:

The Geosoft Viewer does not allow for importing of CSV file formats.  If you need to share a CSV with someone using the Geosoft Viewer, this trick may come in handy for sharing data.