Questions tagged [excel]
Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.
525
questions
3
votes
1answer
33 views
Force ArcMap to release unused Excel file
This is not a scripting issue or even a lock file issue.
I have an Excel file with one sheet.
I drag that one sheet into the ToC of ArcMap.
I look at the table.
I remove the sheet from the project.
...
1
vote
0answers
17 views
List of features and layers based on edit date in ArcMap
I regularly update our GIS data using ArcMap to improve its accuracy, and due to our schema this involves editing multiple features across multiple layers.
Is there a way to extract a list of the ...
1
vote
2answers
61 views
Extracting point coordinates from QGIS into Excel using Python [closed]
I was formerly working on ArcGIS but now I'm working on QGIS 2.14.7 and Python 3.8 so I'm a bit confused with the QGIS script.
I have to extract coordinate of point layer (CRS:Lambert 93 and WGS84) ...
4
votes
0answers
55 views
Filtering in QGIS similar to dropdown in Excel
I have a large amount of point data that has so far been managed in an Excel list. In the future, these should be shown in QGIS.
To convince colleagues of this, I am looking for a way to make ...
1
vote
1answer
30 views
What address locator to use for geocoding addresses in Excel?
I've been struggling to geocode the following addresses from an Excel table both in ArcMap and ArcPro:
As you can imagine, I'm trying to geocode the addresses in the "StreetAddress" field.
...
0
votes
0answers
10 views
Gap Minder data in ArcGIS Pro
I am trying to use data from GapMinder. I have downloaded the Excel spreadsheet data for CO2 emissions and for global GDP. I have uploaded the file to my folder connection in ArcGIS Pro, and dragged ...
1
vote
1answer
56 views
How to automate flooded area calculation and make report using PyQgis?
I have 3 shapefiles with me. They are a flooded layer, District layer and Village layer. To estimate flooding village wise, I have to do intersecting the features and get the layer. Then I calculate ...
0
votes
2answers
19 views
Need to assemble a matrix from several ASCII GRD files
I am totally new to GIS software.
I would like to consolidate 205 ASCII GRDs files (the file format of Golden Software's "Surfer") into a single big GRD file or just a big matrix of (about 2400 rows ...
1
vote
1answer
22 views
My dataset lists state and county FIPS codes separately. How should I combine?
I can't do a simple "concatenate" because the codes don't have leading zeroes. Are there any available APIs that I can use to geocode this data given the format? Or do I have to manipulate them so ...
0
votes
1answer
39 views
Qgis 3.12 export to EXCEL table
I am using QGIS 3.12. I want to export my attribute table to an exciting EXCEL table but I want to arrange the columns in a different order and also to select which columns to export and which not. Is ...
2
votes
1answer
47 views
Google API Geocoding in MS Excel for free
Good Morning,
I am seeking the solution enabling me to do any address geocoding in Excel with using Google Maps Geocode Api.
Basically, the task is possible via Google Sheets, what has been ...
0
votes
1answer
25 views
Copy data attribute into QGIS layer (not external link)
I need to copy data from an external file .xls to a layer.
I have to share a project with only shape file (no .xls).
Now the layer has normal data attribute with join
I do not understand that ...
0
votes
0answers
7 views
Importing Line Shapefiles in Excel 3D Maps?
I have managed to use the 3D Maps feature from Excel to visualise points at certain Lat Long coordinates from a data range.
I have successfully managed to import complexe polygons via shape files.
...
2
votes
2answers
39 views
Adding to attribute tables
I have a question about adding data to attribute tables. I uploaded an Excel file into ArcMap (File -> Add data -> Add XY data). I chose the table from Excel that had the orientation data's latitude, ...
2
votes
1answer
23 views
Statistical method to quantify the accuracy of point clusters
I have coordinates of about 13 points from different pictures in UTM. Per point I can have 2, 3, 4 or 5 coordinates of these points from 2, 3, 4 or 5 pictures. I would like to quantify the quality of ...
1
vote
0answers
49 views
Converting QGIS expression into Excel function
In QGIS I use this expression to build a "ID" from fields:
rpad(concat("abt", coalesce("u_abt",'X'),"beeinh"),5,'0') || '-Z01'
I need to translate this expression into a Excel or Calc function. How ...
2
votes
0answers
31 views
Column headers ignored when importing .xlsx file to postgres via QGIS DB Manager
I'm importing Excel (.xlsx) files to postgres using the QGIS DB Manager "Import Layer/File..." tool. I've already successfully uploaded very similar Excel files without issue, but for one file in ...
1
vote
1answer
20 views
How to export ArcMap model parameters to an Excel file?
I have a model where the user inserts different model parameters like "Name", "Elevation", "Threshold A", "Threshold B" and so on. Based on this, features get selected, saved to .xls files where they ...
1
vote
1answer
90 views
Import xls / xlsx / ods: field names are not in first row (just QGIS!)
I need to import a xls / xlsx / ods into QGIS. But while the first row (field names) of my XLSX in LibreOffice shows up on the first place as it should, QGIS shows the first row on place 452! As you ...
0
votes
0answers
25 views
Table not aligning with layer objects
I am new to GIS.
I am using Mapinfo V17.0.2
I am creating a cemetery plot. I have created many rows of polygons to shape the desired areas for burials.
My table looks a little like this;
ID | Lot | ...
1
vote
1answer
70 views
Polygons dissapear when upload as CSV
I'm working with QGIS 3.8 and I'm facing an error that I don't know how to fix.
I have download shapefile of all the countries in the world. When I display it on QGIS it has no problem at all:
I ...
0
votes
0answers
68 views
ArcGIS Pro Microsoft Access Database Engine driver not found even though its installed
I'm simply trying to add an excel file via "Add Data" to a map but receive the following error, "Required Microsoft driver is not installed". I went ahead and followed the directions via this link
...
2
votes
1answer
51 views
Export virtual fields in attribute table to Excel using QGIS
I am using QGIS.
I am trying to export my attribute table to Excel but I want the virtual fields also to be exported with their function. For example I have a field that sums up two other fields and ...
3
votes
2answers
46 views
Exporting selection to Excel file using ArcMap
I selected a list of facilities that intersect a polygon using ArcMap, and I want to export them to Excel.
Is there a way to do this without having to export the selection to a shapefile first?
0
votes
1answer
65 views
Plotting points using a list of lat & long coordinates
I have been given a list of latitude and longitude coordinates in a .csv file and asked to plot them on a map. There are multiple other columns of data about each point included in the excel file.
I'...
0
votes
1answer
49 views
Display XY coordinates (with different lengths) in ArcGIS does not work
I have a list of Excel lat long coordinates in a spreadsheet that I want to import as points in ArcMap by displaying the XY Data.
lat lon
5235746 486124
5236799 487447
5238042 489453
...
0
votes
0answers
58 views
Export a very large attribute table (1,5 M rows) into Excel spreadsheet QGIS
I have a very large shapefile containing rainfall data for South Africa. Each point is a single rainfall that lasted for 1 hour. I have 1,5 million points. For further analysis, I need to export it ...
0
votes
1answer
31 views
Summarizing individual data in table using ArcGIS Pro
I am attempting to summarize a a bunch of individual rows in a table I added into ArcGIS Pro, and I'm wondering if there is any type of tool or work flow I could use to do so?
This is kind of a ...
0
votes
0answers
40 views
Converting string fields to double using ArcGIS Pro
I have an Excel table converted to GIS type table. And there is few columns (text string), which I need to make double in order to join it with other table. There's blank fields, but there's nothing I ...
0
votes
1answer
33 views
Attribute table empty on a layer filled with data
I have inserted some data from an .xls file and marked it on a map in ArcMap on a layer named "Kafichi"
However when I right click on the layer and click on "Open Attribute Table" it gives me an ...
1
vote
1answer
52 views
Using raster file and Excel data for analysis QGIS
I'm using the population density raster from SEDAC (person/square km), I've clipped it to my area of interest (Vietnam) as shown in the picture below:
In addition to this, I have a vector layer of ...
2
votes
3answers
81 views
Importing Excel of multiple sheets into QGIS
I have an excel document of multiple separate sheets.
I can import them one at a time by saving the individual sheets as CSV’s but is there away to bring the entire document into QGIS?
The ...
0
votes
0answers
49 views
Connect coordinates only according to specifications in an Excel list
I have an Excel list with coordinates of shops and their names. I want to connect certain coordinates with the help of a second list.
The second list contains in the first row and column the names of ...
-1
votes
2answers
82 views
Excel XY to (Multi) Polygons
I'm struggling with visualizing a Excel dataset. I have a Excel data table containing a colum with XY coordinates of (multi)polygons, see the screenshot below. Now, I know that it is possible to ...
0
votes
0answers
36 views
Scatterplotting of LST and NDVI
I have created two Raster files (LST and NDVI) I want to determine the slope and intercept of the dry edges and wet edges of the scatter plots of the two datasets to calculate soil moisture, but I don'...
0
votes
0answers
12 views
Symbolizing layer with graduated colors by a field in Excel File
I have a field in Excel file called percentage, I want the governorates colored by the percentage value, so the more value is the more red become darker in the governorate.
So how can I do it in ...
0
votes
0answers
41 views
Can't display XY data in MXD on ArcGIS Desktop- onEnable error
When using Display XY data function on imported excel into MXD I get this error:
and if I click on "ok" then I get this message:
and the MXD get stuck and I must shut down the ArcGIS program. I know ...
1
vote
1answer
79 views
Excel to Table Conversion on multiple Excel files in folder using ArcPy gives ERROR 000814
I am trying to convert all of xls files (including single sheet) a folder into dbf tables in a gdb.
Here is my code:
import arcpy, os, xlrd
arcpy.env.overwriteOutput = True
arcpy.env.workspace = "C:...
1
vote
2answers
84 views
Mapping RBG color to coordinate possible?
I work with geologists who are trying to figure out how to use Qgis to batch apply colour values to coordinates so that we can visually see differences or patterns.
From the attached photo of soil ...
1
vote
2answers
76 views
Converting Excel files into geodatabase with ArcPy?
I have several Excel files that contain several sheets. I need to convert these files into one table in gdb. I wrote script that convert the whole sheet in separate table. How can I export a range (f....
1
vote
1answer
56 views
Visualizing lines in QGIS
I have installed QGIS and I would like to upload a .xls-file (or Access database) with 2 GPS points (starting point and ending point), a road name and some distances from the starting point, for ...
1
vote
1answer
235 views
GeoJSON file generation based on MS Excel
I am wondering how to CLEARLY generate the JSON file from the data based in Excel file.
I know some ways to do it, although as a result I have got sth like this:
{"type":"FeatureCollection","...
2
votes
1answer
106 views
Add column in QGIS
Is it possible to add a column in the attribute table in QGIS that is a concatenation of two other columns? For example I have a column "Genus" and a column "Species" and I would like to create a ...
1
vote
1answer
28 views
Create Query either using Select by Attributes or Python [closed]
I am working on something for my job, where I have a list of water/sewer service customers. Some customers have one service or the other, while others have both which is stored as two separate entries....
0
votes
1answer
45 views
Export Table to Excel works in ModelBuilder but not in MXD?
I have created model that take user input from a picklist and then outputs the selected data into an Excel File. When I run the model inside of ModelBuilder it outputs an Excel file that is exactly as ...
2
votes
0answers
87 views
QField hyperlinks in Android
I am using QField for some mobile GIS on Android and would like to have a hyperlink in the attribute table that opens a file stored locally. If not in QField directly then in excel would work. None of ...
0
votes
0answers
21 views
Selecting street segments (polylines) based on intersections with others and adding value to its field from Excel table?
I have a shapefile of city streets polylines and an excel sheet with similar data. I need to select a street segment based on the two segments it intersects. Then I add the value from the "ID" field ...
0
votes
1answer
254 views
Imported Excel Spreadsheet Creates Null Values
I've imported an Excel spreadsheet into ArcMap 10.5 and one of the columns entirely populates with NULL values. That column is just "reference numbers" so its just numbers from 1-180 in increasing ...
1
vote
1answer
87 views
Exporting RGB values from raster to file that can be processed in Excel using ArcGIS Desktop?
I have a 3 band raster file with RGB values (the Black Marble night time imagery from NASA). I want to get these values out and into excel so that I can plot them and hopefully see some sort of ...
0
votes
0answers
47 views
MakeTableView of Excel spreadsheet tab gives ERROR 000732?
I have a very simple model built using Modelbuilder that takes a tab of an Excel spreadsheet and converts it using Make Table view. This works fine in ModelBuilder. I then export the model to Python ...
