How to convert a gpslog.txt file to a .csv to use in Pix4D

Owned by Conor Ferguson
Last updated: Oct 01, 2024 by Karson Kall
2 min read
csv txt 1080P.mp4

Converting WISPR 24MP .TXT File to .CVS with two (2) columns of horizontal accuracy and one (1) of vertical accuracy - Step-by-step

  1. Open Excel

  1. Change the file extension that excel is looking for to “*.* so that the existing .txt file will show

  1. Open “gpslog_000x.txt” located in the folder with the photos taken by the drone

  1. On the Text Import Wizard, open as “Delimited”, start at row “1” and the file origin should be 437: OEM United States. Then click Next

  1. Select “comma” as the delimiter and click Next

  1. For the column data format, allow General and click Finish

  1. The text will import to cover column A through L

  1. Highlight the letters with the values repeating such as 1.7248E+12, a single digit, and 0.x. The next two columns to keep are the horizontal and vertical accuracy columns which are 0.01 and 0.013 respectively

  1. Right click and select Delete

10.  Right click on the horizontal accuracy column which will begin with “0.01” and go to copy

11.  Right click over the top of the same column and go to “Insert Copied Cells”

12.  Now go to File, then Save As, select the location you want to save the .CSV your creating, name the file and click the dropdown box below the name of the file and select “CSV (Comma delimited) *.csv”

13.  Click Save