Sloan Digital Sky Survey
SkyServer DR16 plus 
Not logged in Login Help

How to Graph
 Back to Help
 Enter Data
 Open a CSV File
 Create a New Column
 Select Data
 Create a Graph
 Change the Scale
 Fit a Curve
 Copy SDSS objectIDs
Graphing and Analyzing Data

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 workaround to learn how to paste them properly.