How to Import .csv data in (x,y,-z) format in GM v18
Hi all
I am a complete newbie with Global Mapper and constantly getting an error of "No data could be loaded from the following file". The .csv has one column with everything in, separated by "," for example
Each .csv has 50,000 rows but just loading one is proving impossible. I have been looking around on tutorials and removing the -from the z, putting each attribute into it's own column.
Now I'm doing a test because the .csv originally was saved down from an .xlsx. Textpad shows that "speech marks" are put around the data "351527.38,5909808.13,-12.57". Would GM throw a wobbly if it has these in? Does anyone have any other suggestions?
Cheers,
Wallen
I am a complete newbie with Global Mapper and constantly getting an error of "No data could be loaded from the following file". The .csv has one column with everything in, separated by "," for example
351527.38,5909808.13,-12.57 |
Each .csv has 50,000 rows but just loading one is proving impossible. I have been looking around on tutorials and removing the -from the z, putting each attribute into it's own column.
Now I'm doing a test because the .csv originally was saved down from an .xlsx. Textpad shows that "speech marks" are put around the data "351527.38,5909808.13,-12.57". Would GM throw a wobbly if it has these in? Does anyone have any other suggestions?
Cheers,
Wallen
Answers
-
Wallen,
Instead of saving your XLSX file to a CSV format, create a blank text file in a plain text editor (TextPad is perfect), then copy the content from one sheet of your spreadsheet and paste it into the text file. (you can use ctrl-A to select all columns and rows, or you can click on the cell at the top left where the row and column labels meet, or you can select only the rows and columns you like) Save your text file.
Open your text file with Global Mapper. If your file contains only points, make that selection. If your points form a line, use the lines and points selection. The other default settings should work, at least for a first pass. On the second dialog, ensure that you select the UTM projection with the appropriate zone.
I usually have many columns of data in addition to easting, northing, and elevation. A spreadsheet is very useful to rearrange the columns as needed, then cut-and-paste into a text file that Global Mapper imports without problems.
-
Hi Mykle
Thank you very much for your reply and for running through the process. It all works now, feel a bit silly for not going down the Textpad route in the first place!
Thanks again, have a good one.
Wallen
Categories
- 12.6K All Categories
- 5.5K Features Discussion
- 337 Downloading Imagery
- 1.3K Elevation Data
- 379 Georeferencing Imagery Discussion
- 620 GM Script Language
- 52 User Scripts
- 113 GPS Features
- 405 Projection Questions
- 815 Raster Data
- 1.3K Vector Data
- 6.5K Support
- 171 Announcement and News
- 897 Bug Report
- 558 SDK
- 1.2K Suggestion Box
- 3.7K Technical Support
- 559 Other Discussion
- 129 GIS Data Sources
- 27 Global Mapper Showcase
- 231 How I use Global Mapper
- 106 Global Mapper Forum Website