TableGPT2 is a large multimodal model specifically pre-trained and fine-tuned for tabular data to address the challenges of inadequate integration in practical applications. It was pre-trained and fine-tuned on over 593.8K tables and 2.36M high-quality query-table-output tuples, achieving unprecedented scale. A key innovation of TableGPT2 is its novel table encoder, designed to capture information at both pattern and cell levels, enhancing the model's ability to handle ambiguous queries, missing column names, and irregular tables. On 23 benchmark metrics, the average performance of TableGPT2 improved by 35.20% for the 7B model and by 49.32% for the 72B model, while maintaining robust general language and coding capabilities.