New answers tagged

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 ...
user avatar
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 ...
user avatar
  • 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((&...
user avatar
  • 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(...
user avatar
  • 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....
user avatar
  • 13.2k

Top 50 recent answers are included