Questions tagged [excel]
Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.
613
questions
3
votes
1
answer
3k
views
Copy / paste table attribute qgis to excel lose colum order
When I copy data from a table attribute to excel the order of column is randomly.
E.g.
If in Qgis the order of column is column_a, column_b, column_c, column_d in excel is column_a, column_c, ...
- 79
1
vote
1
answer
355
views
How to make a clickable label in qgis from an excel sheet?
I have location data in excel sheet where each label has corresponding data file for each financial year.
I want it that when i click on a label, years pop up, and when i click on that year, its ...
- 11
1
vote
1
answer
136
views
Field format when saving joined layer from xls
If I perform a join of an xls file to a shapefile and then save it as another shapefile, my numeric fields from the xls are displayed with many decimal ceroes.
Here is an example: The upper table is ...
- 882
1
vote
0
answers
107
views
Can't find name with accent mark [closed]
So I have a spreadsheet that I'm trying to import into a GDB as a shapefile and then modify some fields with arcpy.AlterField_management(). The problem is that the field name has an accent mark (...
- 292
1
vote
1
answer
334
views
Importing back GIS made grid from Excel?
I have the following problem: We created a grid and used it's squares as quadrates with an also attached attribute table. As the working areas were far fom each other, we created different sites ...
- 11
7
votes
2
answers
3k
views
Copying attribute table to Excel in ArcGIS Pro?
In ArcMap I can select all rows in the attribute table, right click one of the grey boxes, copy and then paste into excel:
There is no Copy option in Pro.
How can this be done in ArcGIS Pro (...
- 72.6k
1
vote
2
answers
3k
views
Connect Excel to Survey123 Data Source
I have a form / survey created for Survey123. It has been published and I can access the data which has been captured through the ArcGIS Online Portal.
I would like to read the attribute information ...
- 3,706
2
votes
1
answer
1k
views
Why do imported excel long/lat points not align with basemap?
Using old plans and maps that I rectified and georeferenced I determined approximate coordinates for certain points. These coordinates are in decimal degrees and are split in two colums latitude and ...
- 51
4
votes
8
answers
7k
views
QGIS not always recognizing the field name from excel files
I'm importing multiple excel files into QGIS (version 2.18.7) by dragging and dropping them into QGIS. The excel files don't contain any coordinates but data that I need to join to vector layers.
My ...
- 43
4
votes
3
answers
281
views
Can I escape field names when building a Search Cursor?
I am trying to iterate through an excel spreadsheet using arcpy but having trouble querying fields that contain spaces in their names:
If I start by examining the fields by the python console I see ...
- 1,484
2
votes
3
answers
400
views
FME statistics on Tester Conditions
I'm using FME to look at a large directory and filter down through many factors to handle the data within the directory.
One of the stages I am working on is to search for companies that own the data....
- 163
2
votes
1
answer
2k
views
Displaying x,y coordinates not working correctly in ArcGIS Desktop?
My issue is similar to Displaying X, Y coordinates on ArcGIS not working but the solution there did not work for me.
I am importing Excel data into ArcMap, and have already saved it as a CSV. When I ...
- 21
2
votes
1
answer
921
views
Excel file . xlsx can't join with the shapefile map layer [duplicate]
Trying to join a shapefile layer - polygons - (municipalities with a data table with corresponding data sets) an Excel file with the .xlsx extension, BUT as showed in the attached image some error ...
- 15
1
vote
0
answers
58
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 ...
- 33
0
votes
1
answer
36
views
Converting dwg file by GISpoint
I am working with an excel/csv file which contain Easting Northing & Elevation value (Its all about point feature). But when i am converting this file in dwg by GIS for use in auto cad then the ...
- 3
1
vote
2
answers
145
views
Calculate the mean for all the attributes of a zipcode? [closed]
I have a spreadsheet with two columns: Zipcode and Housing Price. Is it possible to calculate the average Housing Price per zipcode without manually using Excel commands per zip code?
- 181
0
votes
2
answers
2k
views
ArcMap not recognizing first column of CSV?
ArcMap is not recognizing the first column of my csv. Field name "AppID" and the values are all in the format of wxyz-#### (letters-numbers). I've checked the files for erroneous carriage returns. If ...
- 1
4
votes
1
answer
2k
views
Configuring columns when adding CSV file to QGIS
I want to load a csv file into QGIS, and the data in QGIS as point layer. I have tried to use this function:
Layer ► Add layer ► Add Delimited Text Layer.
When Im loading the file name, the data ...
- 221
1
vote
1
answer
49
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 ...
- 91
3
votes
1
answer
3k
views
Copy/Paste attribute table qgis without the wkt_geom column?
Is there a way to copy the attribute table on qgis and paste it on excel without the wkt_geom column?
- 77
1
vote
1
answer
1k
views
Creating a 3D model of a pond using GPS coordinates and associated depth measurements
There is a pond which I am trying to create a 3D model of to view the depth. We have measured the depth every few meters along straight line transects all across the pond, and have GPS coordinates for ...
- 21
2
votes
1
answer
426
views
Use Milliseconds on Time Manager
I am trying to use Timemanager with my csv files which i loaded on my map as shp layer. those contain time staps which i tried in hh:mm:ss.fff hh:mm:ss:fff hh:mm:ss,fff and also each with 1 f - in the ...
- 77
0
votes
0
answers
1k
views
Hide field name and label for Surveyor and show it for Supervisor by Survey123 for ArcGIS
The scenario is, add new field to xls form that represent percentage (%) of accurate collected by surveyor this field is not visible to the surveyor at the same time this field will be visible to the ...
- 1,123
1
vote
0
answers
144
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.
- 11
1
vote
1
answer
196
views
QGIS python error for XY tools plug in, even after installing xlrd and xlw modules!
As I am a complete beginner, I had troubles getting the XY tools plug in running. Now that the xlrd and xlw module error has disappeared after installment of said modules, I can finally choose the X ...
- 11
0
votes
2
answers
392
views
Imported from Excel XY coordinates into ArcMap 10.4.1 display at zero latitude
When importing spatial data from excel, the imported point layer is displayed onto 34 latitude and 0 longitude. It should be 47-48 latitude and 37-39 longitude.
What could be causing it?
I tried to ...
- 42
1
vote
0
answers
126
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 ...
- 11
1
vote
0
answers
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 ...
- 11
1
vote
1
answer
279
views
Arcpy: import xls to point shapefile
I need to convert a .xls file to a point shapefile. The Excel file contains points in Lat, Lon with many attribute fields. I wrote this script to convert from .xls to .dbf and then to shapefile but it ...
- 31
4
votes
2
answers
218
views
Converting Excel Data to Projected Point Shapefile says Invalid SQL statement was used?
I am trying to take an excel file, display xy data, export, and then project. When using the VTDeerCulverts excel file (field names listed in pdf below) the process works until I project the data. At ...
- 43
2
votes
1
answer
192
views
Many-to-One Join while Maintaining Attributes in New Fields [closed]
I am struggling to find the correct tool to do what I want and I feel I am overlooking something simple... I am working with census blocks and internet providers in those census blocks. I have a ...
- 21
1
vote
2
answers
884
views
Copy and Paste Attribute Table Loses Formatting
I have 4 shapefiles in total, and for 3 of my attributes tables, I was able to directly copy it (including the formatting) into Excel. I do this by using 'Select All' and 'Copy Selected'. When I went ...
- 11
2
votes
3
answers
18k
views
Failure to connect to database
Background: I'm using GIS tutorial basic workbook (ArcGIS 10.1) with ArcGIS 10.5 software, and my MS office is 2010
I was practicing building a file geodatabase, and I have imported shapefile without ...
- 31
0
votes
1
answer
2k
views
How to convert .shp to lat and long coordinates en excel? [closed]
I am trying to convert the below SHP file into lat and long coordinates in excel. I have no idea how to code or even find where the coding section is.
1
vote
2
answers
3k
views
Convert Longitude and Latitude values from database to Decimal Degrees
I am getting data from a SQL Server, with values for longitude and latitude stored as "raw" values i.e. there are no negative signs in front of longitudes, and no decimals in either longitudes or ...
- 177
1
vote
3
answers
2k
views
dbf to excel format
I have a .dbf file from arcgis 10.1 and it contains 370 columns and 582 rows. I want to open it in excel but it can only open 256 columns no more than that.
There's a way that I can break a file and ...
- 39
1
vote
0
answers
950
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 ...
- 11
1
vote
0
answers
217
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 ...
- 23
1
vote
0
answers
253
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 ...
- 301
1
vote
1
answer
989
views
Export RGB data (from a tiff image) in excel format
I have a tiff file having 3 bands R, G, B. I used the following program in R to obtain the pixel values for each band separately.
r<- raster("lena.tiff", band = 1)
writeRaster(r, filename = "...
- 199
0
votes
1
answer
55
views
When joining .xlsx to state .shp, exporting feature class, why are attribute names not retained?
I have a shapefile of the U.S. states, and tabular data that I joined to it based on the state name. The data was downloaded in .csv format, but it didn't carry over some number categories when I ...
- 23
0
votes
1
answer
380
views
Finding matching rows across columns and populating a separate column
I am trying to write a script that recategorizes 70 attributes in to 1 of 5 attributes.
I have two tables, each with two columns that I am focusing on. The first table has one column with 20k rows ...
-2
votes
1
answer
129
views
Is there a program to help me cull my raw data? [closed]
I haven't taken a GIS course in over a year, so I think I've forgotten everything.
I recently made a long (300+) list of data entries on an Excel file. Rather than sort through it by hand, is there a ...
- 181
0
votes
0
answers
5k
views
Using Custom Regions in Excel 3D Maps
I am trying to use Custom regions (other than country, province or city boundaries - see picture below) to display data from Excel sheet on map using Excel 3D Maps (Excel 2016). I always successfully ...
- 342
0
votes
1
answer
169
views
Math function in VRT
I am using the following VRT to load a Excel sheet into QGIS and I would like to perform some functions on the inputs to create new fields. Is this possible?
Ideally I would do pythagoras Field 10 ...
3
votes
1
answer
2k
views
How do I stop FME from using the first row as the column name when reading XLS?
I have a number of Excel XLS-files that I want to process with FME. They're each structured in two columns, column A with area names and column B with values for each area.
When reading the file, FME ...
- 2,646
-3
votes
1
answer
1k
views
Error 001530 : Input Table exceeds the 256 column limit of the .xls file format [closed]
I am unable to export the table using "Conversion tool : table to excel". It shows error
"Error 001530 : Input table exceeds the 256 columnlimit of the .xls file format"
I tried all solutions but ...
0
votes
0
answers
54
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 ...
- 315
2
votes
2
answers
87
views
Trying to join a table to a shapefile. Identical key values will NOT join
I have a shapefile of all the addresses in a city and a table of survey results for a sample of addresses, with NO spatial aspect. I am asked to make the survey data spatial, so used a simple join ...
- 86
0
votes
1
answer
129
views
Adding coordinates to map?
I am trying to make a map using ArcMap 10.3 and adding Excel coordinates from a map. I originally converted addresses to lat/long using an online site. I have tried every suggestion I could find ...
- 1