When a data file is created in another program with dates and times in it, Surfer will only recognize the data as dates and times if the data is either:
- The data is in an Excel file format (XLS, XLSM or XLSX) and the cells are formatted as dates or times.
- The data is in TXT, CSV, DAT, ASCII, or another text format, and the data is in one of the standard U.S. Excel date/time formats, such as mm/dd/yy. If the format in the text file is not a U.S. Excel date/time standard format, the data will be imported into Surfer as text, and then you can’t use it as real data.
As long as the date/time data is formatted to fulfill one of the above requirements, you can use it to create grid files or create post maps. You can set the label format Type to Date/time and then select the desired Date/Time Format.
Surfer versions 11 and previous do not recognize dates and times as valid data. If you are using one of these versions, format the data as numeric data in Excel before using it in Surfer.
Updated November 6, 2018