Importing GPS data (collected through 'geopoint', 'geotrace' and 'geoshape') from CSV into QGIS

1. What is the problem? Be very detailed.
We collect GPS data using 'geopoint', 'geotrace' and 'geoshape' in ODK.
We use ONA website to store our data.
We download surveys in CSV format, and would then like to import GPS data into QGIS. This is time consuming and laborious. Is there a quick way of doing this?

2. What app or server are you using and on what device and operating system? Include version numbers.
QGIS: 3.4.3

3. What you have you tried to fix the problem?
We have tried copying and pasting the GPS values manually from CSV into QGIS.

4. What steps can we take to reproduce the problem?
Collect GPS data using 'geopoint', 'geotrace' and 'geoshape' in ODK.
Upload data onto ONA.
Download CSV file from ONA.
Try and transfer GPS data from CSV into QGIS.

5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.
Happy to discuss, or answer any further specific questions. Thank you.

There are QGIS plugins such as QRealTime that can facilitate this but I don't know of any for Ona. Ona is a separate, compatible server and you can find their support here.

Hi @davidbaines,
you should also take a look at this showcase so QGIS will be able to read the wkt column from within your csv.

Hello Mathieubossaert,
Thank you for your interest and support. This is very much appreciated. We will integrate your proposed code into our 'test' survey form.
Thank you again, and very best wishes,