Can LLMs Clean Up Your Mess? A Survey of Application-Ready Data Preparation with LLMs
Data preparation aims to denoise raw datasets, uncover cross-dataset relationships, and extract valuable insights from them, which is essential for a wide range of data-centric applications. Driven by (i) rising demands for application-ready data (e.g., for analytics, visualization, decision-making), (ii) increasingly powerful LLM techniques, and (iii) the emergence of infrastructures that facilitate flexible agent construction (e.g., using Databricks Unity Catalog), LLM-enhanced methods are rapidly becoming a transformative and potentially dominant paradigm for data preparation.
  By investigating hundreds of recent literature works, this paper presents a systematic review of this evolving landscape, focusing on the use of LLM techniques to prepare data for diverse downstream tasks. First, we characterize the fundamental paradigm shift, from rule-based, model-specific pipelines to prompt-driven, context-aware, and agentic preparation workflows. Next, we introduce a task-centric taxonomy that organizes the field into three major tasks: data cleaning (e.g., standardization, error processing, imputation), data integration (e.g., entity matching, schema matching), and data enrichment (e.g., data annotation, profiling). For each task, we survey representative techniques, and highlight their respective strengths (e.g., improved generalization, semantic understanding) and limitations (e.g., the prohibitive cost of scaling LLMs, persistent hallucinations even in advanced agents, the mismatch between advanced methods and weak evaluation). Moreover, we analyze commonly used datasets and evaluation metrics (the empirical part). Finally, we discuss open research challenges and outline a forward-looking roadmap that emphasizes scalable LLM-data systems, principled designs for reliable agentic workflows, and robust evaluation protocols.
69782c96026bdf0473116e06
Wei Zhou
admin_assigned
2026-01-27T13:59:49.701Z
68216c63856b96f869d1d116
/avatars/f69026ca75377e6754ab3e317879e35a.svg
Wei Zhou
weizhoudb
user
weizhoudb
69782c96026bdf0473116e07
Jun Zhou
claimed_verified
2026-01-28T11:31:17.742Z
671a48d6813e62cf4afe78ca
/avatars/d604a1a5f3d4e34a71f6eaa99ea8819b.svg
Jun Zhou
superZJ827
user
superZJ827
69782c96026bdf0473116e08
Haoyu Wang
69782c96026bdf0473116e09
Zhenghao Li
69782c96026bdf0473116e0a
Qikang He
69782c96026bdf0473116e0b
Shaokun Han
69782c96026bdf0473116e0c
Guoliang Li
69782c96026bdf0473116e0d
Xuanhe Zhou
admin_assigned
2026-01-27T13:58:19.930Z
64ef522242da8d2a897d62da
/avatars/03611010d247da66696ac8976d4d3ed3.svg
xuanhe zhou
zhouxh19
user
zhouxh19
69782c96026bdf0473116e0e
Yeye He
admin_assigned
2026-01-27T13:58:27.638Z
674fa2f067c963c50a066594
https://cdn-avatars.huggingface.co/v1/production/uploads/674fa2f067c963c50a066594/hKZ46Mwm_UEguzBt63ys_.jpeg
yeye he
yeyehe
user
yeyehe
69782c96026bdf0473116e0f
Chunwei Liu
claimed_verified
2026-01-28T11:31:20.083Z
660b696648408366ccc79665
/avatars/956a19efe491b506b742010ac36736ef.svg
Chunwei Liu
Tranway
user
Tranway
69782c96026bdf0473116e10
Zirui Tang
admin_assigned
2026-01-27T13:58:49.525Z
66724ce47e7ff5d8bd069c7c
/avatars/953f66585390dbdb202c1d7b7250d7bd.svg
Zirui Tang
TerryTang
user
TerryTang
69782c96026bdf0473116e11
Bin Wang
69782c96026bdf0473116e12
Shen Tang
admin_assigned
2026-01-27T13:58:56.579Z
695612aabf3c8959a3a05f9c
/avatars/c18885f6dea6f3ee019405cd8cf6f484.svg
ShenTang990
shentang
user
shentang
69782c96026bdf0473116e13
Kai Zuo
69782c96026bdf0473116e14
Yuyu Luo
admin_assigned
2026-01-27T13:59:02.233Z
67efa8a2ed790a2e999dc216
https://cdn-avatars.huggingface.co/v1/production/uploads/no-auth/0S4lQCJX61uCF8EkSLMkk.png
Yuyu Luo
luoyuyu
user
luoyuyu
69782c96026bdf0473116e15
Zhenzhe Zheng
69782c96026bdf0473116e16
Conghui He
admin_assigned
2026-01-27T13:57:14.525Z
63f9fca8d4349b157a109eec
/avatars/fa1f2ae7972d7cde99dab178136ccbb0.svg
Conghui He
conghui
user
conghui
69782c96026bdf0473116e17
Jingren Zhou
69782c96026bdf0473116e18
Fan Wu
Can LLMs Clean Up Your Mess? A Survey of Application-Ready Data Preparation with LLMs
Data preparation aims to denoise raw datasets, uncover cross-dataset relationships, and extract valuable insights from them, which is essential for a wide range of data-centric applications. Driven by (i) rising demands for application-ready data (e.g., for analytics, visualization, decision-making), (ii) increasingly powerful LLM techniques, and (iii) the emergence of infrastructures that facilitate flexible agent construction (e.g., using Databricks Unity Catalog), LLM-enhanced methods are rapidly becoming a transformative and potentially dominant paradigm for data preparation.
  By investigating hundreds of recent literature works, this paper presents a systematic review of this evolving landscape, focusing on the use of LLM techniques to prepare data for diverse downstream tasks. First, we characterize the fundamental paradigm shift, from rule-based, model-specific pipelines to prompt-driven, context-aware, and agentic preparation workflows. Next, we introduce a task-centric taxonomy that organizes the field into three major tasks: data cleaning (e.g., standardization, error processing, imputation), data integration (e.g., entity matching, schema matching), and data enrichment (e.g., data annotation, profiling). For each task, we survey representative techniques, and highlight their respective strengths (e.g., improved generalization, semantic understanding) and limitations (e.g., the prohibitive cost of scaling LLMs, persistent hallucinations even in advanced agents, the mismatch between advanced methods and weak evaluation). Moreover, we analyze commonly used datasets and evaluation metrics (the empirical part). Finally, we discuss open research challenges and outline a forward-looking roadmap that emphasizes scalable LLM-data systems, principled designs for reliable agentic workflows, and robust evaluation protocols.
LLM-enhanced data preparation methods are transforming data-centric workflows from rule-based pipelines to prompt-driven, context-aware approaches, organized into data cleaning, integration, and enrichment tasks.
data preparation large language models prompt-driven workflows agentic workflows data cleaning data integration data enrichment entity matching schema matching data annotation data profiling