I want to use a CSV with names & emails to generate multiple excel spreadsheets

[jmcguigan]

I have an excel sheet that has training modules in them that need to be personalized with all of my employees. I have about 1500 of them in a CSV file that contains their name, email & position. I want to have each employee have their own sheet with their information on it. Due to the amount of them, I definitely don't want to do this by hand. What is the quickest and easiest way to use my CSV file with their data in it to generate and duplicate the existing excel sheet with their info?


I am sorry if this is easy, this is just out of my wheelhouse when it comes to excel.

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[beecerealcello]

First, make sure your CSV is all set with the names, emails, and positions. Then, use a nifty feature called "Mail Merge" in Excel.