GIS Stack Exchange
GIS Stack Exchange

Questions tagged [excel]

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

Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS X.

It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets.

Excel forms part of Microsoft Office.

Its native formats are *.xls and *.xlsx.

613 questions
3
votes
2 answers

How can I link the cells in the excel files to a pixel on my map?

I produced an excel file with the historical solar radiation of Australia (the file has 679 rows and 839 column and the filled cells have the shape of Australia). How can I link the cells in the excel files to a pixel on my map?
M. keller
  • 59
  • 2
1
vote
1 answer

saving .xls as .dbf...at a dead end

Possible Duplicate: DBF creation and manipulation without excel 2003 Hi - I'm trying to convert an excel file to a shapefile in arview 3.3. using suggestions by Bill Huber (on the ESRI forums site). I've completed the recommened 'recipe' of…
user2653
0
votes
1 answer

Checking for white space in fields of Excel spreadsheets?

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 problems performing joins because of this, I just wanted…
Pob 1
  • 163
  • 1
  • 11
-2
votes
1 answer

Is there a program to help me cull my raw data?

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 program to help me? My computer has access to…
Mareykan
  • 181
  • 1
  • 2
  • 9