Questions tagged [excel]

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

88 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
61 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 ...
3
votes
0answers
526 views

Automatically update and reclassify project layer from Excel data

I have a project in Qgis that gets its data from a locally stored excel file (linked). Is there a way to automatically update the linked data? What is happening now is that when I change some rows in ...
3
votes
0answers
395 views

How to refresh or update a vrt layer in Qgis?

When using the QGIS SpreadSheet Layers plugin, how do I update the SQLite query without closing and reopening QGIS? I cannot see a "watch file" equivalent. The plugin creates and uses a *.vrt file ...
2
votes
0answers
51 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,...
2
votes
0answers
41 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 ...
2
votes
0answers
101 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 ...
2
votes
0answers
62 views

Write Excel From ArcGIS Pro, Async

I am having trouble writing to an excel file from ArcGIS Pro Sdk add-in that I created, I have a basic understanding of multithread, I am using task but the main thread does not wait for the excel to ...
2
votes
2answers
73 views

Opening different XLS spreadsheets as table with ArcPy?

I am trying to write a Python script that uses a xls file with different spreadsheets as input to build features and domains in a geodatabase. This is the data in Sheet1: and this the data in ...
2
votes
0answers
32 views

Copying Table of Contents from QGIS into Excel?

Is there a way to copy and paste the contents of the Table of Contents in QGIS into an Excel spreadsheet? For example, I have many layers (groups of vector shapefiles which are underneath various '...
2
votes
1answer
208 views

Table join to KML file

I want to add a classification to photos which are in an excel spreadsheet within a KML file. Need a way to combine/join fields that are in an Excel spreadsheet to a KML file.
2
votes
0answers
89 views

How do I work with Excel and QGIS so that Excel formulas are intact when data is edited in QGIS?

I work a lot with Excel spreadsheets that are linked across multiple tabs and files. In this case, I have a sheet with coordinates and a whole lot of other data fields which needs to be imported into ...
2
votes
0answers
182 views

Create geometry in PostGIS with OGR and Python

I have issue with PostGIS, Excel spreadsheets and Python OGR bindings. I need to read many Excel spreadsheets (with same schema), parse latitude and longitude fields, create points, re-project them ...
2
votes
0answers
189 views

pyQGIS: Which attribute change signal should I listen to?

I want to receive a signal when changes have been made to a layer, regardless of the type of editing (add features, remove features, change attributes). When I receive this signal I export the layer's ...
2
votes
0answers
68 views

QGIS imports two excel double vectors: one as double, the other as QString! Why?

I work in QGIS 2.8.3 and import an excel file (xlsx version 2013) containing 5 vectors: string, string, double, int, double. All vectors have a heading. However, QGIS tells me that the last double ...
2
votes
0answers
80 views

Extract Mean Raster Value from multiple raster files into Excel

I have a series of non-orthorectified raster files containing NDVI information. I would like to extract the mean value from each raster so I can see a summary of each raster image name and the ...
2
votes
0answers
141 views

Is there any map API that allows you to pull an address range from a polygon?

I've seen a lot of answers saying you can't draw polygons and get the exact addresses of all of the places contained; thankfully, I don't need so much info. I'm looking for a way to get a vague ...
2
votes
0answers
2k views

Can I put a button that automatically inputs GPS coordinates into a google form? (or other spreadsheet populator)

I am currently creating a Google Form and part of the questionnaire requires the user's current GPS location. Is it possible for a button to be able to do this and automatically populate the field? Or ...
2
votes
0answers
180 views

Maintaining same number of digits in Excel file when converting to table in ArcGIS for Desktop?

I have two fields containing lat and long values which are precise up to 8 digits. When I use the excel to table tool, Arc removes the last two digits in both fields leaving me with lat and long ...
2
votes
0answers
439 views

Attributes in Excel and FME

I have a excel and a shapefile.I want to check whether the attributes present in the excel matches the one in the shapefile using FME
2
votes
0answers
829 views

Shapefile From Excel Sheet Crash When Selected Spatialy or By Attributes

Using ArcGIS 10.2, I am receiving an Excel sheet, on a daily basis, which contains 105 columns(Fields) and includes has X and Y values. For whatever reason (which I cannot understand) all data types ...
1
vote
0answers
20 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 ...
1
vote
0answers
25 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
25 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
0answers
19 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
0answers
50 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 ...
1
vote
1answer
150 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 ...
1
vote
1answer
289 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","...
1
vote
0answers
64 views

QGIS 3.6 - Updating layers from changing excel spreadsheet

I am building/editing a table and utilising Excel as the vehicle. When I change the spreadsheet I need to produce a new csv file and then re-import to generate new layers. Handling Excel spreadsheet ...
1
vote
3answers
472 views

DBMS error when importing XLSX into ArcGIS Pro

I am working with an XLSX, and consistently receiving either a "underlying DBMS error", or associated with the file. I have worked through all the suggestions and limitations from ESRI to the best ...
1
vote
0answers
37 views

Interpolating sea level data using ArcGIS Desktop?

I have monthly sea level data obtained from PSMSL in the form of excel sheet for the region Chennai. I want to interpolate the data in ArcGIS Desktop. The shapefile of the region has Polygons and I ...
1
vote
0answers
81 views

QGIS automation field from Excel

I present the following situation. 1 - Draw polygon shape in QGIS 3.4 / geopackage, only with two columns ID and NUM_SETOR, using the google maps image as reference. 2 - Excel table where I combine ...
1
vote
0answers
49 views

QGIS hyperlink to specific row/column excel

Is there a way to set a hyperlink to a specific sheet/row/column in an excel document? I am able to link to an excel file on the server and open it from QGIS, but would like to open the document to a ...
1
vote
0answers
48 views

Interpolate and export the following points

I have two crossections of the same position. I am looking for a way to interpolate the blue points from the attached image. I need the xyz values of the interpolated points, how can I do this? I ...
1
vote
0answers
302 views

Filter on joined tables in QGIS

QGIS 3.2.3: I have a shapefile and an Excel table which is joined to the shapefile based on matching IDs. I would like to filter the shapefile while using a joined field from the Excel table. When I ...
1
vote
0answers
79 views

Exporting several maps with excel sheet using Arcpy

I try to export 20 maps with this python code in ArcGIS 10.3.1 for Desktop. Each map has excel sheet (not attribute table) in the layout view. The excel sheet file located in G:\Users\test\Downloads ...
1
vote
0answers
219 views

Using ModelBuilder to Automatically Import Excel, Display XY and Append to Master Shapefile?

I'm trying to automate a daily workflow using ModelBuilder. I have several tasks that I do daily in this order: Import an Excel file that contains 16 fields including two fields with x and y ...
1
vote
0answers
42 views

Referencing an external editable CSV file in a spatialite base

I would like to join a CSV file attributes to multiple spatialite layers, but I would like to be able to edit the csv externally (export it from a different project on Excel or Numbers every time I ...
1
vote
1answer
44 views

How to present parameters and their contents for each attribute

I have a table of data and I would like to know how I can use this data for a cartographic presentation and a publication on a geoportal as well as a map service. The data represents measuring ...
1
vote
0answers
85 views

How can we sync attribute tables with excel file automatically?

I always export to excel every time I update a shapefile, is there a way of updating excel automatically.
1
vote
0answers
85 views

Using excel info to create thematic map

So, I have an excel spreadsheet with information regarding people within a certain zip code. I basically need to make a map that shows the amount of people within each zip code either using dots or ...
1
vote
0answers
23 views

Post data from excel spreadsheet-arcampdesktop- arccollector

I recently created a excel spreadsheet with different webcams that have lat long, name and hyperlink for each angle on every camera. I am able to import that data from excel to arcmap desktop no ...
1
vote
0answers
673 views

Creating an interactive chloropleth map with Leaflet and Excel data

I am trying to create a chloropleth map with Leaflet. I have an Excel spreadsheet with different columns such as "Project Name", "Project Description", "State" and "Province". Is there a way to ...
1
vote
0answers
164 views

Using inline variable substitution in ModelBuilder for iterating through Excel sheets?

I need to join .xlsx tables to a states.shp files based on StateName, and then export the joined features into a geodatabase. I have several excel files ("XX2011, XX2012, XX2013, etc.), and need the ...
1
vote
0answers
170 views

Invalid Geometry when Importing Shapefile into Excel 2016 PowerMaps

I downloaded Public_School_Locations from NYC Open Data website When I attempt to import Public_Schools_Points_2011-2012A.shp into Excel 2016 PowerMaps this is what I get When I attempt to pick ...
1
vote
0answers
190 views

Table to Excel creating sheet name with special characters 10.3

I have been searching through forums to solve this issue with no luck. I work for a housing finance agency specializing in affordable housing. When we receive applications, we send letters to ...
1
vote
0answers
58 views

Any way to deal with multiple entries for one field in QGIS?

I'm mapping out parcel numbers from an excel spreadsheet, matching them to the county APN field in a shapefile , which is in the format ###-###-##. My spreadsheet has four fields that I've ...
1
vote
0answers
145 views

Radiometric calibration NDVI values in Excel

I´m doing NDVI analysis, but i forgot to do Radiometric calibrations in QGIS. So the NDVI values in my excel table are in DNs. Can I do this calibration directly in excel?
1
vote
0answers
63 views

Trying to activate GeoRover LocusTracker toolbar; another way to import to shapefile?

In ArcGIS I'm trying to activate the GeoRover LocusTracker toolbar but it won't come off its grayed out status. Might anyone know how to make it active? If anyone knows of another way to import an ...
1
vote
0answers
240 views

QGIS Copy Attribute Table To Excel - where does the new lines come from?

I have an attribute table with 3100 lines. I selected the whole table and pressed the button 'copy selected rows to clipboard', afterwards I pasted them into an excel-table. Now I have 27 lines ...
1
vote
0answers
76 views

Repeated GPS coordinates in data are creating stacked points on map in QGIS

I have 30+ events of data collection for each GPS location (previous person on project has simply added new rows for each data collection period). When I import the excel file (via CSV format), each ...