Tag Info

New answers tagged

0

In ArcGIS 10.2 for Desktop this is a two step process: Use Excel To Table (Conversion) to convert your Excel file to a table (dBase or file geodatabase) Use Join Field (Data Management) to join the contents of your table to your shapefile based on a common attribute field.


0

well, if the excel and the shapes have a field in common you can join the excel to your shp. If not you can make a common field between them and do the join.


2

You can save the csv layer as shapefile to edit the data. Therefore right click the added csv layer in the layer menue and select Save as.... Following dialog will open: Now you can save your csv as shapefile. The resulting shapefile is editable.


0

Hi Guys, I faced the same issue and I solved pretty much in the same way (hours lost finding out how to get rid of the $ as well!!). I used a wild card (Iterate Table > Make Var > from Par > Wildcard) to selct correct Exxcel sheets within the table. Sometimes it can be useful. Cheers, Marco


1

1) Click in Vector --> Geometry Tools --> Extract nodes 2) In the new window a)check "Add result to canvas" b)Browse your locate and save with a name 3) Whait a moment, in the layer Right click and choose "Save as" 4) In "Format" choose the "Comma Separated Values (.csv)" 5) And open the .csv file in to Excel and you have all ...


2

Extracting coordinates of start/end vertices (not all line vertices) from lines is a nice use case for new functionality in QGIS v.2.8, namely, the function editor. This is the workflow: Load your line layer to QGIS and activate it. Open the field calculator and go to tab Function Editor. Click on New file, write vertices as the new file name, and click ...


2

Click on Vector -> Geometry Tools -> Extract Nodes A window will appears, choose a file to save and mark the option "Add result to canvas". Right click in the new layer created and click on "save as". Choose a name to your file and open it with a text editor to check the result.


2

For exporting the coordinates too, I assume you will have to add new columns for x and y coordinates and calculate these using the fieldcalculator with the appropriate operators.


2

Export table to excel: Right click layer in table of contents select Save As Under Format drop down select Comma Separated Value (CSV) option Open excel and browse for saved .csv to open


1

No, you can not because the GDAL Excel driver is read-only: http://www.gdal.org/drv_xls.html The XYtools plugin allows to import point coordinates together with attributes, and export the attribute table only (if it works), but no real-time syncing. You can save to CSV, and import that back into Excel manually. But this is not the kind of ODBC-like ...


5

Install the XY Tools plugin by Richard Duivenvoorde. Select a vector file from the ToC (that is, make it active). Go to Vector->XY tools->Save attribute table as Excel file. You would need the Python library xlw installed for doing so.


2

To get a csv file of the attribute table, rightclick on the layer in the legend, and change the file format from shapefile to CSV. You might need to change the separator from comma to semicolon in a text editor if Excel does not like the default separator.


1

First of all, make sure your excel table is "clean". This may seem obvious, but you'd be surprised...Here's an example of what kind of things you should avoid: Just with this precaution it should work. However, if it's still not working, use the conversion tools. Conversion tools>Excel>Table to excel and import your excel into a gdb. That should work. If ...


1

First, open the Excel file in Excel, and then click Save As and select CSV (Either Macintosh or MS DOS works for this purpose) Next, in ArcMap, choose the tool Table to Table and for the input, choose the CSV you just created. Have it output somewhere you can find the table, and the joining should work with the table that was just created. TL;dr: Save ...


0

You may be having some issues related to the characters contained in the table. Try to get rid of anything that is neither alphanumeric or underscore. Not sure if you came to this point but this is my guess. Arc does only allow letters, numbers, and underscores. Here are some tips regarding this: ...



Top 50 recent answers are included