How to transfer comma delimited values from mac notes app into individual excel rows?

How may I import list of phrases that are in comma delimited format in mac notes app into excel? I also then need 2nd sheet with each word of the phrases to have its own row and remove any duplicates - thanks!