Author Topic: Import .dat file into Excel  (Read 139153 times)

admin

  • Anthony Tekatch
  • Administrator
  • Jr. Member
  • *****
  • Posts: 71
    • Unihedron
Import .dat file into Excel
« on: April 30, 2013, 12:31:25 am »
The .dat file generated by UDM and defined here can be imported into a Microsoft Excel spreadsheet for calculations and graphing purposes as follows:
  • Start excel
  • File Open
  • Select "All files"
  • Select your .dat file (previously recorded and saved).
  • Select "delimited" (as opposed to the default "fixed width")
  • Import starting at line 33
  • Next
  • Unselect "Tab"
  • Select "Semicolon", you should see bars separating the data fields now.
  • Next
  • Define each field. European users will have to select "Advanced", then change the "Decimal point" to "." and "Thousands separator" to ","
  • field 1,2 = date YMD
« Last Edit: March 30, 2014, 10:47:24 pm by admin »