Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
90 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 ...
0
votes
0answers
30 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 ...
0
votes
0answers
13 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
1answer
33 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
1answer
28 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 ...
0
votes
0answers
45 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 ...
3
votes
2answers
49 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 ...
3
votes
1answer
45 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 ...
0
votes
0answers
47 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
1answer
97 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
0answers
18 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
1answer
40 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 ...
0
votes
1answer
43 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
1answer
55 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
1answer
98 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 ...
-1
votes
1answer
52 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
0answers
24 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
1answer
75 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
3answers
109 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
1answer
65 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
1answer
42 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/...
1
vote
0answers
19 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
0answers
105 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 ...
1
vote
1answer
81 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 ...
5
votes
1answer
324 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
0answers
19 views

Joining Excel with hyperlinks from Excel to ArcGIS Pro or ArcMap

I was trying join a Excel spreadsheet with hyperlinks to the ArcMap and ArcGIS Pro based on the same field. The hyperlink text went through the join, however, the actual hyperlink did not go through.
0
votes
1answer
38 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
1answer
95 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
0answers
60 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
1answer
34 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 ...
0
votes
0answers
28 views

Importing points within a series of non-geolocated pdf maps and Excel data

I have a series of maps that have been drawn on by hand (points and areas) that have been given to me as PDFs, along with a series of interview PDFs explaining what those points and areas are (there ...
3
votes
0answers
38 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
0answers
21 views

Reading geometry that starts with "0xB508000..." and may be WKB

Someone has given me an Excel file that seems to have been exported from ArcGIS. All columns are fine, except for the geom field. Every row in that field starts with 0xB508000... and some number of ...
0
votes
1answer
68 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.
0
votes
0answers
54 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 ...
0
votes
0answers
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. ...
0
votes
0answers
145 views

Excel Sync Plugin in QGIS

I am trying to sync excel file with shapefile, I tried excel sync plugin but couldn't implement successfully. Could anyone tell how to use this plugin to sync shapefile with excel file.
0
votes
0answers
32 views

Mapping points from Excel sheet with listed addresses using ArcGIS Pro

After I add the Excel sheet into ArcGIS Pro, how do I go about placing each address onto the map? I may want to start off mapping the data just in California. This is from the National Register of ...
6
votes
2answers
119 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 ...
1
vote
0answers
62 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 ...
1
vote
0answers
473 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 ...
0
votes
1answer
77 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 ...
1
vote
0answers
104 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 ...
0
votes
0answers
53 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 ...
3
votes
0answers
79 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,...
0
votes
3answers
117 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 ...
1
vote
0answers
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 ...
1
vote
0answers
108 views

AGOL "Update Data" from Excel import numeric columns with some NULL rows?

I need to append some new features into an ArcGIS Online hosted feature layer. The data has been supplied to me in an Excel file (including X/Y columns). I was intending to import it as-is using the ...
1
vote
2answers
80 views

Connecting column from Excel table with attribute table in QGIS

Is it possible to connect an Excel table or column from an Excel table with an attribute table in QGIS?
0
votes
1answer
196 views

Survey123 not exporting Headers/Labels/Text

I have been having this issue all day and I have tried every work around I can think of. I am creating a form for technicians to use in the field to avoid using a field notebook. For this site, we ...

1
2 3 4 5
12