Questions tagged [spreadsheet]

working sheet from a spreadsheet program like OpenOffice Calc or MS Excel. GIS layers are meant to be directly created from spreadsheets containing addresses or coordinates using some special mechanisms.

Filter by
Sorted by
Tagged with
2 votes
1 answer
95 views

When importing coordinate data into My Maps (Google) layer I want to set the image path to Google Drive

I have a Google Spreadsheet with coordinate data and a path to an image in a Google Drive folder, I want to import the spreadsheet into a map in My Maps and tell the importer that the column [IMAGE] ...
user avatar
0 votes
0 answers
22 views

Export spreadsheet to shapefile not working

Pretty basic, but I've never had this happen. I have a spreadsheet with X/Y which I have imported into ArcMap (all fine no issues). However when I export it to a shapefile it is blank. If I export it ...
user avatar
1 vote
0 answers
45 views

Blank screen when displaying vector file from spreadsheet in QGIS

I have a spreadsheet plugin installed. The Excel spreadsheet has coordinates in Australia's national grid GDA94 zone 56 which are metric. I open the Excel file and use the geometry button and ...
user avatar
1 vote
1 answer
65 views

Modifying SpreadsheetLayers Plugin

I'm trying to make a small change in this QGIS plugin (https://github.com/camptocamp/QGIS-SpreadSheetLayers), but I did not succeed. I have an ods spreadsheet in which the coordinates can come in ...
user avatar
  • 11
1 vote
2 answers
468 views

Adding National Grid Reference data from spreadsheet into QGIS

I have been given some point data and loaded it against the relevant open street map. I'm looking to create a point shapefile based on the National Grid References (NGR) found within a spreadsheet. If ...
user avatar
2 votes
1 answer
207 views

Preparing data for timeline animation in QGIS

I have a data-spreadsheet containing a value-attribute that changes over time for a number of administrative units. I have a polygon layer as well with features for each of the administrative units. ...
user avatar
  • 41.1k
1 vote
0 answers
28 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 ...
user avatar
  • 111
2 votes
1 answer
59 views

Create points along a line from spreadsheet data in QGIS

I have a sewer network comprising: Manholes - a points layer Pipes - a polyline layer, with attributes comprising the upstream and downstream manhole I have a spreadsheet of pipe defects (from a ...
user avatar
  • 1,257
1 vote
0 answers
43 views

QGIS - How to add joined values table data to shapefile

For some reason I lost my previous question here but I proceeded a little bit after upgrading to the newer version of QGIS. My problem was combining spreadsheet .csv data to the .shp map layer, where ...
user avatar
0 votes
0 answers
37 views

Getting duplicate values when joining .csv spreadsheet to .shp map layer using QGIS?

I need to join .csv/spreadsheet data to the .shp map layer. The join itself isn't a problem with same join & target values (building) but some data goes missing because of duplicate values. For ...
user avatar
2 votes
0 answers
115 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 ...
user avatar
  • 571
0 votes
0 answers
32 views

Getting spreadsheets to autopopulate tables?

I am working on the Arcgis local government solutions Election Results web app and hosting it out to arcgis online organization. After looking at the spreadsheets, the tables and related feature ...
user avatar
-1 votes
1 answer
399 views

Importing and synching polygons from a Google Spreadsheet into Carto - can it be done?

I have used Google Spreadsheets as a way to provide our large organisation a way to update carto maps with new locations without needing to consistently contact the web/GIS teams but only with ...
user avatar
  • 101
4 votes
1 answer
2k views

Removing and deleting duplicates in FME?

I'm analysing a large folder containing huge amounts of data, using FME. I'm filtering it down as much as possible, and I'm a little stuck at this part. Right now it is just about creating lists. ...
user avatar
  • 153
1 vote
0 answers
52 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 ...
user avatar
  • 33
2 votes
2 answers
780 views

QGIS / Spatialite / DB Browser : basic : joining tables and more

Question : Is it possible to create a table in QGIS that will be a dynamic reference for geographical data entries? As I'm sure this will sound very general and unclear, here's the actual situation I ...
user avatar
  • 33
1 vote
1 answer
79 views

Error Opening File?

I have searched the internet for a few hours now and have gotten to the point where I need to ask this. I am currently developing a code that will take a large subdirectory of .xlsx files, read them ...
user avatar
0 votes
0 answers
47 views

ArcGIS 10.3 connecting to spreadsheets

I have feature classes of property parcels that are polygons. My client maintains data about the parcels in a google doc spreadsheet (online) and updates the information regularly. I am required to ...
user avatar
  • 315
2 votes
3 answers
146 views

Getting Spreadsheet Data of Points from PNG using ArcMap?

I'm rather new to using ArcMap. For my research project, I have a layer of point data. I have been downloading datasets and layers of aggregated annual precipitation across the United States. All I ...
user avatar
  • 21
2 votes
1 answer
1k views

Linking Google sheet as a database for GIS [closed]

I’m working on a database update, at the moment this database is simply an excel spreadsheet not formatted to be used in a GIS project. The database has to be updated and modified over time. Some ...
user avatar
  • 303
1 vote
0 answers
139 views

In QGIS import/update multiple layers from single spreadsheet

I have a spreadsheet I regularly update with new data. It contains X, Y and several column pairs. How does one assign in one operation information from the pairs (and associated X,Y) to their ...
user avatar
2 votes
1 answer
44 views

Sheetsee optionsJSON problem

I am doing some basic work with G Sheets and Sheetsee.js library. I have it working as far as I get my coordinates showing up on a map. I'm using the demo-map file as my starter, I just changed the ...
user avatar
  • 131
2 votes
1 answer
786 views

QGIS create layer from spreadsheet file (Spreadsheet Layer plugin)

With the QGIS plugin 'Speadsheet Layers' i try to create a layer with the following parameters: But I'm just getting a layer with no geometry. I've been playing arround with real instead of integers, ...
user avatar