🌾ruralreach.club
0 complete
Log InCreate Free Account
Home › 10. Automation, Agents & Advanced Projects › Create a Data Cleanup and Analysis Mini-Project (Spreadsheet)

Create a Data Cleanup and Analysis Mini-Project (Spreadsheet)

10. Automation, Agents & Advanced Projects ⏱ 25 minutes min 📊 Intermediate

Objective

Use AI to clean messy spreadsheet data and pull out simple insights.

Materials Needed

  • AI chat tool with file upload
  • A messy sample spreadsheet (sales list, contact list, or expense list)

Step-by-Step Instructions

  1. 1

    Upload a messy spreadsheet (duplicate entries, inconsistent formatting, missing values).

  2. 2

    Prompt: 'Clean this data: fix formatting, flag duplicates, and note any missing values.'

  3. 3

    Ask the AI to summarize 3 key insights from the cleaned data (top category, total, trend).

  4. 4

    Ask for one simple chart or table to visualize the findings.

  5. 5

    Download the cleaned file and compare it to the original.

Instructor TipBring an intentionally messy sample file so the 'before and after' is dramatic and the value is obvious.
TakeawayAI can turn hours of manual spreadsheet cleanup into a few minutes of guided prompting.

Tools Used

  • ChatGPT
  • Claude.ai
  • Gemini