Hot answers tagged

73 votes
Accepted

Exporting attribute table to Excel from QGIS

QGIS v3.x Right click on the layer in the Table of Contents (aka. legend or layer tree) and open the Save As... dialog. Once there, click on the Format option list and choose MS Office Open XML ...
user avatar
29 votes

Exporting attribute table to Excel from QGIS

To get a csv file of the attribute table, rightclick on the layer in the legend, select Save As ..., and change the file format from shapefile to CSV. You might need to change the separator from ...
user avatar
  • 75k
18 votes
Accepted

Joining data from Excel to attribute table in QGIS without creating duplicates?

I would do the following things to make life easier: Before you do this, make a backup of your shapefile. In your shapefile, go to the layer properties / fields and turn on edit mode. select all ...
user avatar
  • 2,975
16 votes

Joining data from Excel to attribute table in QGIS without creating duplicates?

You will want to join the excel file to the shapefile. You will join them on a common attribute and the result will be a joined layer where each record hold the attributes of both the shapefile and ...
user avatar
  • 3,812
14 votes

Exporting attribute table to Excel from QGIS

In QGIS versions 3 and above, the easiest way to export an attribute table is to: Right-click the attribute layer in the layers menu Select Export and Save features as... At the top of the program ...
user avatar
  • 141
14 votes
Accepted

Add an Excel file with a list of coordinates to QGIS as a layer?

You can often make a WKT (Well Known Text) column in Excel without too much fiddling, which effectively creates a spatial definition for points, lines or polygons within a single field. What you want ...
user avatar
  • 14.4k
13 votes
Accepted

Adding excel table to QGIS print composer?

Save your excel file as CSV file go to Add Vector Layer in QGIS and navigate to your CSV file and load it In the print composer, go to Add attribute table, as you can see below: Select the Source ...
user avatar
  • 36.3k
12 votes

Exporting attribute table to Excel from QGIS

There's also the MMQGIS Plugin which, when downloaded and installed from the toolbar (Plugins > Manage and Install Plugins...), has the tool: MMQGIS > Import/Export > Attributes Export to CSV ...
user avatar
  • 72.3k
12 votes

How to export attribute table with start and end coordinates of lines to Excel?

Extracting coordinates of start/end vertices (not all line vertices) from lines is a nice use case for new functionality in QGIS v.2.8, namely, the function editor. This is the workflow: Load your ...
user avatar
11 votes

Joining data from Excel to attribute table in QGIS without creating duplicates?

Just to add another method, you can set up a Project macro which when loaded: Automatically joins your shapefile to your csv Updates the IP1 and IP2 fields Removes the joined fields leaving only the ...
user avatar
  • 72.3k
11 votes
Accepted

Exporting layers to different sheets of an Excel file

On QGIS 3.10.3 or above You can do that in this way: # Prepare options for layer1 options = QgsVectorFileWriter.SaveVectorOptions() options.driverName = "XLSX" options.fileEncoding = "...
user avatar
10 votes
Accepted

Excel XLSX data with coordinates displayed as points

drag-drop an Excel XLSX file onto the layer widget double click tool QGIS geoalgorithms\Vector creation tools\Point layer from Table, choose the new layer as Input layer and specify the columns ...
user avatar
  • 4,420
10 votes

Way to find minimum value from a group of values - QGIS?

You could use the Group Stats plugin from Plugins > Manage and Install Plugins. This calculates various data statistics for your attributes such as finding the minimum value in a group. I made an ...
user avatar
  • 72.3k
10 votes
Accepted

Descrambling scrambled coordinates?

No idea what happened with the first three lines but the other lines are coordinates in UTM zone 28N. data_lat is X, data_lon is Y. I noticed that simply plotting each pair as X and Y points looked ...
user avatar
  • 8,411
9 votes

Calculating grid convergence (True North to Grid North)

