Skip to main content
20 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 ...
RutgerH's user avatar
  • 3,285
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 ...
ed.hank's user avatar
  • 3,862
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 ...
CW Dillon's 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 ...
Simbamangu's user avatar
  • 14.8k
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 ...
ahmadhanb's user avatar
  • 40.9k
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 ...
Joseph's user avatar
  • 75.8k
12 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 = "...
Germán Carrillo's user avatar
11 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, ...
Marissa's user avatar
  • 111
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 ...
Joseph's user avatar
  • 75.8k
11 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 ...
MrXsquared's user avatar
  • 34.4k
9 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"
HeikkiVesanto's user avatar
9 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.
Alex Tereshenkov's user avatar
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 ...
Artec's user avatar
  • 982
8 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 ...
Richard Fairhurst's user avatar
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 ...
underdark's user avatar
  • 84.2k
8 votes
Accepted

QGIS print layout - export legend items to Excel

Interesting question. I couldn't resist having a play around with this. I have hacked together a Python script (cobbled from different sources) which should take care of this for you. Note: you will ...
Ben W's user avatar
  • 21.5k
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
BERA's user avatar
  • 72.9k
7 votes

Configuring columns when adding CSV file to QGIS

Since your data is delimited by semicolons, you must select "Custom Delimiter" then "Semicolon".
Kingfisher's user avatar
  • 2,314
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')
Ah4b's user avatar
  • 196
7 votes

Export from layer to Excel in QGIS with alias fields

You could use the "refactor fields" algorithm from the processing toolbox to create fields with the alias as name and fill them using the original field name as source. This lets you ...
Matthias Kuhn's user avatar
7 votes
Accepted

Exporting selected attributes to Excel from specific layer using PyQGIS

No need to programmatically select your layer in the layers panel- you can access the layer you want to export simply by its name. To export the layer to a .xlsx, you can call the 'Export to ...
Ben W's user avatar
  • 21.5k
6 votes

Exporting attribute table with 100,000+ features into Excel file using ArcGIS Explorer?

If exporting to excel you would have to be within the limitations of the spreadsheet, which is available on Microsoft help page Worksheet size 1,048,576 rows by 16,384 columns In addition, you ...
whyzar's user avatar
  • 12.1k
6 votes
Accepted

Is *.xls MS Excel default format in ArcMap?

ArcMap can load lots of dataformats. The direct load of xls/xlsx is pretty nice as you have all the named sections beside the tables and don´t need to transform anything. There are some guidelines (...
Matte's user avatar
  • 6,245
6 votes
Accepted

How do I stop FME from using the first row as the column name when reading XLS?

You will need to play with the Parameters of the XLS reader you can idicate that on the Field Names Row settings , if you set this attribute to 0 i suppose you will get what you looking for .
Jorge Vidinha's user avatar
6 votes
Accepted

Decimals are in wrong place in latitude and longitude in Excel

Use a formula to divide by 100.
user2856's user avatar
  • 65.9k
6 votes
Accepted

Using QGIS field calculator to create an 'fid' column according to a value from another column

Hacky solution using the field calculator: array_find( array_agg( expression := to_int(substr("Row name", 5))*10*maximum("Col")+"Col", order_by := to_int(...
geozelot's user avatar
  • 30.3k
6 votes
Accepted

Include the processing tool "exporttospreadsheet" into my plugin

You need to use self.iface.layerTreeView().selectedLayers(). Define ExportToSpreadsheet as follows and connect an action to the method. def ExportToSpreadsheet(self): """Export all ...
Kadir Şahbaz's user avatar
6 votes

Importing several CSV files without losing leading zeros from OS NGR into QGIS

Import the CSVs to QGIS without adding those two columns. Then use the following expressions in Field Calculator for two new fields named Northing and Easting, respectively. Set 'output field type' ...
Kadir Şahbaz's user avatar
5 votes

Geocoding addresses to coordinates in QGIS

For QGIS versions QGIS 3.20 and higher Starting from QGIS 3.20 it is possible to geocode addresses to coordinates by means of the native tool "Batch Nominatim geocoder", can be found under ...
Taras's user avatar
  • 32.9k

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