Pivot Table

What Does Pivot Table Mean?

A pivot table is a data processing tool used to query, organize and summarize data or information between spreadsheets, tables or databases. Dragging and dropping fields into a pivot table facilitates rotational, or pivotal, structural changes.


The generic pivot table term is used by many companies and software vendors. PivotTable, Microsoft branded and trademarked version, is used in most Excel products.

Techopedia Explains Pivot Table

A pivot table is useful when analyzing a large amount of data, as it allows users to apply specific criteria to summarize, organize and reorganize data tables and create reports.

For example, when a store manager reviews the sales of a specific item over a six-month period, he must sift through many pages of relevant and irrelevant data. A pivot table, however, simplifies this process by automatically counting, summarizing and sorting data. Summarized data may then be used to create a report tailored to the item’s activity within the specified six-month parameter, reducing data output and table columns and rows. This process may be used to accommodate various data requirements.


Related Terms

Latest Data Management Terms

Related Reading

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…