You will get a clean, deduped, and formatted Excel data for analysis
Project details
I’m a Data Analyst with 10+ years of experience transforming raw, inconsistent data into clean and structured datasets using Excel, Power Query, and logic-based formulas.
In this gig, I will:
✅ Remove duplicates and blank rows
✅ Fix inconsistent formatting (e.g., country, payment method, dates)
✅ Clean whitespace, casing, and typos
✅ Organize your data to make it report-ready
✅ Add basic formulas (e.g., totals, derived fields)
✅ Prepare datasets for dashboards or Power BI if needed
BONUS (Standard & Premium only):
• Merge/clean data across sheets
• Add summary tables or pivot charts
• Use Power Query or automation
Whether it’s sales data, HR reports, or export files from systems - your Excel sheet will be delivered clean, validated, and ready for action.
In this gig, I will:
✅ Remove duplicates and blank rows
✅ Fix inconsistent formatting (e.g., country, payment method, dates)
✅ Clean whitespace, casing, and typos
✅ Organize your data to make it report-ready
✅ Add basic formulas (e.g., totals, derived fields)
✅ Prepare datasets for dashboards or Power BI if needed
BONUS (Standard & Premium only):
• Merge/clean data across sheets
• Add summary tables or pivot charts
• Use Power Query or automation
Whether it’s sales data, HR reports, or export files from systems - your Excel sheet will be delivered clean, validated, and ready for action.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$15
|
Standard
$35
|
Advanced
$60
|
|---|---|---|---|
| Delivery Time | 1 day | 1 day | 3 days |
Number of Revisions | 2 | 3 | 3 |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$20
2 reviews
(2)
(0)
(0)
(0)
(0)
This project doesn't have any reviews.
SB
Supriya B.
Feb 24, 2026
Small Business Automation - Google Forms + Google Sheets + Apps Script + Looker Studio
Sarika built a complete cashew business automation system for us - web forms for daily grading, packing, inward and outward stock tracking, all connected to Google Sheets with automatic calculations and a Looker Studio dashboard. The system is bilingual and works perfectly on mobile. She delivered across 3 milestones, each on time, and was always available to fix issues quickly. The solution has saved us hours of manual data entry every day. Highly recommend for Google Sheets/Apps Script automation work.
DC
Dr Vinod C.
Dec 9, 2025
Invoice PDF to CSV Converter - Secure Desktop Application
Excellent work on our invoice automation project! Sarika delivered a custom PDF to CSV converter that handles our GST invoices perfectly - multi-page support, automatic HSN code extraction, and smart vendor name detection.
The documentation was exceptional - detailed user guide, quick reference card, and troubleshooting guide made onboarding easy.
Communication was prompt, delivered exactly on time, and the software works well with our existing system.
Highly recommend for Python automation, data extraction, or business process automation projects.
Will definitely work together again!
The documentation was exceptional - detailed user guide, quick reference card, and troubleshooting guide made onboarding easy.
Communication was prompt, delivered exactly on time, and the software works well with our existing system.
Highly recommend for Python automation, data extraction, or business process automation projects.
Will definitely work together again!
About Sarika
Data Analyst | SQL Expert | Power BI Dashboards | Python, Excel
100%
Job Success
Toronto, Canada - 8:12 pm local time
Recent Project:
Built automated supply chain dashboard for healthcare organization using Google Apps Script + Looker Studio—reduced manual data processing by 90% (2 hours → 10 minutes daily) and enabled data-driven supplier decisions that saved ~15% on procurement costs.
🔹 What I Do
GOOGLE APPS SCRIPT AUTOMATION & GOOGLE SHEETS
- Google Sheets automation: Automated data imports from Google Drive, real-time data processing, status tracking, and workflow orchestration
- Apps Script development: Custom functions, time-based triggers for daily/weekly automation, automated data pipelines, error logging
- Google Drive integration: File monitoring, automated data extraction from uploaded files, folder organization, bulk file processing
- Looker Studio dashboards: Multi-source data connections, real-time KPIs, automated reporting, interactive visualizations
- Automated alert systems: Email notifications for critical thresholds, status updates, performance monitoring
- Data pipeline creation: Automated workflows connecting Google Drive → Google Sheets → Looker Studio with scheduled refreshes
DATA ANALYTICS, SQL & BUSINESS INTELLIGENCE
- SQL: Complex queries for data extraction and analysis (analyzed 1,200+ compliance records with 99.8% accuracy in past work)
- Google Sheets advanced formulas: QUERY, ARRAYFORMULA, VLOOKUP, XLOOKUP, SUMIFS, INDEX-MATCH, conditional logic
- Data analysis: Trend identification, KPI tracking, performance metrics, supplier/vendor analysis, conversion rate analysis
- Excel analytics: Power Query for data cleaning and transformation, pivot analysis, advanced formulas, conditional formatting
- Python: Data analysis with pandas, data cleaning, CSV/Excel file processing
- Pivot tables & data summarization: Multi-dimensional analysis, drill-down reporting, summary tables
DASHBOARD DEVELOPMENT & DATA VISUALIZATION
- Looker Studio: Interactive dashboards pulling from multiple Google Sheets sources, real-time metric tracking, executive KPI views
- Dashboard design: Executive summary pages, detailed operational views, automated alerts and notifications
- Multi-source integration: Combining data from multiple Google Sheets tabs, Drive files, and data sources into unified dashboards
- Google Sheets dashboards: Dynamic charts (line, bar, pie, donut), conditional formatting, summary tables, date filtering
- Power BI: Dashboard creation, data visualization, interactive reports, KPI tracking
- Real-time monitoring: Live data connections, auto-refresh capabilities, alert systems for critical metrics
DATA CLEANING & TRANSFORMATION
- Power Query: Data cleaning pipelines, deduplication, standardization, multi-source consolidation
- Google Sheets data prep: Format consistency, duplicate removal, null handling, data validation rules
- ETL processes: Extract data from various sources, transform for analysis, load into dashboard-ready format
🔹 Why Work With Me
I focus on building data solutions that your team can actually use and maintain—not complex systems that only I understand.
Every project includes:
✓ Clean, well-documented code with comments explaining the logic
✓ Handoff documentation so your team can update the solution
✓ Responsive communication (replies within 4 hours during business hours)
✓ Testing and error handling to ensure reliability
I explain technical concepts in plain language and make sure you understand how to use what I build. My goal is to make your job easier, not create dependency.
🔹 How I Work
1. Understanding: I ask questions to understand your exact needs and pain points
2. Planning: I outline the technical approach and confirm it matches expectations
3. Building: I develop the solution with regular progress updates
4. Testing: I test thoroughly with sample data before delivery
5. Handoff: I provide documentation and walkthrough for self-sufficiency
🔹 Skills & Tools
Google Apps Script | Google Sheets | Looker Studio | Google Drive API | SQL | Power BI | Dashboard Development | Data Analysis | Automation | Excel | Power Query | XLOOKUP | Pivot Tables | Data Visualization | Business Intelligence | Data Cleaning | ETL | Python
Let's automate your workflows and build data-driven solutions that save time and improve decision-making. Message me to discuss your project.
Steps for completing your project
After purchasing the project, send requirements so Sarika can start the project.
Delivery time starts when Sarika receives requirements from you.
Sarika works on your project following the steps below.
Revisions may occur after the delivery date.
Review & Understand Requirements
I will review your Excel file and requirements to identify formatting issues, data quality gaps, and logic/formula needs. Any clarifications will be requested upfront.
Clean, Deduplicate, and Format Data
I will clean your dataset by removing duplicates, fixing inconsistent values, standardizing formats, and applying formulas or logic where needed.