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.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 = "...
- 36.8k
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, ...
- 111
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 ...
- 35.2k
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"
- 16.7k
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.
- 30k
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 ...
- 84.4k
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 ...
- 22.6k
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
- 76.3k
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,324
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')
- 206
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 ...
- 28.1k
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 ...
- 22.6k
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 .
- 1,507
6
votes
Accepted
Decimals are in wrong place in latitude and longitude in Excel
Use a formula to divide by 100.
- 67.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(...
- 30.6k
6
votes
Accepted
ModuleNotFoundError: No module named 'xlsxwriter'
Well after some search and not being a "dummy", I found that we need to install through OsGeo4W shell.
So to simplify:
1 - Open OsGeoW shell with Admin permission
2 - pip install <...
- 303
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 ...
- 77.8k
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' ...
- 77.8k
5
votes
Excel XLSX data with coordinates displayed as points
Use the "Add spreadsheet layer" tool, which can be installed with these steps:
Plugins > Manage and Install Plugins...
Search or look for "Spreadsheet Layers", then click "Install plugin"
After a ...
- 42.2k
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 ...
- 33.7k
5
votes
Accepted
Attribute joins - string and text fields
Are you trying to join a .CSV file to your attribute table? Because a CSV file doesn't retain any excel formatting information. Either way, it sounds like ArcGIS is deciding that your 'string' field ...
- 587
5
votes
Accepted
Reading Excel file using PyQGIS
Following your example what you want to do is to iterate over all FEATURES of the layer, not over the layer object itself. That's why your Code fails.
Given this very simple Excel sheet:
Make a ...
- 4,678
5
votes
Accepted
ESRI File Geodatabase-Import Table without Geometry
It is generally a bad idea to attempt to create a FeatureClass that has empty geometry. You may get errors because the GDB is attempting to validate that spatial data.
Your best bet is to simply ...
- 13.3k
5
votes
Accepted
Summing up the area on a polygon by a certain attribute result
Using QGIS 2.18.7, In the Processing Toolbox you need but to search "Statistics by categories" and you fill find a tool that calculates vector table tools.
I have created a teamporary shapefile for ...
- 684
5
votes
Accepted
Use Milliseconds on Time Manager
From your description I could not find anything wrong, so please allow me to post an example, which is working at millisecond intervals at my end.
1) My dummy dataset:
2) Time manager panel. I set ...
- 31.1k
5
votes
Converting Lat Long CSV file to meters using ArcGIS Desktop?
I successfully converted the coordinates in your CSV after downloading it from your link using only ArcMap. (If you're using ArcGIS Pro, it should also work there, but the steps may be a little ...
- 8,446
5
votes
Accepted
Exporting selection to Excel file using ArcMap
Use Table To Excel:
Converts a table to a Microsoft Excel file.
Or click one of the grey small boxes to the left in the attribute table - Copy - then paste into excel:
- 76.3k
Only top scored, non community-wiki answers of a minimum length are eligible