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 fields will be added along the way, some entries too. These operations will be done by different people not familiar with GIS. In the end the database have to be associated with polygons in existing shapefiles.
I would like to limit the number of manipulations between the modifiable database and the GIS software. So exporting a new .CSV every time a modification is done, is not what I’m looking for.
I would like to know how (or in what “software”) to setup the database so it would be easy to modify it for non-GIS users (like in Google Spreadsheet) and use it at the same time in QGIS or ArcGIS to link its data to existing shapefiles.
Google Spreadsheet is easily modifiable and shareable, if there was a way to link it with QGIS or ArcGIS so it would constantly update, it would be perfect. But if anyone now another way to proceed, I’m listening!