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

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.

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