The formula for calculating grid convergence (sometimes called meridian convergence) for spherical UTM projections was given (very incorrectly until just now) at How to Calculate North? In case that ...
user avatar
  • 8,604
9 votes

Header row in Excel is not header row when imported into ArcMap?

I had the same problem (Arcmap would not import my csv file with headers, instead it would show Field1, Field2, Field3 etc). When I examined the file headers in Excel, I found...decimals numbers, ...
user avatar
  • 91
9 votes

Making a join permanent using QGIS 3.16 with a shapefile and Excel spreadsheet

The join is only permanent within the project you did the join in; basically the attributes are just linked and the link information is stored in the project file (.qgs or .qgz). If you want to ...
user avatar
  • 25.5k
8 votes

Joining data from Excel to attribute table in QGIS without creating duplicates?

My suggestion is to use open source LibreOffice / Open Office to edit your Excel file and make .dbf file. I prepared test workbook for you. Test workbook - link Open file in Libre Office / Open ...
user avatar
  • 942
8 votes

Adding a column to an attribute table leaves edit pencil icon grayed out in QGIS?

QGIS, or more specifically OGR, has two different drivers for XLS and XLSX (see http://www.gdal.org/ogr_formats.html) XLSX can be edited, XLS can not. Try converting your data to XLSX and you should ...
user avatar
  • 82.1k
8 votes
Accepted

Copy/Paste attribute table qgis without the wkt_geom column?

Yes. In Settings> Options> Data Sources: Copy features as: "Plain text, no geometry"
user avatar
8 votes
Accepted

Copying attribute table to Excel in ArcGIS Pro?

Kind of hard to know, but you need to use a shortcut, CTRL+SHIFT+C, which would Copy the selected records onto the clipboard.
user avatar
7 votes

Drawing lines between two points in QGIS

The quickest way to do this with a single line would be using the QuickWKT plugin; you can then right-click and Save As to any format you need. Let's say your two points are in UTM Zone 36S, and here ...
user avatar
  • 14.4k
7 votes

How would one format an Excel sheet so numeric fields are set to numeric field types when importing to ArcGIS 10.2?

If you use the Table to Table tool, which can import Excel files to geodatabase tables, you can manually set the data type of each field during the import process using the field map. Right-click the ...
user avatar
  • 12k
7 votes

Relating shapefile to excel table in ArcMap?

The help for ArcGIS is clear that you cannot do relates with Excel documents or any other document that does not support an ObjectID in the Fundamentals of ObjectID fields help. This help clearly ...
user avatar
7 votes

Dropping OID column with ArcPy Table To Excel?

Make Table View with ObjectID unchecked: Run Table To Excel with the table view as input
user avatar
  • 52.2k
7 votes

Configuring columns when adding CSV file to QGIS

Since your data is delimited by semicolons, you must select "Custom Delimiter" then "Semicolon".
user avatar
  • 2,224
7 votes
Accepted

Exporting into Excel file from PyQGIS?

If you are in QGIS environment you could make a QgsVectorLayer with your data and export that as xlsx: QgsVectorFileWriter.writeAsVectorFormat(layer, path, "utf-8", layer.crs(), 'xlsx')
user avatar
  • 136
6 votes

Creating shapefile from Excel file in QGIS?

You can save the csv layer as shapefile to edit the data. Therefore right click the added csv layer in the layer menue and select Save as.... Following dialog will open: Now you can save your csv ...
user avatar
  • 2,838
6 votes

How to populate my table with data in excel format?

Save your Excel as a comma-delimited file, then: COPY your_table FROM '/path/to/csv/file/data.csv' WITH DELIMITER ',' CSV HEADER; Another option would be ogr2ogr. Edit: after some more searching, ...
user avatar
6 votes

How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?

I believe you want this toolset downloadable from the arcgis.com gallery, compatible (supposedly) with 10.0 and above (written by teampython): Excel and CSV Conversion Tools Also see the below esri ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible