To make your data look like a spreadsheet/ grid, you need to make changes to 2 templates - Main and Short. You need to create a table with one row (for your column headings) and then the GRID token in the next row (which is actually the stuff stored in the Short template).

In Main, look for the GRID token. Select and delete the start and end table tags immediately around it (watch out for the table tags above and below it for pagination controls). Replace it with this:

<TABLE border=1 cellpadding=3 cellspacing=0>
<TR>
<td class='normal' valign='top'>ID</td>
<td class='normal' valign='top'>FIELD1</td>
<td class='normal' valign='top'>FIELD2</td>
<td class='normal' valign='top'>Action</td>
</TR>
<tr>#GRID:1#</tr>
</TABLE>

NOTE: FIELD1 is your field name. Repeat a TD line as many times as you have data columns. Edit the table properties, td class, etc to customize your look.

Next, in the Short Template, replace all of what is there with this:

<td class='normal' valign='top'>#ID#</td>
<td class='normal' valign='top'>#FIELD1#</td>
<td class='normal' valign='top'>#FIELD2#</td>
<td class='normal' valign='top'><A href="#top" ONCLICK="#LINKTO#"><B>View</B></A> <A href="#top" ONCLICK="#EDIT#">Edit</A> <A href="#top" ONCLICK="#DELETE#">Delete</A></td>

NOTE: No TR tags.  For each of your fields make sure they are in CAPS and surrounded by #'s. Feel free to remove or rename any of the action links (view, edit, delete)

That should do it.

Thank you for this, just what I needed. Now one more question. In the Main View is there a way to hide a column and make it available to only administrators? For example, I would like to have the "Action" column above only be visible to the admins.

Thank you!