From decimal values in Excel to binary / hex Intel format

Thread Starter


Joined Jan 6, 2004
Have to burn massive data to two eeproms which I will produce in Excel in decimal notation.

A friend will do for me, requesting it in binary or hex Intel format.

Can anyone detail the process to go from the .xls file to both options (binary or hex) ready to be passed to him?

I discarded anything done by hand other than producing the data itself (prone to error - and boring).

JUst in case I know nothing about common tools for people programming PCs in any form. Sorry, just assembler for PICs :mad:


Joined Jul 30, 2009
In Excel, there are functions called for converting from binary to hex to decimal. For example, DEC2HEX converts from decimal to hex. DEC2BIN converts from decimal to binary.

For these functions to work, you must enable the Analysis ToolPak. Go to Tools-> Add-Ins. Then select the checkbox next to "Analysis ToolPak." If you don't see "Analysis ToolPak," you'll need to download it off the MS Office website.