Questions tagged [excel]

Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.

Filter by
Sorted by
Tagged with
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 ...
user avatar
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?
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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, "...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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&...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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, ...
user avatar
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....
user avatar
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/...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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.
user avatar
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/...
user avatar
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 ...
user avatar
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 ...
user avatar
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
user avatar
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.
user avatar
  • 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 ...
user avatar
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. ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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,...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 111

1
2 3 4 5
12