To use a pivot table in mobile Excel, open the Excel app on iOS or Android, access a file from OneDrive and tap an existing pivot table to filter, refresh or collapse rows. To create one from scratch, go to Insert > PivotTable — this requires a Microsoft 365 Personal subscription or higher.
That covers the core of how to use pivot table in mobile Excel, but the full picture is broader. Pivot tables now work across Excel Online, Apple Numbers, LibreOffice and even inside web apps and Java systems. Here is what each platform supports and how to get the most out of each one.
- Excel Online supports pivot tables in any modern browser, free with a Microsoft account.
- Mobile Excel (iOS and Android) lets you view and edit existing pivot tables; creating one from scratch requires a Microsoft 365 subscription.
- Apple Numbers has pivot tables as of version 12.2 (macOS Monterey onwards), though the feature set is simpler than Excel’s.
- LibreOffice/OpenOffice calls its equivalent feature a DataPilot, which works well for offline, open-source workflows.
- Developers can generate pivot tables programmatically using Apache POI (Java), UiPath (RPA) or embed interactive pivot grids using Flexmonster.
Excel Online and Mobile Pivot Tables
Excel for the web has come a long way. You open your browser, sign in with a Microsoft account, upload a spreadsheet and insert a pivot table exactly as you would on desktop: select your data range, go to Insert > PivotTable, choose a new sheet and start dragging fields. The interface mirrors desktop Excel closely enough that anyone already familiar with the desktop version can pick it up in minutes. Learning how to use a pivot table in Excel Online is essentially the same skill as learning it on desktop.
One practical tip: if your data lives in OneDrive or SharePoint, Excel Online will auto-save every change, which means your pivot table refreshes are preserved without any manual file management. That is genuinely useful for teams collaborating across different cities, which is increasingly common in Indian IT and analytics firms.
How to Use a Pivot Table in Mobile Excel
Understanding how to use pivot table in mobile Excel starts with knowing what the app can and cannot do. On an iPhone or Android phone, you can open a file containing a pivot table and interact with it: collapse rows, expand groups, change the filter selection. What you cannot do easily on a small screen is build a complex pivot from scratch, because the field list panel is cramped.
Here is the practical workflow most analysts use when working with a pivot table in mobile Excel on the job:
- Build the pivot table structure on desktop or Excel Online first.
- Save the file to OneDrive.
- Open the Excel mobile app, tap the pivot table and use the Refresh button after updating the source data.
- Use the filter dropdowns to slice the view by region, date or product without touching the field layout.
If you do want to use a pivot table in mobile Excel on a tablet — an iPad with a keyboard attached, for instance — go to Insert > PivotTable in the mobile app. You will need an active Microsoft 365 subscription; the free app version only allows viewing. According to Microsoft’s own product documentation, pivot table creation on mobile requires Microsoft 365 Personal or higher.
According to LinkedIn’s Jobs on the Rise 2024 report, data analysts rank among the top ten fastest-growing job categories in India, with Excel proficiency listed as a baseline requirement in the majority of those postings. Knowing how to use pivot table in mobile Excel and in the browser extends that skill to wherever you are working.
Excel Online vs Desktop: What Is Actually Different
| Feature | Desktop Excel | Excel Online | Excel Mobile |
|---|---|---|---|
| Create pivot table | Yes | Yes | Yes (M365 required) |
| Calculated fields | Yes | Limited | No |
| Slicers | Yes | Yes | View only |
| GETPIVOTDATA formula | Yes | Yes | No |
| Power Pivot / Data Model | Yes | No | No |
| Offline access | Yes | No | Yes (cached files) |
The gap between Online and Desktop is shrinking with every Microsoft update, but Power Pivot and Data Model support remain desktop-only as of 2025. If your work involves millions of rows or complex DAX measures, desktop Excel is still the right tool. For most day-to-day reporting, though, the browser version is genuinely sufficient — and the mobile version handles pivot table in Excel on the go for viewing and refreshing without any issues.
Pivot Tables in Numbers and OpenOffice
Not everyone works in the Microsoft ecosystem, and that is fine. Both Apple Numbers and LibreOffice/OpenOffice offer pivot-style functionality, though each comes with its own quirks.
How to Do a Pivot Table in Numbers
Apple Numbers added pivot tables in version 12.2, released alongside macOS Monterey in 2021. If you are on an older version, you will not see the option at all, so update first. Here is how to create one:
- Select any cell inside your data table.
- Go to Organize > Create Pivot Table from the top menu.
- Choose whether you want the pivot on a new sheet or the current sheet.
- In the Pivot Options panel on the right, drag fields into Columns, Rows and Values.
- Click a value field and choose the aggregation: Sum, Count, Average, Min or Max.
Numbers pivot tables do not support calculated fields, slicers or the equivalent of GETPIVOTDATA. They are clean and visually polished, which fits the Numbers aesthetic, but they are not a replacement for Excel if your analysis is complex. For students or freelancers working on a Mac who just need quick summaries of sales data or survey results, they work perfectly well.
How to Use a Pivot Table in OpenOffice (DataPilot)
LibreOffice Calc and Apache OpenOffice Calc both call their pivot table feature a DataPilot. The name is different but the concept is identical. To create one:
- Select your data range.
- Go to Data > Pivot Table > Insert or Edit (LibreOffice) or Data > DataPilot > Start (OpenOffice).
- In the dialog box, drag fields from the field list into Row Fields, Column Fields and Data Fields.
- Double-click a Data Field to set the aggregation function.
- Click OK. The pivot table appears on a new sheet.
One common mistake: OpenOffice DataPilot does not auto-refresh when the source data changes. You have to right-click the pivot table and select Refresh manually, every time. Forgetting this step leads to reports that look current but are not, which is a real problem in a professional setting.
LibreOffice is the more actively maintained fork and is generally recommended over OpenOffice for new users. According to NASSCOM’s Technology Sector in India 2024 report, analytics and data engineering roles account for five of the top talent shortfall categories in India’s tech sector, with open-source tool proficiency increasingly listed as a requirement in Indian SMEs and government IT departments where proprietary software licensing costs are a constraint.
Programmatic Pivots: Java and UiPath
Sometimes you do not want to click through a UI at all. If you are generating reports automatically, building a data pipeline or automating a repetitive Excel task for a client, you will want to create pivot tables programmatically. Two tools come up constantly in this context: Apache POI for Java developers and UiPath for RPA (Robotic Process Automation) teams.
How to Create a Pivot Table in Excel Using Java
Apache POI is the standard open-source Java library for reading and writing Microsoft Office files. It supports .xlsx files through its XSSF module, and it does support pivot table creation, though the API is lower-level than what you would use in Python’s openpyxl. Here is the basic approach:
- Add the Apache POI dependency to your Maven or Gradle project (current stable version: 5.2.5 as of early 2025).
- Create an
XSSFWorkbookand populate a sheet with your source data. - Define the data reference using
AreaReferenceandCellReference. - Call
sheet.createPivotTable(dataRange, position)to instantiate anXSSFPivotTableobject. - Use
addRowLabel(),addColumnLabel()andaddColumnLabel(DataConsolidateFunction.SUM, colIndex)to define the pivot structure. - Write the workbook to a file output stream.
The resulting .xlsx file opens in Excel with the pivot table intact and ready to refresh. This approach is common in Java-based enterprise reporting systems, particularly in banking and insurance sectors where Java backends generate Excel reports for relationship managers. If you are building those kinds of systems, check out our guide to software development tools to learn first for a broader picture of what belongs in your stack.
How to Create a Pivot Table in Excel Using UiPath
UiPath is an RPA platform, not a programming language, so its approach is different. Rather than writing code to manipulate an Excel file directly, UiPath automates the Excel application itself, or uses its built-in Excel activities to interact with workbooks. There are two main methods:
Method 1: Using UiPath’s Excel Activities (StudioX or Studio). The Excel Process Scope activity opens a workbook. Inside it, you can use the Create Pivot Table activity (available in UiPath.Excel.Activities package 2.11+) to define source range, destination sheet, row fields, column fields and value fields without writing a single line of code.
Method 2: Invoking VBA via UiPath. If you need more control, use the Invoke VBA activity to run a macro that builds the pivot table. You write the VBA once, store it as a .vbs file, and UiPath calls it on demand. This is the approach most UiPath developers use when the built-in activity does not support a specific pivot option.
A common real-world scenario: an operations team in a Mumbai-based logistics company runs a UiPath bot every morning that pulls yesterday’s delivery data from an ERP system, pastes it into a template Excel file and creates a pivot table summarising deliveries by city and status. The bot emails the finished report to managers by 8 AM, with no human intervention. That is the practical value of combining UiPath with Excel pivot tables.
If you are curious about the broader automation space, our article on Python for automation, web scraping and APIs covers the scripting side of the same problem.
Web Pivot Components: Flexmonster
Flexmonster is a JavaScript pivot table and charts library designed for embedding interactive pivot grids directly into web applications. If you are building a business intelligence dashboard in React, Angular or plain HTML, Flexmonster lets you give end-users a full pivot table experience inside the browser without requiring them to export data to Excel at all.
What Flexmonster Pivot Table and Charts Actually Does
The library connects to JSON data, CSV files, SQL databases or OLAP cubes (like Microsoft Analysis Services). Users can drag fields, apply filters, switch between table and chart views and export results to Excel or PDF, all inside your web app. It is commercially licensed, with a free trial available on the Flexmonster website.
A typical integration in a React app looks like this: you install the react-flexmonster package, import the FlexmonsterReact component, pass your data source URL and a toolbar configuration, and the pivot grid renders with full interactivity. Developers building internal analytics tools for mid-size Indian SaaS companies have used this exact approach to avoid the cost of embedding a full BI tool like Power BI or Tableau.
Speaking of which, if you are weighing your options on the BI side, our comparison of Power BI vs Tableau covers which tool makes more sense for different career paths.
When to Use Flexmonster vs a BI Tool
| Criterion | Flexmonster | Power BI Embedded |
|---|---|---|
| Integration effort | Low (JavaScript component) | Medium (Azure setup required) |
| Licensing cost | One-time developer license | Per-user or capacity pricing |
| Data volume | Best under 1 million rows | Scales to very large datasets |
| Offline capability | Yes (client-side rendering) | No |
| Custom branding | Full control | Limited in embedded mode |
Flexmonster makes the most sense when you are a developer who needs a drop-in pivot component and does not want to manage a full BI platform. It is not a replacement for Power BI or Tableau when your organisation needs centralised data governance, but for embedded reporting in a custom app, it is a practical and cost-effective choice.
All of this connects to a broader point about data skills. According to NASSCOM’s Technology Sector in India 2024 report, analytics and data engineering roles face a talent shortfall of over 200,000 professionals in India’s tech sector, making these among the most in-demand skills in the country. Whether you are using Excel Online, writing Java with Apache POI or embedding Flexmonster in a React dashboard, these are skills that employers are actively looking for. You can explore what else belongs in that skill set through our overview of the highest paying tech skills for 2026.
If you are deciding whether to specialise in analysis or engineering, our breakdown of data analyst vs data scientist roles explains where pivot table skills sit in each career path. And if you want to put these skills to use on real problems, our list of data analytics projects gives you concrete starting points.
Frequently Asked Questions
Can I make a pivot table in Excel Online?
Yes. Excel Online supports pivot table creation directly in the browser. Select your data, go to Insert, choose PivotTable, and the field list panel appears on the right. Most core features work, though advanced options like Power Pivot and calculated fields are only available in the desktop version of Excel.
How do I use a pivot table in mobile Excel?
To use a pivot table in mobile Excel, open a file from OneDrive in the Excel app on iOS or Android. You can interact with existing pivot tables, apply filters and refresh data. Creating a new pivot table from scratch on mobile requires a Microsoft 365 subscription. Building the structure on desktop first, then using mobile for viewing and refreshing, is the most practical workflow for using a pivot table in mobile Excel day to day.
Does Apple Numbers have pivot tables?
Yes, Apple Numbers has supported pivot tables since version 12.2, released with macOS Monterey in 2021. You create them through the Organize menu. The feature is simpler than Excel’s, with no calculated fields or slicers, but it covers basic summarisation tasks like summing sales by category or counting responses by region.
How do I create a pivot table in Excel using Java?
Use the Apache POI library, specifically the XSSF module for .xlsx files. Create an XSSFWorkbook, populate a data sheet, then call sheet.createPivotTable() with an AreaReference defining your source range. Use the addRowLabel() and addColumnLabel() methods on the returned XSSFPivotTable object to define the pivot structure, then write the workbook to a file.
Can UiPath create pivot tables in Excel?
Yes. UiPath can create pivot tables using the built-in Create Pivot Table activity in the UiPath.Excel.Activities package (version 2.11 and above), where you configure fields without writing code. Alternatively, you can use the Invoke VBA activity to run a custom macro that builds the pivot table, which gives more control over formatting and structure.
How do I use a pivot table in Excel on an iPad?
To use a pivot table in Excel on an iPad, open the Excel mobile app and access your file from OneDrive. With a Microsoft 365 subscription, you can go to Insert > PivotTable to create one. Using an iPad with a keyboard attached makes the experience much closer to desktop Excel, as the field list panel is easier to navigate on a larger screen.
The practical takeaway from all of this is that pivot tables are not tied to desktop Excel anymore. Whether you are analysing data in a browser, using a pivot table in mobile Excel, automating reports with UiPath, building a web app with Flexmonster or writing Java for an enterprise system, the core skill of structuring and summarising data in a pivot carries across every tool.
Here are three things you can do this week to move forward:
- Open Excel Online with a real dataset (your own sales data, a downloaded CSV from data.gov.in, anything) and build a pivot table from scratch in the browser. It takes ten minutes and proves to yourself that the skill transfers.
- If you are a developer, clone the Apache POI samples repository from GitHub and run the pivot table example against a test spreadsheet. Seeing the output file open correctly in Excel makes the API click.
- Explore where data skills lead next. Analysts who can build and interpret pivot tables are increasingly being recruited into security operations roles, where filtering event logs and spotting anomalies in data is daily work. If that direction interests you, look at the EC-Council Certified SOC Analyst course at 3.0 University, which builds exactly those analytical instincts in a cybersecurity context. You can also browse the full catalogue of 3.0 University online certification courses in AI, Blockchain, Ethical Hacking and more to find what fits your goals.
Last updated: October 2026. Reviewed by the 3University editorial team.