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 ...
- 33.8k
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 33.8k
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 ...
- 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 = "...
- 33.8k
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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, ...
- 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 ...
- 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 ...
- 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 ...
- 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"
- 15.3k
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.
- 29.4k
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 ...
- 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 ...
- 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 ...
- 8,455
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
- 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".
- 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')
- 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 ...
- 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, ...
- 2,789
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 ...
- 1,673
Only top scored, non community-wiki answers of a minimum length are eligible