Microsoft Excel: A Turorial
 
Tutorials
DR8 Help
 Start Here
 FAQ
 Glossary
 Cooking with Sloan
 Tool User Guides
 Contact Help Desk
 
 Searching SDSS-III
 SQL Tutorial
 SQL in SkyServer
 About the Database
 Table Descriptions
 Sample SQL Queries
 Schema Browser
 Searching Advice
 Query Limits
 
 Details of the Data
 Algorithms
 Data Publications
 API

Copying Object IDs into Excel

Excel has a known problem with SkyServer data: SDSS Object IDs are too long. The Object IDs are 18 digits long, and Excel can display a maximum of only 15 digits. For example, look at this list of IDs from the Advanced Color project:

If you copy this list and paste it directly into Excel, the list will look like this:

The last three digits of every Object ID show up as zeroes. This is especially bad because if you try to search for these objects by ID in the Object Explorer, you won't be able to find them! The 15-digit limit is set by the CPU processor, so no settings in Excel could fix the problem.

The solution is to have Excel read the Object ID as a text string rather than a number. To tell Excel to read the ID as a string, enter single quotes (') at the beginning and end of the ID. Copy your list of Object IDs into a text editor (like Notepad) and enter the quotes by hand.

After you enter the single quotes at the beginning and end of the Object IDs, paste your list into Excel. You should get a screen like this:

If you enter these Object IDs (with single quotes) into the Object Explorer's "Search by ObjID" feature, you'll get the correct object.

Entering the single quotes by hand is time consuming, and it's not practical if you have more than about 20 objects. If you have many objects (like you might get from the SQL Search tool), you should save the results as a CSV file. To learn how to properly open CSV files, see How to open a CSV file.