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
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 ...

1
2 3 4 5
11