Enter Data

When you open Excel, you will see a blank spreadsheet table as shown below:

To enter data, simply click on any cell and enter the values. Be sure to label your columns so you know what they represent. The first row of the table is usually dedicated to labels.

The diagram below shows a table containing the object ID, ra, dec, u, g, r, i, and z values for a group of stars:

You can also cut and paste data into the table from another source such as a web page. First, select the data you want by highlighting it. Copy the data to the clipboard by using Ctrl-c or by selecting copy under the Edit menu. In the spreadsheet, click on the cell where you want the top left entry of the data you copied to be placed. Paste the data by either using Ctrl-v or by selecting paste under the Edit menu.

If you want to paste Object IDs from SkyServer into Excel, read this important workaround to learn how to paste them properly.