New answers tagged excel
0
votes
Google API Geocoding in MS Excel for free
The request you are pasting in (https://maps.googleapis.com/maps/api/**directions**/xml) is for Directions API, but you have only enabled Geocoding API for your project. That's why you're getting the ...
1
vote
Importing from Excel/CSV format to QGIS
Besides the numerous solutions proposed, you could use the Geometry Generator to create the polygons.
If your CSV-file has the following form:
xmin,ymin,xmax,ymax
-0.5,-0.5,0.5,0.5
-2,-1,1,2
...
you ...
- 3,763
2
votes
Importing from Excel/CSV format to QGIS
In MSExcel fill in columns A to H the corner coordinates, in column I the id that identifies the polygon, create in column J field geom,
calculate geom with the following formula:
="POLYGON((&...
- 1,018
4
votes
Importing from Excel/CSV format to QGIS
You can create a virtual layer from the information in the excel file.
Add the excel or csv file to the map, and MakePolygon using the four corner coordinates:
select MakePolygon(
GeomFromText(...
- 53.8k
3
votes
Accepted
Importing from Excel/CSV format to QGIS
Either convert your coordinates to WellKnownText format, or change the layout of your table so each corner of each square has its own row, including a square ID, a point ID and its X and Y coordinates....
- 13.2k
Top 50 recent answers are included