Welcome to Golden Software Support

Importing XYZ - when it isn't quite XYZ format

Comments

5 comments

  • Avatar
    Kari Dickenson

    Hello,

    Since the data is in a matrix form already, you can use it directly as a grid file as-is, provided that:

    1. it is regularly spaced in the X and Y directions (e.g. x1-x2 = x3-x2, etc).
    2. it is saved in plain text format with a TXT, CSV, DAT or FTG extension.

    Then, you can use it as a grid file. For example, click Home | New Map | Contour. In the Open Grid dialog, select TXT Formatted Text Grid as the file format, select the file and click Open. You can specify the import options and click OK.

    Thanks,
    Kari

    0
    Comment actions Permalink
  • Avatar
    cmar

    I have Surfer 12.8 -> is this why it doesn't have a TXT Formatted Text Grid option?

    0
    Comment actions Permalink
  • Avatar
    Kari Dickenson

    Correct - this format was added in Surfer 13. You can use Surfer 14 for this task to either create maps from the data, or convert the data to a grid file for use in Surfer 12 (Grids | Edit | Convert).

    Alternatively, see our KB article on how to use matrix data in Surfer 12:

    I Have Data In A Matrix Form. How Can I Use This To Create A Map In Surfer?

    Thanks,
    Kari

    0
    Comment actions Permalink
  • Avatar
    Claire Haagenson

    Hi, I'm having a similar issue using a trial of Grapher 14. I have my data in a matrix in an excel file as follows.

         y1 y2 y3 y4 y5 y6

    x1 z1 z2 z3 z4 z5 z6

    x2 z7 z8 z9 z10 z11 z12

    x3 z13 z14 z15 z16 z17 z18

    I am trying to plot an XY contour data map.  However, when I create the plot, the software assigns the range of z values to the y axis and my intended y axis doesn't seem to appear anywhere on the graph.

    0
    Comment actions Permalink
  • Avatar
    Leslie McWhirter

    Hello Claire,

    Surfer and Grapher have different supported file formats. Grapher currently does not support text grids. I have added your vote for this to our suggestion file. Once this is available, you'll need to use the Contour grid map rather than the Contour data map, since the latter creates a grid from x,y,z columns, and then uses that grid for the map.

    Until this is implemented, you can follow these instructions to convert your matrix data to column data to use with a Contour data map: https://support.goldensoftware.com/hc/en-us/articles/360017830714-How-can-I-create-a-contour-surface-map-in-Grapher-from-matrix-data-.

    Thanks!
    Leslie McWhirter

    0
    Comment actions Permalink

Please sign in to leave a comment.