Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
Geographic Information Systems

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.

15 questions
Info Newest Frequent Votes Active Unanswered
-7
votes
1answer
27 views

Spreadsheet vs Shapefile [closed]

I have the same dataset both in Shapefile and Spreadsheet. What can be the advantages/disadvantages of using one format rather than the another?
2
votes
0answers
71 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 ...
0
votes
1answer
47 views

Get current travel times for a list of destinations from Google Maps into a Sheet

I have a list of coordinates in Google Sheets (around 20). I'd like to input a location and receive current travel times to each coordinate, for the different transport modes. Is this possible from ...
0
votes
0answers
29 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 ...
-1
votes
1answer
68 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 ...
3
votes
1answer
391 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. ...
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
2answers
368 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 ...
1
vote
1answer
49 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 ...
0
votes
0answers
38 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 ...
2
votes
3answers
55 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 ...
1
vote
1answer
497 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 ...
1
vote
0answers
91 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 ...
2
votes
1answer
24 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 ...
2
votes
1answer
466 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, ...