parse out value from a column and write it into a file path

[dreweezy]

What would be the best way to parse out a specific value from a simple excel spreadsheet and write it into a directory?

I have something like..

Name,                                                                                                      e-mail

name=Andrew, department = Finance, code = 154             andrew@example.com

I'd like to parse out just the name value into a separate column and ultimately write and save this updated spreadsheet into a specific file path. 

Envisioned outcome -

Name,                                                                                                      e-mail                                             UpdatedName

name=Andrew, department = Finance, code = 154             andrew@example.com           Andrew