I am using a GPS App on Android that export my location as a latitude and longitude values.

For each location it exporting a separate data set:

Latitude (LAT): 32.05796  
N 32°3'28.6578" 
Longitude (LONG): 34.83233  
E 34°49'56.39448"

It is quite easy to copy this data into a CSV file and then to upload it into QGIS.

However, it is time consuming especially when I have 15 or more locations to add.

I have tried some GPS apps and they all doing pretty much the same thing.

Is there some App or a method that enables to collect several locations in one table?

Once the table is saved as CSV it should not be a problem to import it as CSV into QGIS.

  • 1
    Why not use the Qfield app to digitize directly into layer?
    – Gabriel
    Nov 28, 2018 at 14:02
  • 1
    here maps you can export your collections to csv or gpx waypoints. play.google.com/store/apps/…
    – Mapperz
    Nov 28, 2018 at 14:03
  • My OS is windows Pro 10 Nov 28, 2018 at 14:24
  • 1
    I would come up with a nice bash 1-liner if that would help.
    – pLumo
    Nov 28, 2018 at 14:24
  • Is this Google apps enable to import the data as a CSV file? Nov 28, 2018 at 14:26

1 Answer 1


Bash solution:

Put all your data files in a subfolder named "data" and run this little script:

# print some header
printf "%s,%s\n" LAT LON;
# print the data
grep -Pho '(LAT|LONG)\): \K.*' data/* | paste -d, - -
} > output.csv # redirect output between brackets to csv file

In one line for copy-paste:

{ printf "%s,%s\n" LAT LON; grep -Pho '(LAT|LONG)\): \K.*' data/* | paste -d, - -; } > output.csv

You can run bash on Windows.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.