Excel Cleanup & Sheet Organization
Budget / Salary$30–250
TypeFreelance project
LocationRemote
Posted18 minutes ago
The current workbook has become cluttered and hard to read. I need it fully organized, formatted, and cleaned so that every sheet is accurate and easy to navigate.
Scope of work
• Fix all inconsistent names, dates, and number formats so the data follows one clear standard.
• Remove every duplicate or blank row to leave only unique, meaningful records.
• Apply a tidy layout—clear headings, logical column widths, and a light color scheme—to make information pop at a glance.
• When the data is consistent and polished, split it into separate sheets based on category or type; the master sheet should remain intact for reference.
Deliverable
A single Excel workbook (.xlsx) containing:
1. A master sheet with corrected, deduplicated data.
2. One tab per category/type, automatically updated from the master through formulas or Power Query so future edits stay in sync.
3. Basic documentation (a short note inside the file or a text document) explaining any formulas, named ranges, or query steps used.
Acceptance criteria
• No duplicate rows and no empty filler rows.
• Consistent date, text, and numeric formatting across all tabs.
• Sheet tabs clearly named and logically grouped.
• File opens without errors in Microsoft Excel 2016 + and Microsoft 365.
The job is complete when the workbook meets the above checks and I can filter, sort, or add new records without breaking the structure.
Scope of work
• Fix all inconsistent names, dates, and number formats so the data follows one clear standard.
• Remove every duplicate or blank row to leave only unique, meaningful records.
• Apply a tidy layout—clear headings, logical column widths, and a light color scheme—to make information pop at a glance.
• When the data is consistent and polished, split it into separate sheets based on category or type; the master sheet should remain intact for reference.
Deliverable
A single Excel workbook (.xlsx) containing:
1. A master sheet with corrected, deduplicated data.
2. One tab per category/type, automatically updated from the master through formulas or Power Query so future edits stay in sync.
3. Basic documentation (a short note inside the file or a text document) explaining any formulas, named ranges, or query steps used.
Acceptance criteria
• No duplicate rows and no empty filler rows.
• Consistent date, text, and numeric formatting across all tabs.
• Sheet tabs clearly named and logically grouped.
• File opens without errors in Microsoft Excel 2016 + and Microsoft 365.
The job is complete when the workbook meets the above checks and I can filter, sort, or add new records without breaking the structure.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.