# Gps data

**URL:** <https://forum.getodk.org/t/gps-data/4687>\
**Category:** Support\
**Created:** [August 27, 2015, 1:56pm UTC](https://forum.getodk.org/t/gps-data/4687 "2015-08-27T13:56:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Louis\_Omoya](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/louis_omoya/32/9574_2.png) [@Louis\_Omoya](https://forum.getodk.org/u/Louis_Omoya)\
**Post date:** [August 27, 2015, 1:56pm UTC](https://forum.getodk.org/t/gps-data/4687/1 "2015-08-27T13:56:22Z")

</div>

Hi?  
It's my first time colecting gps data. I have run a trial and exported the  
collected data in MSExcel

The following gps variables were produced;

gps:0.3079183416468655 32.56167512924479 1201.573912104059 6.0

\_gps\_latitude: 0.307918341646865  
\_gps\_longitude: 32.5616751292447  
\_gps\_altitude: 1201.57391210405  
\_gps\_precision: 6

Do I need to do something to make excel record the coordinates in the  
'right' format? The current number format is General

How do I get the gps values into a gps application/software?

Thank you for sharing thoughts on ODK. I have found it extremely helpful  
in learning ODK Collect.

---

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [August 27, 2015, 3:23pm UTC](https://forum.getodk.org/t/gps-data/4687/2 "2015-08-27T15:23:05Z")

</div>

Hi Louis,

That is the correct format. GPS is latitude, longitude, altitude and  
precision. How you move that into your GPS software depends on that  
software. Most allow you to import a CSV/Excel and let you select the  
lat/lon columns.

Yaw

> **···**
>
> -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.
> 
> On Thu, Aug 27, 2015 at 9:56 AM, Louis Omoya [louisomoya@gmail.com](mailto:louisomoya@gmail.com) wrote:
> 
> > Hi?  
> > It's my first time colecting gps data. I have run a trial and exported the  
> > collected data in MSExcel
> > 
> > The following gps variables were produced;
> > 
> > gps:0.3079183416468655 32.56167512924479 1201.573912104059 6.0
> > 
> > \_gps\_latitude: 0.307918341646865  
> > \_gps\_longitude: 32.5616751292447  
> > \_gps\_altitude: 1201.57391210405  
> > \_gps\_precision: 6
> > 
> > Do I need to do something to make excel record the coordinates in the  
> > 'right' format? The current number format is General
> > 
> > How do I get the gps values into a gps application/software?
> > 
> > Thank you for sharing thoughts on ODK. I have found it extremely helpful in  
> > learning ODK Collect.