Would you like to...

Print this page

Email this page

Post a comment

User Opinions

14% 85%

---

How would you rate this answer?

Helpful

Not helpful

Thank you for rating this answer.

You can create a variety of map types from data in an Excel file. How you do it depends on what type of data you have and the type of map you want to create:

1. If your data file has XYZ data and you would like to create a contour map, or other map type, use the Grid | Data command first to create a grid file. Then use Map | Contour Map | New Contour Map (or whichever map type you want to create), select the grid file and click Open.

2. If the Excel file contains point data (each XY coordinate pair in the data file is an individual point), I suggest you use the Map | Post Map | New Post Map or New Classed Post Map to create a post map. You can label the point with another column in the data file if you wish.

3. If the Excel file contains the XY coordinates of polylines or polygons and you want to load the data as a base map, I suggest you convert the Excel file to BLN format. The BLN file format is a simple ASCII data file, consisting of a one line header followed by point data.

Open the XLS file in the Surfer worksheet, include a one-line header at the top with the number of vertices in the polyline/polygon. If the points define a polygon, be sure the first and last set of coordinates are exactly the same. You can have multiple polylines/polygons defined in one file, as long as each has its own header line. Example:

5      <-- start of polygon
0,0
1,0
1,1
0,1
0,0
2      <-- start of polyline
0,0
1,1

Go to File | Save As and save as a BLN file. You can then go to Map | Base Map and load the BLN file as a base map.