1
vote
0answers
38 views

Editing the QGIS Attribute Table

Is there a way to edit the name, type and length given to each column on the attribute table once the information has been imported from Excel?
3
votes
2answers
140 views

Combining MS Office with GIS

I would like to incorporate MS Office into my GIS program. I have been using QGIS and was wondering if this would be possible? I am trying to create a one stop shop for my staff to be able to ...
0
votes
1answer
92 views

How to create input data for the LRS plugin from an excel table without coordinates?

I'm working with QGIS 2.2.0. I want to add a shapefile from an excel file that has informations I want to use in the LRS plugin. The excel file has no geographic information. Every time I try to save ...
0
votes
1answer
72 views

How to join information from an excel table to a road feature in QGIS?

I'm working with GQIS 2.2.0 Valmiera. I've made a shapefile of a road that consists in a single line. Now I want to add information that I have in an excel table about several point in the road. How ...
0
votes
1answer
78 views

Help in importing excel data

I have downloaded the hourly solar radiation data from NREL which is in CSV format but the problem is that the file does not have an exclusive column called latitude and longitude. There are 100s of ...
1
vote
1answer
60 views

Is it possible to link a QGis project with an excel file?

I have an Excel file with coordinates and I have used this file to plot the coordinates in QGis. I was wondering if it was possible to permanently link the excel file to the QGis project, so that when ...
0
votes
2answers
107 views

How to add Excel-sheets with meter coordinates to QGIS?

I have an Excel-sheet where the coordinates are in meters. What is the most efficient way of inputting this file to QGIS? There are thousands of files to put so please recommend some straight-forward ...
1
vote
1answer
203 views

QGIS, making a topo map from an excel file

I will appreciate your help. I am new to QGIS, this question might be common but trough me search I did not find the answer I needed hence my question here. How do I make a topo map ( raster) from ...
5
votes
3answers
303 views

Cleaning up data in Excel for use in QGIS

I am trying to clean up a large .txt dataset in Excel. I think that a macro or another application may be able to clean up the data they way I want but I have limited programming skills. I need to ...
3
votes
2answers
105 views

Why can't I open a .xls with QGIS in OSX?

I'm trying to open an .xlswith QGIS 1.8 in a Mac, I'm loading the vector layer from Add new vector layeretc. etc. the procedure works in Windows but not in Mac where I have an error Invalid source ...
0
votes
1answer
309 views

QGIS: CSV point grid to polygon - not raster

I have a CSV file with various data in 1 degree wide by 0.5 degree high rectangles, for which I have the N,S,E,W, & centroid lat/longs, i.e. every bit of spatial data required. I'm trying to ...
1
vote
2answers
300 views

Join excel attributes to shape attribute

I am wondering if there is a way to join the attributes from excel tables to shapes in Qgis. I have abbreviations in the shape and want to add the associated complete names from excel file by ...
1
vote
1answer
67 views

point shape file problem

I have a point shapefile which was created from a text file in Excel using the delimited text layer plugin in QGIS. My problem is that I am getting a point shapefile but when i try to insert this in ...
1
vote
1answer
269 views

QGis creating shape file of several points out of two Excel sheets

I am about to create a Qgis file on which it should be visible which companies are working together. As source I have got two Excel Tables. Table = Distribution Centers Table = Point of sales I ...
1
vote
4answers
2k views

Get pixel value from a raster in a xy table

I'm trying to find a way to convert a raster (in my case it's a Landsat satellite image) into a table with 3 columns which would represent: 1) x coordinates (the so called "xllcorners" in ASCII ...
3
votes
1answer
219 views

How to import or incorporate formated Excel tab into QGIS print composer

I would like to know if there's a way to import formated Excel Tab into QGIS print composer. Below is an attachment of formatted Excel tab example I has been asked to display on qgis map composer. ...
0
votes
0answers
29 views

Exporting QGIS attribute table to excel [duplicate]

I have a million rows in the attribute table, with lat/lon columns that I want to export to Excel. Selecting all the rows causes QGIS to crash. Is there another way to do the export? The million rows ...
0
votes
0answers
56 views

Adding a new attribute to shapefile from Excel sheet [duplicate]

I have a shapefile in QGIS and I needed to add a attribute to the attribute table. The problem is that I have the information I need to add in an Excel file. How can I add the information from the ...
4
votes
1answer
1k views

What is the best way to connect spatial data with attributes in Excel table?

I have many attributes which are stored in an Excel table. They refer to USA counties. I need to somehow connect those attributes to polygons in some format (don't know which is the best) and ...
10
votes
3answers
7k views

How to import coordinate data from excel into QGIS?

I have an excel file containing data collected over many years as latitude and longitude coordinates for archaeological sites - how can I import it into QGIS as a new layer?
3
votes
2answers
2k views

How to edit Shapefile Attributes?

How might I go about exporting a polygon shapefile (e.g. CSV) so that attributes (not geometry) are editable by others, and importing it with the changed attributes (of which there are several columns ...