Excel Text Data Formatting
Budget: ₹100 – ₹400 INR
I’ll supply the raw text files together with my Excel template the moment we kick off. Your job is to copy-paste or import that text, place every piece in the right column of the template, and apply the specific text format I need—everything must appear in UPPERCASE across the sheet.
Because this is strictly text data, the focus is on clean data entry and sound organization. I also need basic data validation where appropriate (for instance, limiting certain cells to preset dropdown options so I don’t have to correct them later). No complex analysis, formulas, or macros are required—just meticulous formatting and tidy structure so the workbook is immediately usable for downstream tasks.
Deliverables
• A single Excel workbook based on my template, fully populated with the supplied data
• All text converted to uppercase and aligned to the designated columns
• Simple validation rules (dropdown lists) added where noted in the template
• Quick note summarising any inconsistencies you spotted and how you resolved them
If you’re comfortable working quickly in Microsoft Excel and have an eye for detail, this should be a straightforward task.
Because this is strictly text data, the focus is on clean data entry and sound organization. I also need basic data validation where appropriate (for instance, limiting certain cells to preset dropdown options so I don’t have to correct them later). No complex analysis, formulas, or macros are required—just meticulous formatting and tidy structure so the workbook is immediately usable for downstream tasks.
Deliverables
• A single Excel workbook based on my template, fully populated with the supplied data
• All text converted to uppercase and aligned to the designated columns
• Simple validation rules (dropdown lists) added where noted in the template
• Quick note summarising any inconsistencies you spotted and how you resolved them
If you’re comfortable working quickly in Microsoft Excel and have an eye for detail, this should be a straightforward task.