Bulk Spreadsheet Collation and Data Standardization
Budget: $30 – $250 USD
I'm in need of an experienced data entry professional with a keen eye for detail,
Tasks that are part of the project are:
- Collate 313 distinct spreadsheets of contacts into a unified spreadsheet.
- Assign each original spreadsheet's name to a newly added column to keep track of the originating source.
- Cleanse the data for consistency before merging them into the sole spreadsheet.
The following data cleaning requirements are needed:
- Splitting of the Full Name field into Forename and Surname fields
- Creation of a new Column containing the original filename where this contact was.
- Normalization of text-case.
Proficiency in Excel or a similar spreadsheet software is highly necessary.
Tasks that are part of the project are:
- Collate 313 distinct spreadsheets of contacts into a unified spreadsheet.
- Assign each original spreadsheet's name to a newly added column to keep track of the originating source.
- Cleanse the data for consistency before merging them into the sole spreadsheet.
The following data cleaning requirements are needed:
- Splitting of the Full Name field into Forename and Surname fields
- Creation of a new Column containing the original filename where this contact was.
- Normalization of text-case.
Proficiency in Excel or a similar spreadsheet software is highly necessary.