We received a file that has data on multiple lines for each record. Any know what it is and how to manage it?

Example of one record:
3251,James,Brown,123 Some Street,Wichita,KS,12345,{item desc price
1 Peanuts 1.00
2 Doughnuts 2.00
3 Chocolate 6.00
TOTAL 9.00

It will be a daily job so we are looking at writing an excel macro to try to handle it, but I'm sure there's a better way.

Thanks for your help.
P. Brittle