Questions tagged [excel]
Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.
608
questions
0
votes
0
answers
25
views
Data type on stand alone table imported from excel [closed]
I am trying to join a stand alone table from excel to a shapefile of a census tract. They both share the geoid data, but the census tract data type is text while the excel table data type is big ...
1
vote
0
answers
37
views
Creating Streams from endpoints and NHD Stream Layer using ArcGIS Pro with Spatial Analyst
I have a dataset for instream flow water rights that delineates the length of stream based on upstream and downstream endpoints and the miles of stream. I'm trying to create a GIS layer for this ...
- 11
2
votes
1
answer
99
views
Sorting coordinates as per polygon in QGIS
I have a list of our sales lead locations in Excel with their coordinates.
What I wish to do is that I need to sort those coordinates as per the condition if they lie within a certain polygon or not. ...
- 23
1
vote
1
answer
26
views
How to write AGOL data into an Excel sheet using FME
I am using the AGOL feature service reader to read in the data and then writing to an Excel file. In the Excel writer parameters I have set the template file and sheet and set the mode to "update&...
- 19
0
votes
0
answers
119
views
How to use an Excel file (.xlsx) in QGIS
So I have an Excel file where I want to use built in Excel features such as restrict data type in columns etc. but I want to use QGIS to display the data.
I know that I can change it to a CSV file ...
- 1,984
4
votes
1
answer
55
views
Importing several CSV files without losing leading zeros from OS NGR into QGIS
I have ten CSVs that I need to import, in order to turn them into geopackages/shapefiles so I can edit the attribute tables etc etc. The ten files have a combined total of about 15000 entries. Each ...
0
votes
0
answers
29
views
Inaccurate attribute values using joins attribute in QGIS
I have a shapefile data that represent the location (polygons) and a tabular data represent its detail information. I want to merge the tabular data to the shapefile. I use QGIS 3.22.12
Here are the ...
0
votes
1
answer
70
views
Converting excel integer date format to date using ArcGIS
Similar question as this post: Converting excel integer date format to datetime using QGIS, but for ArcGIS.
I have a field with integer values like 45118 which came from a column in Excel containing ...
- 135
0
votes
1
answer
164
views
Import JSON file as table in Excel and visualize polygon geometry using ArcGIS plugin for Excel
I have a quest where I have to visualize the polygons in my local disk in Excel using ArcGIS plugin. Based on what I understand, I can only import it as a JSON file from the get data panel, but the ...
0
votes
1
answer
45
views
Combine several attribute tables into a single Excel
Is it possible in QGIS to combine several attribute tables into a single Excel? Unfortunately, I cannot find a suitable function/command. Copying and pasting all attribute tables individually is too ...
- 1
0
votes
1
answer
60
views
Create an ArcPy script to open a pop up window with some exporting functionality just after running trace tool from utility networks runs successfully [closed]
I am new to ArcPy.
Suppose I ran the Trace Tool from utility network toolset using ArcGIS Pro successfully, and I need to immediately a pop up window comes up with the export functionality to export ...
-1
votes
1
answer
65
views
Generate Excel files from an attribute table using a certain field
I have got a table with many fields, where one of them is the main one, as they are sectors of a region in Spain (Comunidad Autónoma, in Spanish). I know I can export that table to Excel from ArcGIS ...
0
votes
1
answer
50
views
Transcribing KML without metadata
I use Google Earth KMZs for fiber optic network designs and I need to transfer info over to Excel for ordering purposes. I'm using the Placemark and Path features in GE to correspond to items we order,...
- 1
2
votes
0
answers
152
views
Exporting large attribute table from QGIS to Excel
I am working on a project with an attribute table of approx. 5,564,098 rows. I've tried exporting it to Excel using the "save as" CSV or XLS but the data keeps getting cut off. I would ...
- 21
0
votes
0
answers
42
views
QGIS - Working in the attribut formular with Widgets
I want to transform my attribut formular for biotopes to add automatically their value depending on two former columns.
I have an excel table like this:
Code
rating1
rating 2
value
A
dry
species-...
- 121
0
votes
0
answers
21
views
Using ArcPy's GetParametersAsText in Python script tool to convert a Excel file into a projected featureclass [duplicate]
I am creating a Python script tool in ArcGIS to help automate some GIS tasks. The script takes an Excel file (that has Lat/Long fields with values) as the first input parameter. The second parameter ...
- 81
0
votes
0
answers
272
views
Utilize ArcGIS Python script tool parameters to convert Excel file into a projected featureclass
I am creating a Python script tool in ArcMap to help automate some GIS tasks. The script takes an Excel file( that has Lat/Long fields with values) as the first input parameter. The second parameter ...
- 81
1
vote
1
answer
230
views
FME: Import an Excel table as user parameter list
I have a list of possible errors in an Excel table and I am importing it as a Reader. I run more than 100 controls on my data and I generate a txt file with the data that don't pass the tests and what ...
2
votes
1
answer
373
views
Live synchronisation Excel to QGIS
I am looking for a solution to synchronize a vector layer to an Excel-file in both directions. So if I add a geometry within the vector layer, it shall also be written in the Excel-file and if I ...
- 317
3
votes
2
answers
144
views
Include the processing tool "exporttospreadsheet" into my plugin
I made a Plugin containing features for a specific workflow.
As the last function I wanted to add the qgis processing tool "ExportToSpreadsheet" (Layertool) into my plugin. It's a native ...
- 91
2
votes
1
answer
183
views
Problem with data input. CSV with polygon coordinates to polygons in QGIS
I have a .CSV file with information about polygons (which are squares), represented by the coordinates of the four points that shape a square (4 pairs of long/lat coordinates)
All are in one column, ...
- 31
2
votes
2
answers
5k
views
ModuleNotFoundError: No module named 'xlsxwriter'
I created a plugin that export some data from the layer to some excell.
The problem that I'm facing, as the title says, is that Module xlsxwriter is not found.
To save some answers, yes I installed ...
- 161
0
votes
1
answer
122
views
Exporting FileGeodatabase Subtypes to Excel
I'm working with a large file-geodatabase(100 layers) and need to create an excel spreadsheet listing all the subtypes with values and labels extracted. Is there a way to do with this task with out of ...
- 287
0
votes
0
answers
111
views
QGIS save DAT,MAP,ID,TAB, Excel file in an existing geodatabase
I am using QGIS 3.10.3. I need to add some files (DAT,TAB,MAP,ID and Excel) into an existing geodatabase. As I am new to QGIS, how can I add those files into a geodatabase.
- 191
2
votes
1
answer
220
views
Exporting selected attributes to Excel from specific layer using PyQGIS
I have created some code to select a specific layer in the Layers Panel. Now I want to export the selected features to an Excel document. Is there a way to do this?
Code so far:
#Select layer to ...
0
votes
1
answer
111
views
Using Excel table to create new attribute values
I have an Excel table with energy values per building age range and per building type. I want to read add a new feature in my point layer with corresponding energy values.
How can I read the Excel ...
2
votes
2
answers
97
views
QGIS 3.22.11: How can I attach different species to one polygon in a polygon layer
I have a polygon-layer with several polygons, and I have an excel-table with many detected species in some of these polygons. I want to attach all the species that belong to polygon 1 to polygon 1, ...
- 463
1
vote
1
answer
202
views
Adding multiple points using Excel data in QGIS
How can I add more that one point to a specific location (defined by lat and long coordinates) using an Excel file?
My table looks like this:
City name
Latitude
Latitude
A1
A2
A3
New York
40.785591
-...
0
votes
1
answer
121
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
387
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,347
3
votes
4
answers
590
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 ...
- 33
-1
votes
1
answer
234
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
2
answers
120
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
649
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
36
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 ...
- 1
0
votes
1
answer
41
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 ...
- 1
3
votes
1
answer
1k
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
514
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
3
votes
1
answer
452
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 ...
- 4,005
0
votes
0
answers
103
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 ...
- 163
2
votes
2
answers
113
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
162
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
39
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
1
vote
1
answer
45
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
265
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
217
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 ...
- 343
3
votes
2
answers
126
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 ...
- 229
3
votes
1
answer
179
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
124
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
131
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&...