Need Excel Programming & Macros Wizard - Zoho Analytics & Sheets Experience

Need immediate help with setting up automated process in Excel (using Macros) to do the following:

1. Ask for / accept a JSON file
2. Expand all nested records and lists etc.
3. Edit row 1 heading names, here are some examples:
a. Remove ResumeParserData. (ie. if title is ResumeParserData.SubCategory change to SubCategory)
b. Remove word Segregated
c. Remove Experience.Employer
d. Remove Qualification and add Edu before remaining text
e. Remove Certification and add Cert before remaining text
4. Add 1 after all headings where there may be multiple lines, some of these include:
a. Employer: EmployerName
b. Experience: ExpStartDate, ExpEndDate
c. Education: InstitutionName, City, State, Degree..
5. Eliminate duplicate text (cells) and empty cells from within each column so that all information STARTS in row 2
6. Test data and create new columns as needed:
a. If data in rows below row 2 is different from information in row 2, then create new column next to this row with same heading but add 2 ..... continue to do this until no more new data exists (ie. column EmployerName1 will now have new column next to it with heading EmployerName2)
7. Insert default text for columns / headings that have no value, for example:
a. If EmailAddress has no value, insert Email Address
b. If Address.City has no value, insert City

Ultimately, this will be built into a process that needs to do the following, but for now, I JUST need a quick tool to help me work with the JSON files and see if the output is accurate
1. Parse original resume through parsing software which delivers JSON file
2. Send / Import JSON file into Excel OR Zoho Analytics (which automatically expands all the nested records and lists)
3. Automatically edit data in file so that information is in only top 2 rows (I think this is necessary but I may be wrong)
4. Save as .csv and send to Zoho Writer for data to merge with template and create reformatted resume
About the recuiter
Member since Nov 11, 2022
Ajeet Parmar
from England, United Kingdom

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions