Your data are in a rectangular array. Their locations are not explicitly given, but are implicit in their positions within the array (their row and column indexes). You need to rearrange them with one value per record and you need to compute coordinates for each record. The spreadsheet is the place to do this, not the GIS.
Here is an Excel example (using a smaller array to save space in the illustration):

The original data are shown in blue at the right. At the left is the new "long" format, all ready to be imported into your GIS. (Notice that rows 14 through 80 have been hidden.) It is created from left to right, beginning with OID
, which is just the sequence 0, 1, 2, ..., through one less than the size of the array. (In your case it would stop at 961-1 = 960.)
The Row
and Column
fields are indexes into this array. They are computed using INT
and MOD
(as shown below). The X
and Y
fields convert those indexes into coordinates (also as shown below). To do this, they use the information given in green in the middle: coordinates of the lower left corner point and the spacings ("Cellsize") between points.
It is important to name both forms of the data: the original data are called NOx
and the new output (in A1:F81
) is called Database
. Naming the data makes it easy to refer to them in a reliable way, while naming the output makes it easy to import into your GIS. It is also convenient to name the green "control" variables, again to avoid making mistakes: I have given them names similar to what you see in the Parameter
column.
Here is the same worksheet showing the formulas:

These are all entered in the first data row (row 2) and then copied down through the remaining rows. The important formula is in cell F2
, which uses OFFSET
to obtain the NOx value for its Row
and Column
entry. (Note that OFFSET
starts indexing at 0 rather than 1: that is why 1 is subtracted from each row and column index.) This is a convenient automatic way to "unravel" a rectangular array of data into the "long" format needed by most other GIS, database, and statistical software: it's a good technique to know. Once you study it and memorize it, you will have no trouble creating such spreadsheets from scratch within a minute or two.
The transfer of the data is easy in recent versions of ArcMap, provided you first close the workbook in Excel: when you navigate to the spreadsheet in the Add Data
dialog, you will be shown the named ranges and worksheets. Choose Database
. After it is added to the project, right-click on it and select Display XY Data...
. Fill out the dialog. You will see a new point layer in response. Symbolize it as you see fit.

Other software may require you to save your output data in CSV or TXT format, which it will then read as input. That works fine with ArcMap, too.