how to make kml to map info
TRANSCRIPT
![Page 1: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/1.jpg)
STEP 1
OPEN KML to EXCEL (*.xls)
STEP2
Open list KML
![Page 2: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/2.jpg)
STEP3
IN COLUMN B FILTER WHAT DO YOU WANT TO MAKE DATA
STEP4
COLUMN F MUST BE FILTERED BY POINT
![Page 3: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/3.jpg)
STEP5
SELECT AND COPY IN NEW FILE, IF FILE MORE THAN ONE, JUST COMBINE IN ONE FILE (AFTER FILTER PER FILE)
STEP6
![Page 4: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/4.jpg)
DELETE COLUMN A-H and J-R, DON’T DELETE COLUMN I and S. BECAUSE THE DATA IN I and S
STEP7
![Page 5: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/5.jpg)
SUMMARY STEP1 – STEP6 WE JUST NEED DATA WHAT WE WANTS AND COORDINAT COLUMN, THAT WE NEEDS
STEP 8
PLEASE SEPARATE LONGITUDE and LATITUDE
STEP9
BREAK THE LINE AND COMMAS “IMPORTANT, MUST SAVE IN 2003 EXCEL FORMAT”
![Page 6: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/6.jpg)
STEP10
DELETE DATA EXCEPT LONGITUDE AND LATITUDE
![Page 7: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/7.jpg)
STEP11
OPEN MAP INFO AND OPEN FILE BY EXCEL FILE (*.xls)
![Page 8: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/8.jpg)
STEP12
MAKING ROW BY SELECT SHEET (IMORTANT, PLEASE CLOSED EXCEL FILE BEFORE OPENED BY MAP INFO)
STEP13
PLEASE FILL BASED ON EXCEL COLUMN AND CHOOSE FLOAT TYPE
![Page 9: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/9.jpg)
STEP14
GO TO TABLE AND CREATE POINTS
STEP15
CHANGE SYMBOL STYLE YA MANG
![Page 10: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/10.jpg)
STEP16
PROJECTION, CHOOSE WGS 84
STEP17
CLOSE FILE IN MAP INFO
![Page 11: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/11.jpg)
STEP18
CTRL+O OPEN TAB FILE
STEP19
DONE
![Page 12: How to Make Kml to Map Info](https://reader031.vdocuments.us/reader031/viewer/2022012309/5571f90849795991698ea3f0/html5/thumbnails/12.jpg)
READ THIS:
THIS METHODE HOW TO MAKE RxLev, IF YOU WANT TO MAKE OTHERS, Qual,RSCP ALL THINGS IS SAME. JUST FILTER DATA WHAT YOU NEDD AND LONGITUDE-LATITUDE.
THANKS,
-SQ-