Questions tagged [excel]
Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.
577
questions
3
votes
1
answer
111
views
Using QGIS field calculator to create an 'fid' column according to a value from another column
I have a shapefile with 1,800 rows. I need to edit this file as follow:
Row_name is from 1 to 45
Col is from 1 to 39
fid should be from 1 to 1800 in order (This is the new field I need to create).
I ...
4
votes
2
answers
137
views
Export from layer to Excel in QGIS with alias fields
How can I export a layer to Excel format in QGIS environment and have alias of the fields in the header of the Excel file instead of the original field names?
- 121
0
votes
0
answers
24
views
Save entity as Excel Table using QGIS Modeler
I am using QGIS 3.16.6.
I would like to save different attributes of my process in one Excel file and not in three different files as it is the case in the attached Model_2 screenshot (red box).
I ...
- 1
3
votes
1
answer
154
views
QGIS print layout - export legend items to Excel
I have the well-built legend in the QGIS print composer, as my project includes more than 20 layers. Because the legend in front layout doesn't match our legend patterns produced in Excel I am ...
- 3,546
0
votes
0
answers
19
views
ArcGIS Online Export to Excel Data Type Conversion
I have a hosted feature layer with a point feature composed of several String fields, some other types, and a relate table that points to required material for construction at that point feature. One ...
0
votes
0
answers
24
views
Using Spreadsheet layers plugin in QGIS 3.18.3
I am trying to import into QGIS 3.18.3, by using plugin "Spreadsheets Layer", Excel file with multi spreadsheets one by one. It manages to import the file but there is nothing displayed ...
- 493
0
votes
0
answers
22
views
Extracting average value at point using ArcGIS Pro
I have a dataset of over 500 points that represent the location of a number of site boundaries and a Tif file displaying the wind speed data over the study area.
Is it possible using ArcGIS Pro to ...
- 125
2
votes
2
answers
89
views
Using QGIS expressions to edit columns automatically according to a repeating pattern, similar to Excel dropdown/autofill
I have a geoJSON file with 4,500 rows. I need to edit this file as follow:
if plot_num starts with 2 -> rep = 2
first 11 rows of line = 1
second 11 rows of line = 2
I have been updating the ...
3
votes
1
answer
98
views
How do I complete an existing attribute table with .CSV or .XLSX
I have an existing vector layer (points) I was working on some time ago. The layer represents boreholes in the area of my interest (over 250 points).
Some time ago we got access to a number of ...
- 53
0
votes
0
answers
32
views
Joining SHP with XLS sheet using Excel
I am trying to join SHP by field CONCATENATE with my XLS sheet.
SHP attributes looks like this:
ID
NAME
CONCATENATE
122
765
122765
345/1
765
345/1765
987/3
345
987/3345
Because of those slashes ...
- 15
0
votes
0
answers
15
views
Geocode/Add values from Excel to ArcMap based on 4 fields
I have an Excel file which contains 4 key fields: "FROM" , "TO", "STREET" and "# of Symbols". Here "FROM" refers to a starting street position, "...
1
vote
1
answer
36
views
Moving Excel/CAD data into ArcMap [closed]
I am new to GIS.
I was wondering how to go about taking geometry data (from AutoCAD) and attribute data (from Excel) and combining them into a single layer or shapefile or feature class. The AutoCAD ...
2
votes
1
answer
54
views
Exporting points inside specific polygon to Excel spreadsheet using QGIS [duplicate]
I have two vector layers, one with points, and the other with catchment boundaries. This is showing where the points are in relation to catchment areas.
I want to be able to export a Excel file that ...
- 23
0
votes
0
answers
122
views
Using x,y coordinates and a value gathered in an Excel file, set these values in a raster with Python and GDAL
I have an Excel file with X, Y coordinates and one Altitude value for each coordinate. I have already gathered these values in a Python dict. Altitude, Lat, Long (see image)
Also, I have a raster ...
- 301
3
votes
2
answers
57
views
What is the right sequence of actions when creating new polygon layer with given attribute table structure?
I want to create a new vector layer with polygons in it. I've an Excel file with the columns that have to be the attributes in the layer's attribute table. How do I achieve this?
I'm kinda lost, I ...
- 209
3
votes
1
answer
62
views
Merging GPS data with data that does not have lat long information based on 'time' in spreadsheet before creating map
I have GPS data that represents the movement of an animal underwater (so it is really the GPS position of a boat that followed the animal).
I also have a spreadsheet of recorded behaviors from the ...
- 35
0
votes
0
answers
57
views
Joining Excel table to shapefile is too slow
I am trying to join the information I have in some Excel files to their corresponding layers in QGIS 3.16. Disclosure: I am pretty new to QGIS.
My workflow is the following:
I have an Excel file of ...
- 1
1
vote
1
answer
103
views
Why points were not imported from Excel file into QGIS? [closed]
I have a data of multiple x and y coordinates in UTM format saved in an Excel CSV file format then added it as a delimited text layer in QGIS. I set the geometry definition as "point coordinates&...
0
votes
0
answers
29
views
GWSDAT with R Studio does not read Sample Date from imported Excel sheet properly
When I import an excel sheet, GWSDAT will not recognize the data within the SampleDate column. All cells in that column appear empty within the GWSDAT R Studio window:
For context, I have a Python ...
1
vote
1
answer
120
views
Joining ArcMap to Excel table but join fields not showing up in join dialog
I have datasets in a File GDB Feature Class and an Excel table. I want to join them on a field named JOINFIELD. I have the same field name in the FC & in the top line of a column in the Excel ...
- 159
0
votes
1
answer
88
views
How to convert large DMS coordinates into an acceptable format in GIS
I am trying to add points to a GIS map from a dataset. However, the lat/long coordinates are in the form of six digit DMS degrees. All I would need to do is separate the coordinates into a Degree, ...
0
votes
1
answer
78
views
Calculate ArcGIS field from Excel sheet in ArcPy
I want to calculate a field in shapefile from a field in Excel sheet using an ArcPy script. How can I write the last line in the below script?
import arcpy
import xlrd
arcpy.env.overwriteOutput = True
...
- 67
3
votes
1
answer
143
views
Downloading xlrd utilities and collection package for PyQGIS
import xlrd
from xlutils.copy import copy
from collections import defaultdict
Error shown as:
ModuleNotFoundError: No module named 'xlutils'
Tried to download in Plugin--->Manage and Install ...
- 59
-1
votes
1
answer
75
views
How to solve error when querying the .shp file to Excel?
I am making a Python code with geopandas and xlwings, what I do is colsulse .shp files from Excel, it works fine but when it reaches the last line of the code wb.save (in_file) where it should be ...
1
vote
0
answers
31
views
Combining data in pivot table using ArcMap
I have created a pivot table by using summary statistics in ArcMap. I have summarized three columns that I would like to sort by the same row data.
Is there any way to combine the values in these ...
- 23
0
votes
1
answer
221
views
Importing Excel data to polygon Layer using ArcGIS Pro
I am using ArcGIS Pro.
I have a polygon layer (65 features) saved. My colleague has made an Excel sheet with a number of different columns with different attributes on each feature.
Is there any way ...
- 125
0
votes
3
answers
119
views
Query the fields of an attribute table of a .shp file (ArcMap) from an .xlsx file with Python [closed]
What I want to do is query the fields of a .shp file from an Excel .xlsx file, that is, avoid the repetitive and manual process of copying the attribute table from ArcMap to the working .xlsx file,
...
0
votes
1
answer
78
views
Converting Coordinates in Excel
I am creating a spreadsheet of data to enter into QGIS. My grid references are currently formatted like this: 339614, 133960 - they are the coordinates in the brackets on this site https://www....
0
votes
1
answer
48
views
Ordnance Survey coordinates mismatch when converting from Lat/Lon
I have incorporated the batch Lat/Lon to OSGB option in Excel. The source file was on the main Ordnance Survey website:
https://www.ordnancesurvey.co.uk/business-government/tools-support/os-net/...
- 3,546
1
vote
0
answers
20
views
Updating reports using ArcMap
Is there a way to connect an excel table to ArcMap software or a geodatabase so that it updates when data in ArcMap is updated?
Or perhaps there is another software besides excel that could be used to ...
- 23
0
votes
0
answers
183
views
Live data on QGIS Cloud?
I have a line layer that is rulebased labeled to show green segments and red segments based on 'status' attribute.
Currently, I download data from an excel sheet on sharepoint as a csv and then import ...
- 175
1
vote
1
answer
195
views
Forcing FME to read a date column in Excel as a text-encoded attribute
I am reading an Excel spreadsheet which has a column containing date values using FME.
The problem is that all date value are encoded as normal text in Excel, except a few cells which are encoded as ...
- 6,698
6
votes
1
answer
754
views
Making a join permanent using QGIS 3.16 with a shapefile and Excel spreadsheet
I have a point layer representing sites where data was collected. The data was edited and stored in an Excel spreadsheet (CSV). I needed the data to be joined to the sample sites. I followed the steps ...
0
votes
1
answer
45
views
Having more than 10 letter on header while exporting SHP to Excel using ModelBuilder ArcGIS
When I export a shapefile to Excel from ArcGIS using ModelBuilder the header maximum length is 10. I would like to know how can I have more.
0
votes
1
answer
252
views
Using ArcGIS Online feature service attribute table dynamically in Excel
I've been trying to find a solution for a while now that will allow me to view a feature service in Excel without having to export. I'm aware of the ESRI Office add-in, however, this is only to upload/...
0
votes
0
answers
67
views
Speeding up my Python code for reading from Excel, performing geospatial analysis and writing to Excel files
I have written a Python snippet that reads lat and long stored in an Excel file. Converts them to a point which is then used to perform multiple geospatial analysis including buffer, intersection, and ...
- 39
0
votes
1
answer
64
views
Access MDB connection file result does not have an object ID in ArcGIS 10.8
I have made an MDB Access Connection by linking the Excel file with the Access one, but when I looked at the result in ArcMap the feature class table does not have an Object ID on it. I tried to ...
3
votes
0
answers
49
views
Create link for open specific object in the project map in QGIS
I am working to link Excel and QGIS. Is it pssible to create a link that can be put in Excel and when cklicked open the map/project zoomed to the specific object?
Greets
- 121
0
votes
1
answer
159
views
Converting excel integer date format to datetime using QGIS
How to convert Microsoft Excel date format to datetime format using QGIS?
In example: 43089 in MS Excel is 2017-12-20.
- 5,642
0
votes
0
answers
60
views
How to transform X and Y coordinate on a delimited text imported layer
I added excel sheets into my project using the deliminted tab and used the X and Y columns that are in a mercator coordinate system, I am using QGIS 3.14. These layers are not showing up in my project ...
- 1
0
votes
0
answers
23
views
Adding data information into the layers
As total newbie of QGIS, I am slowly progressing into using properly QGIS but I lack of knowledge of the software.
I am missing the knowledge to edit .shp files in the goal of adding or changing data.
...
- 1
7
votes
2
answers
176
views
Exporting layers to different sheets of an Excel file
I have two memory layers that I would like to write their attribute tables to the same Excel file but in different sheets. So far, I've managed to write the attribute tables to separate files using ...
- 193
1
vote
0
answers
79
views
Combining Microsoft Excel and QGIS in an elegant way
I've been working with an Microsoft Excel Spreadsheet where the rows are different investments and the columns are different variables/criteria (a column could for example be the year of the ...
- 49
1
vote
0
answers
660
views
Survey123 Connect geolocate from a text field using online survey
From the web survey, is it possible to put a point on the map from typing in your address? As it stands, when I type my address a drop down from the search bar in the map appears. But, the map doesn't ...
- 798
0
votes
1
answer
126
views
QGIS: relation to Excel exported files (updates)
Layers exported from QGIS as Excel format are the topic here.
I see when I edit this files in Excel(exported from QGIS) are simultaneously edited in equivalent file (non-spatial table) which was ...
- 493
1
vote
0
answers
126
views
Create PostgreSQL ODBC Excel table
I want to allow a non-GIS user edit a CSV file which is hosted on QGIS Cloud on a PostGIS database. My method is to load the table from the QGIS Cloud database into Excel via ODBC.
Here are my steps ...
- 2,089
0
votes
0
answers
64
views
How to solve Error 000840 from arcpy.JoinField_management?
As part of a larger Python script, I am attempting for my last step to join an Excel file to a spatial layer. I was able to perform this step just fine in ArcGIS Pro Model Builder, but when I attempt ...
- 1
3
votes
0
answers
132
views
Copy/pasting from QGIS to Excel
I want to copy and paste (or export) data from a query (or attribute table) into excel.
I've tried copying and pasting direct from a query results (in DB Manager) or loaded the query result as a layer,...
- 846
0
votes
3
answers
163
views
Changing Excel point coordinates in different coordinate system to points in ArcGIS Desktop
I have coordinates in a format e.g. 22°42'39.065”E, 49°4'59.864”N. I tried to add the points using "XY Table to Point" but when I add my Excel file as input, it doesn't recognize the fields ...
- 3
1
vote
0
answers
26
views
Adding spreadsheet information to KML
I have a KML from Indy Neighborhoods ArcGIS. I have the results of a factor analysis based on neighborhood traits from savi.org. From this, I did a clustering. I would like to combine the contents of ...
- 111