1. Get the CellLocation table ipened in SQLite (should already be done)

2. Go File>Export>Table as CSV

3. Select the 'CellLocation' table from the dropdown

4. Save the file as something (I suggest CellLocation.csv)

5. Open the .csv up in excel and delete all the columns except Timestamp, Latitude, Longitude(Arrange the data so that Timestap is in column A, lat in column B etc.) Then delete the headings so that the only data you have is a bunch of numbers.

6. Then save and close the file.

7.Go to:http://www.gpsvisualizer.com/map?form=googleearth

8. In the box that says 'Paste your data here' delete the word 'desc' so that the only text now is:name,latitude,longitude

9. Open your csv file back up but this time in a text edotor (Word or Notepad should do)

10. Copy and paste the data into the text box on GPS Visualiser (beneath the line that says: name,latitude,longitude)

11. Click Create KML and save the resulting file.

12. Open in Google Earth to view your data points. The numbers for each data points are actaully the time in seconds after 01.01.2001 00:00:00

13. That website has many other parameters that you can mess with if you know what your doing (eg. trackpoints will draw a nice line etc).

@Ben Sharif That works beautifully. I have played about with it and the results are very interesting. it seems to have recorded trips over the last year only when they are within the South East, all the rest is not shown. Also the location records seem to be rather inaccurate. When I travel I quite often go into a particular service station and it shows it spread over a huge area!

This was very helpful. I created another POC with Kettle (open source data integration) to read in the SQLite file:http://kettle.bleuel.com/2011/04/26/iphone-tracking-how-to-read-the-consolidateddb-with-kettle/

I've tried the formula for the timestamp in excell (2003 version) and I'm getting results like "3650540514" or "3659823825" tried formatiing the cell as any data format but never getting something close to a date.

I've also noticed in SQLite that sometimes over a hundred consequtive columns have the exact same timestamp, but different long and langtitude. Whats that about, anyone noticed something similar?

@Jens Blueul I followed the link you suggested and found that the name of the file on my computer is the same as that on yours. It is:-4096c9ec676f2847dc283405900e284a7c815836 Maybe it is related to the day the information was backed up. My file is dated 12/04/2011

@everyone!There's a windows application now that does all this for you. Finds the file, extracts the data and maps it.Check it out here:http://huseyint.com/iPhoneTrackerWin/DOWNLOAD LINKhttp://cl.ly/0F2K460D451O2q2P1C3u

This is a great article and I've tried following it, however, I'm struggling and want to be sure it's not due to the fact that I have iOS 8.4 running on my phone. Does anyone know if Apple has changed how/where the CellLocation table is stored since this article was written? I'm trying to track where my phone was on a specific day/time frame.

Truck Pulse is a white label trucking app solution for logistics businesses and startups of all sizes who want their own Uber for trucking app that connects shippers and nearby truck drivers at the push of a button.

Along with a user-friendly design, this freight management solution allows feature customizations according to the business requirements. The on-demand trucking app solution suite includes Android and iOS apps for shippers and truck drivers, plus a powerful web panel for transporters and admin.