This Node.js script processes an email list from a CSV file, removes duplicate email addresses, and outputs a cleaned, sorted list in a new CSV file. The output file is timestamped for easy tracking.
- Removes duplicate email addresses.
- Sorts email addresses alphabetically.
- Outputs cleaned list with a timestamp.
- Node.js
fast-csvnpm package
Before running the script, ensure you have Node.js installed. You can install the required fast-csv package using npm:
npm install fast-csvor run:
yarn install
or:
npm install
- Place your unclean email CSV file in the
./List inbox/directory. Ensure the file is nameduncleanEmails.csv. - Run the script:
node emailListCleanup.js- The cleaned email list will be saved in the
./List outbox/directory, named in the formatcleanEmails_MM-DD-YYYY.csv.
The input CSV file should have the following column headers:
Email:: Contains the email addresses.Name:: Contains the names associated with each email.
Each row in the file represents an email-name pair, like so:
Email:;Name:
[email protected];John Doe
[email protected];Jane Smith
...
The cleaned CSV file will have the headers Name and Email, with each row containing the name and email address. The file will be sorted alphabetically by email address:
Name,Email
John Doe,[email protected]
Jane Smith,[email protected]
...
Feel free to contribute or suggest improvements!