How do I read Excel data formatted as a date into Surfer?

Surfer can read date/time data in an Excel file as long as it is formatted as either Date or Time (not as Text or General). Open the file in Excel, select the cells and make sure they are formatted as Date or Time, save the file and Surfer will recognize the date or time formatting.

Surfer 11 and previous versions did not have the ability to read different date formats. In these cases, the numeric value corresponding to the date (Julian date) must be used in Excel. If the data in Excel is currently formatted as a date or time, change the format to Number to save the date/time as the Julian date.

Please consult your Excel documentation for more information about functions in Excel.


Updated November 6, 2018

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.