General Category > Connected meters (SQM-LE/LU/LR/DL)

Import .dat file into Excel

(1/1)

admin:
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

Navigation

[0] Message Index