How do I locate data by coordinate using table formats such as comma separated?

By /

Last Updated: February 11, 2025

You can locate data by coordinate using table formats using mapping software. To map coordinate data, you can follow a simple process with any table containing longitude and latitude fields, whether it’s in an Excel file, CSV file, SQL Server database, MS Access, or other formats.

This article explains how to map coordinate data using Maptitude Desktop and Maptitude Online.

Maptitude Desktop

  1. Download and install a free trial of Maptitude mapping software, or use your own license of desktop Maptitude.
  2. Ensure your table or file has column headings. If missing, you can add them in Excel or another application. Alternatively, in Maptitude, open the file and use Dataview > Table > Modify to add column names.
  3. In Maptitude, go to Map > Add Table/Spreadsheet to a Map.
  4. Browse to your file, select the appropriate format (CSV, Excel, or database connection), and click Open.
  5. Choose your Longitude and Latitude fields when prompted.
  6. Choose to Locate the records in your file by coordinates.
  7. Follow the remaining prompts until you are finished. Maptitude geocodes your points based on the coordinate data and displays a map of the locations.

Maptitude Online

  1. Log into your Maptitude Online account or request a free trial of Maptitude Online.
  2. Click the Create Map tab.
  3. Choose My data/table/spreadsheet from the radio list.
  4. Drag an Excel or CSV file to the Drop file or click here to upload box, click the click here link and choose an Excel or CSV file that contains the data to be mapped, or manually longitude and latitude information in the spreadsheet and add any additional fields of data.
  5. If you uploaded an Excel file that contains more than one worksheet, choose the sheet that contains the data to be mapped.
  6. Click Next and verify the fields that Maptitude Online found in the file that can be used for mapping.
  7. On the Type of Map tab choose how to map your data. Choose Locate the records in your file by coordinates.
  8. Follow the remaining prompts until you are finished. Maptitude Online geocodes your points based on the coordinate data and displays a map of the locations.
Scroll to Top
Maptitude Support Chat
▼