Capturing EEPROM data into excel spreadsheet?

[jellis00]

I am using Pickit2 programmer which also lets me capture the data written into EEPROM memory by a PicBasicPro routine into a user designated file. To enable debugging of the application in the field, we need to use this technique to capture the written EEPROM data from the MCU into an EXCEL spreadsheet on the laptop that is running PicKit2. All that works fine. Our problem is how to get the data imported into EXCEL so that each cell of the spreadsheet shows the hex data for one EEPROM memory location. The data that is captured by the Pickit2 looks like below and we need to somehow parse this data into individual hex memory cells. Has anyone ever done this or can anyone refer me to a source to do this? I presume what is needed is some kind of EXCEL macro that will separate each line of the data into separate memory locations showing the hex value in each location in a separate spreadsheet cell. I don't have a clue as to how to do this and would appreciate anyone's advice.

:10420000FF00FF00FF00FF00FF00FF00FF000100B4
:10421000FF00FF00FF007C00FF0000003100FF00F6
:10422000FF003000FF000100FF00FF00FF00FF0063
:10423000FF00FF00FF00FF00FF00FF00FF00FF0086
:10424000FF00FF00FF00FF00FF00FF00FF00FF0076
:10425000FF00FF00FF00FF00FF00FF00FF00FF0066
:10426000FF00FF00FF00FF00FF00FF00FF00FF0056
:10427000FF00FF00FF00FF00FF00FF00FF00FF0046
:10428000FF00FF00FF00FF00FF00FF00FF00FF0036
:10429000FF00FF00FF00FF00FF00FF00FF00FF0026
:1042A000FF00FF00FF00FF00FF00FF00FF00FF0016
:1042B000FF00FF00FF00FF00FF00FF00FF00FF0006
:1042C000FF00FF00FF00FF00FF00FF00FF00FF00F6
:1042D000FF00FF00FF00FF00FF00FF00FF00FF00E6
:1042E000FF00FF00FF00FF00FF00FF00FF00FF00D6
:1042F000FF00FF00FF00FF00FF00FF00FF00FF00C6
:10430000FF00FF00FF00FF00FF00FF00FF00FF00B5
:10431000FF00FF00FF00FF00FF00FF00FF00FF00A5
:10432000FF00FF00FF00FF00FF00FF00FF00FF0095
:10433000FF00FF00FF00FF00FF00FF00FF00FF0085
:10434000FF00FF00FF00FF00FF00FF00FF00FF0075
:10435000FF00FF00FF00FF00FF00FF00FF00FF0065
:10436000FF00FF00FF00FF00FF00FF00FF00FF0055
:10437000FF00FF00FF00FF00FF00FF00FF00FF0045
:10438000FF00FF00FF00FF00FF00FF00FF00FF0035
:10439000FF00FF00FF00FF00FF00FF00FF00FF0025
:1043A000FF00FF00FF00FF00FF00FF00FF00FF0015
:1043B000FF00FF00FF00FF00FF00FF00FF00FF0005
:1043C000FF00FF00FF00FF00FF00FF00FF00FF00F5
:1043D000FF00FF00FF00FF00FF00FF00FF00FF00E5
:1043E000FF00FF00FF00FF00FF00FF00FF00FF00D5
:1043F000FF00FF00FF00FF00FF00FF00FF00FF00C5
:02400E00D430AC
:08400000FF3FFF3FFF3FFF3FC0
:00000001FF

[ScaleRobotics]

Great question! I too will wait for a better answer. But here goes.....

The pickit2 also has a uart tool. If you can spare the pre-defined pin, you could have the pic device read out its own eeprom data in coma delimited form (using serout), then click the log to file button, then open up the comma delimited file in excel.

Not too bad, but would be nice not to have to add serout. Might need to write a visual basic program to parse it?