Definition of Pivot Table A pivot table is a data analysis tool that allows you to reorganize and analyze your data in a new way. With pivot tables, you can group and summarize data by column, or calculate new values based on existing data.