Leaderboard

First I used Excel to transform data to table. Data -> Text to columns. As I could not use space as delimiter (last column has spaces), I used fixed width so that all numbers went to separate fields. And then rewrote the header. As CSV, the data came out as follows (semicolon as delimiter): GID;Y;X;Z;text; 160501;1136981.309;427018.995;24.453;Tabtgået; 160502;1137117.536;426932.208;24.7;Spyd i jord m gul top; 160503;1137074.143;427167.529;25.276;Spyd i jord m gul top; 160504;1137270.694;427149.621;24.771;Spyd i jord m gul top; 160505;1137316.357;426982.35;24.863;Spyd i jord m gul top; 160506;1137372.847;427141.53;23.281;Spyd i jord m gul top; 160507;1137475.44;426979.949;22.596;Tabtgået; 160508;1137527.149;427215.072;21.179;Spyd i jord m gul top; 160509;1137611.641;427182.29;20.764;Spyd i jord m gul top; 160510;1137616.198;427041.391;20.413;Spyd i jord m gul top; 160511;1137740.069;427050.822;19.723;Spyd i jord m gul top; 160512;1137751.792;427132.87;19.216;Tabtgået; 161004;1137048.141;427149.171;25;Spyd i jord m gul top; 161003;1137126.893;427110.19;25.517;Tabtgået; 161002;1137182.808;427057.73;25.309;Tabtgået; 161001;1137220.373;427007.094;25.911;Spyd i jord m gul top; 170102;1137306.111;427120.132;24.574;Spyd i jord m gul top; 170103;1137301.109;427034.383;25.118;Spyd i jord m gul top; 170101;1137275.446;427044.6;25.784;Spyd i jord m gul top; 170104;1137393.761;427019.66;23.584;Spyd i jord m gul top; 170105;1137413.861;427022.837;23.365;Spyd i jord m gul top; 170106;1137419.946;427116.878;22.07;Spyd i jord m gul top; 170501;1137404.049;427054.017;21.139;Fast prisme i tunnel, prismekonstant;-17,5mm 170502;1137410.036;427080.694;21.107;Fast prisme i tunnel, prismekonstant;-17,5mm 170503;1137293.021;427063.412;20.908;Fast prisme i tunnel, prismekonstant;-17,5mm 170504;1137291.129;427086.338;20.879;Fast prisme i tunnel, prismekonstant;-17,5mm 170505;1137218.985;427024.099;20.888;Fast prisme i tunnel, prismekonstant;-17,5mm 170506;1137218.609;427019.445;20.795;Fast prisme i tunnel, prismekonstant;-17,5mm For ArcMap, I added the saved CSV (you could save it as XLSX and use it same way) file to data frame and under right click chose Display XY data. Arcmap detects X and Y automatically, just had to set Z to field Z. Under projection, click Edit and choose DKTM2 (Projected - National grids - Europe, search works too).

It seems to me that the answer is in your dataset. In the text file SRS: DKTM2_DVR90 That means Danish system with metric coordinates. Use this as reference: https://epsg.io/4098 When importing the coordinates, be sure to notice that they are not XYZ but YXZ (northings before eastings).