I’ll try to describe it here but I’m on the phone and don’t have access to screenshots of the files. This is what works for the Featherweight data that I have on my phone from previous flights. I’m not sure if it’ll change going forward with the new way flights are recorded.
1. Open the .csv file in excel from the day of your flight that you have “shared” to yourself.
2. If you have multiple flights, cut and paste them into separate .csv files (or sheets). They are all listed on the same sheet so you just have to scroll down through the columns. It’s helpful to look at the Vertical Velocity and Alt columns to identify those rows.
3. I delete every row above the start of the flight and the ones below the landing. Basically take one above where the velocity increases and one below where decent stops.
4. I delete every column except for Time, Lat, Lon and Alt.
5. Add “(ft)” after Alt in the column label (otherwise it’ll be in meters after the converting step).
6. Filter down through the data and find all the erroneous Lat/Lon/Alt data points and delete that row. If you miss any, you see them on the google earth plot and you’ll just have to go back and fix it in this file.
7. Save the file as a .csv. If you have all of your flights on the same workbook but in separate sheets, you’ll be told you can’t save it that way and it’ll default to saving each individual sheet that you’re on.
8. Go to here:
https://www.gpsvisualizer.com/map_input?form=googleearth
9. Choose your file on the right.
10. Make sure the options are set as the photo below.
11. Hit “create kml”.
12. Once finished, you can just click on the link and it’ll open it in Google Earth (assuming you’ve downloaded Google Earth Pro).
13. In there you can change the color of the path, label them, etc. I actually uploaded over 15 flights and they are all labeled and organized.
Note: It appears you can save all of the individual flights in separate sheets on the same workbook and then save that as an .xlsx. From there you can use that at the link provided and it’ll just open all the flights from the workbook, as opposed to converting each flight separately.
If you have any questions let me know. I’ll be back at my desktop on Monday and can probably explain that better with screenshots of the actual data. Hope that helps.
View attachment 398222