Questions tagged [excel]

Excel is a spreadsheet application from Microsoft with native *.xls and *.xlsx formats.

Filter by
Sorted by
Tagged with
1
vote
1answer
576 views

How to combine several rasters into one attribute table with no value changes in ArcGIS?

I have a set of 1000 rasters that I need to copy into excel to process some data. I want to know if there is a way to combine these rasters so I have one attribute table that keeps the properties of ...
0
votes
1answer
456 views

Turn list of values into selection set query by copy and pasting?

Is there a website or script online that allows you to copy and paste a large list of unique values in excel and turn this list into a selection set query for ArcMap?
1
vote
0answers
304 views

Convert Excel addresses to shapefile [closed]

I have an Excel file with about 70 addresses. Is there a way to import these addresses into ArcMap to show up as points in the correct location? Or do I need to pick a coordinate system? If so, how ...
0
votes
2answers
83 views

Point to Polygon

I am a city planner doing a GIS parcel layer update for our City's GIS system. I have uploaded our data from Microsoft Excel into ArcMap as a point file. I need to get it into a polygon file and I am ...
2
votes
0answers
110 views

Converting from British National Grid to Lambert Azimuthal Equal Area [closed]

I have a set of shapefiles for Europe which are in Lambert Azimuthal Equal Area (LAEA) projection: I am working in the UK and have a list of points in British National Grid (BNG) projection (...
2
votes
1answer
105 views

Adding editable Excel (or Access) table in ArcMap?

I have flood data from the past ten years written in an Excel table. Now I would like to connect the table to ArcMap, so I can join it with the shapefiles. Normally this isn't that hard, but because ...
2
votes
2answers
167 views

Identify Unknown Coordinate System (not Georeferenced)

I got coordinates to old survey data in an Excel Spreadsheet. The coordinate system is unknown. I enter the values into a proprietary system to display them in module using Google Earth. I tried to ...
0
votes
1answer
777 views

Converting multipolygon data to polygons?

I have a data set in Excel with several rows represents different polygon information. Polygon coordinates are provided in one columns as "Multipolygon". Example of one "Multipolygon" is given below; ...
2
votes
1answer
1k views

Exporting attribute table that has many rows in QGIS

I checked previous questions that could be related with this question but none of them gave me an answer. I need to know how to export attribute table that has many rows inside. I have over 2.5 ...
3
votes
2answers
910 views

Import Cartesian coordinates from Excel and count its area

I'm new and struggling with calculating xy area from Excel data ( or it can be any type of data with xy coordinates). Moreover according to task it must use all existing coordinates in Excel file. ...
0
votes
1answer
230 views

Copy records from ArcMap, paste in Excel, wrong number of records

When I use ArcMap 10.3 and copy records (from attribute table) and paste to Excel I sometimes don't get all of the records pasted. Probably a limitation of cells or rows or something. Of course the ...
2
votes
2answers
3k views

Creating a link between QGIS and a spreadsheet

For a project, I am collecting data continuously, and will continue the datacollection for quite some time. I enter my data into an excel spreadsheet, and import it to QGIS 2.16 for display and ...
2
votes
1answer
106 views

Randomly replace a set number of cells with a value from a unique list

I have an Excel/ASCII table (300x300) where I want to randomly select a certain number/percentage of cells and replace that value with a number from a list (0.131, 0.149, 0.052). Is there a way to do ...
0
votes
1answer
831 views

Adding census tracts to addresses using ArcGIS for Desktop?

I am as rookie as they come in this space. I have a large list of addresses and longitude latitude points for different locations within a state. What is the easiest and most efficient way to ...
0
votes
0answers
897 views

Which county boundaries does Excel Power Map support?

I've got a bunch of UK data that is already aggregated to "county" level, that would merrily work in Mappoint 2006, however the borders it seems to use appear to be "odd", and some places just don't ...
1
vote
1answer
570 views

Deleting Blank Spaces in Excel sheet before Importing to Table?

I have developed a model that imports an excel sheet and converts it into a table. It then joins values within this table to a particular feature class. I then use the calculate field tool to copy ...
1
vote
1answer
270 views

Adding Excel workbook to ArcMap?

I have added excel files to ArcMap numerous times without any problem and then joined them to shapefiles, but, for some reason, today I am getting an error I have never seen before. The error reads: ...
3
votes
2answers
107 views

Excel Sheet to Table - Allow User to Select

I have a model flow that allows a user to input an excel worksheet which then converts a sheet within the wksht to a table and joins that table to a feature class. Currently, the Excel to Table tool I ...
9
votes
2answers
982 views

Add an Excel file with a list of coordinates to QGIS as a layer?

I've added delimited text layers to QGIS before with columns consisting latitude and longitude separately. But Now I have an Excel file like: station no parcel no parcel coordinates 63 ...
2
votes
0answers
182 views

Create geometry in PostGIS with OGR and Python

I have issue with PostGIS, Excel spreadsheets and Python OGR bindings. I need to read many Excel spreadsheets (with same schema), parse latitude and longitude fields, create points, re-project them ...
1
vote
1answer
1k views

Attribute joins - string and text fields

I am trying to perform an attribute join, and it's just not happening for me. The Excel field (csv) is formatted as text. This is because it is prefixed with a 0 which is lost if it's any other ...
5
votes
1answer
213 views

Adding a column to an attribute table leaves edit pencil icon grayed out in QGIS?

How do I add a column to an attribute table? When I open up the attribute table I'm unable to click the edit pencil because it's grayed out? Ultimately, I'm trying to transfer data in a column I ...
4
votes
1answer
425 views

How to calculate location at given time from GPX track

I have a number of sound files with timestamps (HH:MM:SS), made when walking a transect. I need to know where I was when each file was saved. To do this I have a GPX track of the route I took - I can ...
1
vote
1answer
74 views

Copying attributes from large number of raster files in ArcGIS to Excel?

I am new to GIS, I am having large number of raster files(800) in ArcGis and I want to copy the attribute table of each raster file separately to Excel. Can anyone help me how to perform it in batch ...
2
votes
1answer
420 views

TableToTable maintaining table header in csv file as alias in ArcGIS

I have large excel tables with geochemical information that I am importing to ArcGIS. TableToTable works, but there are likely restrictions to the number of columns that can be imported directly from ...
0
votes
1answer
221 views

Checking for white space in fields of Excel spreadsheets? [closed]

I just wanted to ask this for future reference, is there a good reliable way to check for white space in excel spreadsheets and such you receive from others? Three or four times now I've had ...
3
votes
3answers
3k views

Adding Excel data to attribute table?

How do I add or append excel data to an existing attribute table? The excel column headings will match the attribute table headings (in name at least). Simply want to expand the attribute table ...
1
vote
1answer
137 views

Losing commmon data when joining excel and shapefile

When using QGIS 2.14.4 (Essen). I am trying to join data about North Sea Platforms with their corresponding licence block in the North Sea. My data is in excel, and contains the Block ID (see image 1),...
2
votes
1answer
157 views

Point feature class from excel Spreadsheet lat long

I imported an excel spreadsheet of a couple hundred lat long coordinates that I wanted to become points. The majority of them were projected correctly except for a few were in the wrong hemisphere. I ...
5
votes
3answers
2k views

Handling Excel spreadsheet in QGIS? [closed]

There seem to now be many methods for working with an Excel spreadsheet in QGIS. Some allow read-only, and some require one Excel format or another. Some also have historically been unreliable (e.g. ...
1
vote
1answer
422 views

Convert a string of coordinates to a readable polyline for export as GeoJSON

I need to take an xls file which has multiple columns of data, and a column called coordinates which is a string of coordinates (ex. 147.775364306,-20.49918551,0 147.776402476,-20.500021717,0 147....
2
votes
0answers
188 views

pyQGIS: Which attribute change signal should I listen to?

I want to receive a signal when changes have been made to a layer, regardless of the type of editing (add features, remove features, change attributes). When I receive this signal I export the layer's ...
0
votes
1answer
2k views

Using xlsx with ArcPy?

I am writing a Python script that finds the difference between populations for U.S. counties from one year to another and writes that information to a new field in a xlxs file. Can it be done with ...
2
votes
2answers
2k views

Exporting text object coordinates in DWG file to excel

How can I export the coordinates of each of the text objects in the layers MovePLOTNUM and PLOTSNUM to excel sheet (columns: layer, text value of the object, x, y). Is this possible with AutoCAD or I ...
1
vote
0answers
327 views

How to join a table based on postcodes in QGIS? [closed]

I have 2 datasets, a shapefile with postcode polygons and an excel table (.xls) with postcodes and building count. How to represent the excel table in the map? I know that in ArcGIS it's possible to ...
0
votes
2answers
69 views

Joining Excel tables to data attribute in ArcMap?

I am trying to join an Excel table to my parcel attribute table in ArcMap. I have run a validation and all checks out except it says there are no matches. What would cause this?
3
votes
3answers
4k views

Adding excel table to QGIS print composer?

Can anyone suggest some ideas to add a excel table to the print composer which will then be exported as a A3 png while retaining resolution. Attempted pasting in word as an enhanced meta file then ...
3
votes
1answer
1k views

Attaching Excel sheet with different language font(hindi) to shapefile

When I try to join a excel sheet with Hindi font to a shp file, I get '?????' as a result in those cells which has Hindi font. (Before/Aft images attached) I tried changing the locale language to ...
1
vote
0answers
241 views

automatically update Arcmap attribute when updatin Excel table [closed]

I have a map in arcmap where i want to display information that contains values that will probably change every year. I would rather not having to remove joins and then join my new excel sheet every ...
-1
votes
1answer
1k views

Export field list to excel or csv

I've got the below script and found very useful. But I need the list of fields to be exported to excel or csv. import arcpy #Set workspace environment to geodatabase arcpy.env.workspace = "e:/temp/...
1
vote
0answers
30 views

Arcpy code repetition provides slight differences in the outputs [closed]

I made a python script that uses arcpy to buffer some network areas, intersect them with another shapefile, and from this output make some calculations that are saved to an Excel spreadsheet. I run ...
1
vote
1answer
956 views

Google Earth 1.0 Type Library Missing

I've been running Excel to Google Earth Dashboards for some time through VBA on Windows 7 and Excel 2010. However, I have just tried to copy one of my workbooks to a Windows 8.1 machine on Excel 2016 ...
2
votes
2answers
345 views

Coordinates from Excel list

I'd like to import Coordinates from an Excel list, for this reason I saved the excel sheet as an .csv ant tried to import it via "Layer --> Add delimited text Layer". The points are imported, but with ...
1
vote
1answer
373 views

exporting attribute tables of multiple rasters to excel

I had a raster and I clipped it using a shapefile of polygons. Now I have about 5500 individual raster images. I have to export the attribute table of each raster to excel so that I can then append ...
2
votes
1answer
2k views

Relating shapefile to excel table in ArcMap?

I have successfully joined a point shapefile to .CSV file in ArcMap 10.0, and the type of the fields which are related in the two files are the same(text, length:255). But when I remove join and ...
0
votes
1answer
848 views

Assigning/joining tabulated data to features in MapInfo?

I am not a MapInfo user, but I have been asked whether that software can assign/join tabulated data to GIS features like buildings, roads and watercourses?
2
votes
2answers
2k views

Only able to view 2000 records of Excel table using ArcMap

I have added a 97-2003 Excel document to ArcMap to compare data. The file has approximately 3200 records. When I initially open the table in Arc it shows all 3200 records, but as soon as I attempt to ...
4
votes
1answer
790 views

Dynamic Linear Referencing of events in QGIS from Excel or CSV using virtual layer

I have a PostGIS table with a geometry type LINESTRING M to represent routes. Here is the table specification: CREATE TABLE routes ( fid serial PRIMARY KEY, r_name text NOT NULL, geom geometry(...
1
vote
1answer
86 views

CartoDB: Geometry code too long, Excel can't handle it

I am working on a map of regions where I want to be able to visualize some simple numbers on a periodical basis. I have a dataset with the polygons . However those are so detailed (the geometry is ...
0
votes
1answer
71 views

How to edit a table in order to count the number of points in the same location?

Using QGIS, I have a point shapefile that has multiple points with same coordinates across different locations. I need a count of those points. For example there are 15 features that have the exact ...

1
3 4
5
6 7
11