Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
-1 votes
0 answers
33 views

Autofit columns of an Excel doc with Python

I'm trying to autofit columns of an Excel doc I create with ArcGIS Pro 2.9. It seems totally possible with ExcelWriter, which doesn't seem to exist in ArcGIS Pro 2.9. I don't have any code about ...
  • 39
0 votes
1 answer
30 views

Importing labels at specific X,Y points using ArcGIS Pro

I am trying to load an excel file into ArcGIS Pro that has 3 columns x,y,label like this X Y Code 396051.35 -616690.04 Ag01 606336.43 -616823.57 Ag02 I need to output a shapefile ...
1 vote
2 answers
30 views

Extract field details for all layers in a geodatabase

I have inherited a file geodatabase containing a number of feature classes (points, lines and polygons), where many fields are common. For example all feature classes contain the following fields, and ...
  • 1,299
3 votes
4 answers
228 views

Importing from Excel/CSV format to QGIS

I created a grid and used it's squares and it has 4 values in attribute table (each square has left, top, bottom, and right values). Every square is a different object. I try to export file from ...
-1 votes
1 answer
62 views

QGIS does not read all .csv Excel columns [closed]

When I import my data from Excel into QGIS, the GPS points are found. However, not all columns that are present in the Excel are shown in the Attribute Table. At times, they have completely ...
0 votes
0 answers
16 views

Map elements (specifically objects) disappear from ArcMap layout view

I am using ArcMap 10.8.1 and am running into an issue where I insert a Word document or Excel sheet as an object into my layout view and when I reopen the map document, those objects are gone. When ...
  • 1
0 votes
2 answers
34 views

QGIS doesn't show datapoints of .csv file

I am not yet familiar with QGIS and I am trying to add an Excel file with GPS points and data (add layer > add delimited text layer). The Excel shows up as a layer, but the points do not show on ...
0 votes
1 answer
189 views

Converting .xls to .shp

I'm very much a GIS novice but have been maintained an interactive tool on arcGIS for several years and am only now experiencing a problem with it. We are collect and update data on an Excel ...
  • 1
0 votes
0 answers
26 views

Joining an Excel tabel to single polygons of a feature layer

I am trying to associate the contents of an external Excel spreadsheet with individual polygons of a feature class. I have a layer that has hundreds of polygons. I also have an Excel spreadsheet that ...
0 votes
1 answer
35 views

Can ArcMap use Excel equations in the attribute tables?

I am very new to ArcMap and am learning as I go. I am trying to have one Column be the current date. In Excel I used "=Today()" and that clearly works fine but it does not seem to be ...
0 votes
0 answers
24 views

Calling Excel 2016 out of QGIS 3.4 using action of point layer?

I work with QGIS 3.4 LTR (Madeira) in a network environment of an office in Saxony. This year in early spring our network changed the operating system from Windows 7 to Windows 10 (Windows 10.0.19044....
3 votes
1 answer
238 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
190 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
32 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
209 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,521
0 votes
0 answers
29 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
40 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 ...
0 votes
0 answers
34 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 ...
2 votes
2 answers
92 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
118 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
35 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
16 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
41 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
113 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
144 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
73 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
97 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
66 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 vote
1 answer
109 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&...
1 vote
1 answer
260 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 ...
  • 179
0 votes
1 answer
224 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
107 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 ...
3 votes
1 answer
157 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
91 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
32 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 ...
0 votes
1 answer
409 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 ...
0 votes
3 answers
130 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
114 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
68 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,521
1 vote
0 answers
22 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 ...
0 votes
0 answers
236 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 ...
  • 185
1 vote
1 answer
292 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 ...
  • 7,053
6 votes
1 answer
1k 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
57 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
373 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
69 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 ...
0 votes
1 answer
84 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
56 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
0 votes
1 answer
233 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,742
0 votes
0 answers
75 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
2 3 4 5
12