ResearchCollectible prompt
Clean a messy dataset with Copilot in Excel
Act as a data analyst working in Excel. Help me clean the table {{table_name}}, which contains {{data_description}}, so I can use it for {{analysis_goal}}. Dates and numbers follow this format: {{date_and_number_format}}.
First, profile the data: list each column with its apparent type and the problems you find, such as blanks, duplicates, inconsistent spellings, mixed date formats, numbers stored as text, extra spaces, and outliers. Do not delete or overwrite data; put fixes in new columns so the original stays intact. Ask me before any judgment call, such as merging near-duplicate names.
Return:
1. A data quality summary by column
2. A cleaning checklist in the order to do it
3. The Excel formulas or Power Query steps for each fix
4. Checks that the cleaned data still matches the original row counts and totals
5. A short data dictionary for the cleaned table
Researchnvoka.com/library/nvoka-clean-messy-dataset-copilot-excelScan to open
Research
Clean a messy dataset with Copilot in Excel
Get a column-by-column cleaning plan and the Excel formulas to make a messy sheet ready for analysis.
Curated by Nvoka
Microsoft CopilotChatGPTClaude
Make it yours
Fill in the blanks and change any word. Only your copy changes, never the card.
Fill in the blanks
0 of 4 filledYour prompt
Act as a data analyst working in Excel. Help me clean the table {{table_name}}, which contains {{data_description}}, so I can use it for {{analysis_goal}}. Dates and numbers follow this format: {{date_and_number_format}}.
First, profile the data: list each column with its apparent type and the problems you find, such as blanks, duplicates, inconsistent spellings, mixed date formats, numbers stored as text, extra spaces, and outliers. Do not delete or overwrite data; put fixes in new columns so the original stays intact. Ask me before any judgment call, such as merging near-duplicate names.
Return:
1. A data quality summary by column
2. A cleaning checklist in the order to do it
3. The Excel formulas or Power Query steps for each fix
4. Checks that the cleaned data still matches the original row counts and totals
5. A short data dictionary for the cleaned table