Spreadsheet Ready List of Binary, Octal, Hexadecimal and Decimal Numbers
=== by Bob Sutherland ===
Counting from 0 to 4000, here is a list of equivalent binary, octal, hexadecimal and decimal numbers separated by commas for use in spreadsheets and databases.
Warning: Do not print this list as it may be over 100 pages long! Go to End↓
This list is ready for use in a spreadsheet. Here are the instructions:
- Copy and paste the lines you want to use into a text editor application program such as Notepad in Microsoft Windows or TextEdit in Macintosh OS X.
- Save the file in the text editor using any filename you want provided it has a filename extension of .csv (e.g. something.csv). If that is not possible then save the file using a filename extension of .txt (e.g. something.txt). Locate the new file which you probably saved to your Documents folder and if necessary change the filename extension to .csv (i.e. change the filename something.txt to something.csv).
- Open your new something.csv file with your spreadsheet application program. Your spreadsheet program should interpret all of the commas in the list as being the separators or delimiters between cells. You should therefore wind up with all of the hexadecimal numbers in column A, the octal numbers in column B, the binary numbers in column C and the decimal numbers in column D.
- Use your spreadsheet program to make any further changes you want such as deleting a column, rearranging the order of the columns, or copying and pasting cells into another spreadsheet file.
If you prefer I can provide you with the file you should have created in steps 1 and 2 above.
Download: sutherland.csv
After opening the file with my spreadsheet program I discovered that some of the hexadecimal numbers containing the letter "e" and numerical digits had been mistranslated into scientific notation. That is not what I wanted to happen. Therefore you may need to play around with the settings on your spreadsheet program to preserve the hexadecimal numbers when opening the file.