Jump to content

loc2exl


sakis

Recommended Posts

Hi to all

Is there a way to convert the .loc file to Windows Excel .exl file?

 

Thanks in advance

sakis

 

A .loc file is a txt file with keywords - I have written VBA code in Excel to read gpx files (similar to loc) and arrange the data in columns. Another way would be to open it with another program (like Mapsend for Explorist) and save it in a more useable format.

 

Explain a bit more what you want to do with the data and we might be able to help more.

Link to comment

Hi to all

Is there a way to convert the .loc file to Windows Excel .exl file?

 

Thanks in advance

sakis

 

A .loc file is a txt file with keywords - I have written VBA code in Excel to read gpx files (similar to loc) and arrange the data in columns. Another way would be to open it with another program (like Mapsend for Explorist) and save it in a more useable format.

 

Explain a bit more what you want to do with the data and we might be able to help more.

 

I use MapInfo software to create maps and data for maps.If i can convert the .loc file or the .gpx file to .exl i can load them as an additional data to my maps.The goal is to put the cordinations in to columns

sakis

Link to comment

I have sent an Excel file to the location below. If it does not open email me. Open the file and click on the CommandButton 'Collect7All' - it will prompt you for a gpx file and then import that file into the spreadsheet.

 

http://mysite.mweb.co.za/residents/lombard...PocketQuery.zip

 

This spreadsheet was developed to read pocket queries of geocaches and split them into groups of <200, which is the limit for Explorist 500s. I have not changed it at all, so it might be a bit rough and ready (or not work for you).

Link to comment

I have sent an Excel file to the location below. If it does not open email me. Open the file and click on the CommandButton 'Collect7All' - it will prompt you for a gpx file and then import that file into the spreadsheet.

 

http://mysite.mweb.co.za/residents/lombard...PocketQuery.zip

 

This spreadsheet was developed to read pocket queries of geocaches and split them into groups of <200, which is the limit for Explorist 500s. I have not changed it at all, so it might be a bit rough and ready (or not work for you).

Thank you

let me try it and i will inform you for the result

sakis

Link to comment

I use MapInfo software to create maps and data for maps.If i can convert the .loc file or the .gpx file to .exl i can load them as an additional data to my maps.The goal is to put the cordinations in to columns

sakis

Sakis, I have used GPSBabel to convert the GPX file to .csv (Comma Separated Values). Excel can open CSV files. The coordinates are changed into decimal degree format during the conversion to CSV. I then bring the CSV into ArcMap and have the software place points based on the coordinates in the CSV file. You could probably use the same procedure for MapInfo.
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...