Step 2) ChatGPT Prompt to clean .csv file

Clean up this spreadsheet and export it as a downloadable .csv file with the following columns:

first_name
last_name
phone_1
phone_2
phone_3 (add additional phone columns if more numbers exist)

Extract phone numbers from the spreadsheet and place them sequentially into the phone columns.

Use the “display name” field to generate the names. If the display name contains two words, split it by the space so the first word becomes first_name and the second word becomes last_name.