Tabular Report
A Tabular Report is the simplest of the four Salesforce report formats.
Definition
A Tabular Report is the simplest of the four Salesforce report formats. It returns a flat list of records, one record per row, with the fields you selected as columns. Tabular reports look and behave like a spreadsheet view of the filtered data.
The format has no grouping logic, no summary calculations, and no row-group totals. Tabular reports are the right choice when the question you are answering is "show me these records" rather than "summarize these records by something." Their simplicity is their value: they are the fastest report format to build, the cheapest to render, and the easiest to export to CSV or Excel.
When to pick the simplest Salesforce report format
Where tabular sits in the four Salesforce report formats
Salesforce reports come in four formats: Tabular, Summary, Matrix, and Joined. Tabular is the floor. Summary adds one row-grouping dimension and shows subtotals for each group. Matrix adds a second column-grouping dimension to produce a cross-tab. Joined glues multiple report blocks together that can use different report types. Each step up the stack adds aggregation and computation cost. Pick tabular when you only need rows. Pick summary the moment you need any subtotal or chart.
When tabular is the right answer
Tabular reports fit a small set of clear use cases. The first is data export: a tabular report is the cleanest path to a CSV of filtered records for a downstream tool or spreadsheet. The second is operational lists that humans work from: overdue invoices to chase, leads to call today, cases waiting for a response. The third is fast counts: a tabular report run with the Total Records footer turned on gives you a quick row count without paying aggregation cost. If your question is "how many" or "which records," tabular is the answer.
When to upgrade to summary, matrix, or joined
Tabular reports lose their advantage the moment you need grouping. If the question becomes "how many leads per region" or "revenue by industry by quarter," tabular forces you to read the raw rows and do the math in your head. Summary reports answer the "per X" question with subtotals and a chart. Matrix answers the "X by Y" cross-tab question. Joined answers questions that need data from two unrelated report types side by side. Converting tabular to summary in Lightning Report Builder is a single drag: drop a field on the Group Rows shelf and the format switches.
Charts and dashboards: what tabular cannot do without a row limit
A pure tabular report has no chart support because there is nothing to chart without a grouping. The exception is the Row Limit feature: if you set a tabular report to return a fixed top N rows and choose a Dashboard Settings filter, the report can power a dashboard component as a simple Top N list. This is the standard pattern for "top 10 deals" or "5 oldest open cases" widgets. Without the row limit, tabular reports cannot be used as the source for most dashboard component types, and Lightning Report Builder will refuse to save the dashboard widget until the row limit is configured.
Reporting Snapshot compatibility
A Reporting Snapshot copies the rows from a tabular report into records of a custom object on a schedule. Snapshots require a tabular source report because they need a flat row structure to map fields one-to-one into the target object's columns. Summary and Matrix reports cannot be used as snapshot sources. If you need to track a metric over time, the working pattern is a tabular source report, a custom object as the target, and a daily or weekly snapshot job that builds the historical record. The snapshot job copies whatever the tabular report would return on the schedule's run time, so design the source report with that frozen view in mind. Add a Date Recorded field on the target object so each run leaves a timestamp on the rows it inserted, otherwise you lose the ability to chart trends from the snapshot output.
Limits, performance, and large exports
A tabular report shows up to 2,000 rows in the Lightning report viewer before it truncates. Exporting the report raises the ceiling. The Formatted Excel export tops out at 25,000 rows; the Details Only CSV export tops out at 100,000 rows. Bulk pulls beyond those caps need the Reports API or a data warehouse export. Tabular reports themselves are fast to render because they do not aggregate. The bottleneck is usually the number of fields selected, not the number of rows. Wide tabular reports with 30 or more columns take longer to render and export, so trim columns to what the consumer actually uses.
How Lightning Report Builder changed format selection
In Classic, the four report formats were selected from an explicit dropdown at the top of the Report Builder. In Lightning Report Builder, the format follows the structure: a report with no groupings is tabular, a report with row groupings is summary, a report with both row and column groupings is matrix. There is no format selector. The behaviour is the same; the affordance changed. Classic reports converted to Lightning preserve their original format. Tabular reports built years ago still run the same way they did in Classic, and your existing Reporting Snapshots and dashboards continue to work without rework.
Build a tabular report
A tabular report is the fastest report format to build in Salesforce. The steps below cover the common path from a blank report to an exportable list.
- Pick a report type
Open Reports, click New Report, pick the report type that exposes the object and fields you need. A tabular report can use any standard or custom report type.
- Add filters before columns
Add filters first to narrow the row count. Common filters are a date range, a status, a record owner, an Active = true flag. Tight filters cut render and export time significantly on large objects.
- Add the columns you want
Drag fields from the Fields panel to the Columns shelf. Order matters for export readability. Keep the column count modest because wide reports are slow to render and slower to export.
- Run, then refine
Click Run to see the rows. Sort by a column header. Add or remove filters until the result is what the consumer of the report actually needs. Save with a descriptive name and a folder shared to the right audience.
- Export or schedule
Use Export from the report toolbar for ad-hoc CSV downloads. For recurring delivery, subscribe the report to a schedule so the list arrives in the inbox of the people who use it daily.
Caps the number of rows the report returns. Required when you want to use the tabular report as the source for a dashboard component.
Available only on summary, matrix, and joined formats. Not available on tabular because there are no aggregate values to colour-code.
Always on for tabular reports. There are no subtotal rows to hide, so the Detail Rows toggle has no effect.
- Tabular reports cannot power most dashboard components without a row limit. The Lightning Report Builder refuses to save a dashboard widget from a tabular source unless the row limit is set.
- The 2,000-row viewer cap is just the in-browser viewer. The export limits (25,000 formatted or 100,000 details-only) are the real ceilings. For larger pulls, use the Reports API or a data warehouse export.
- Reporting Snapshots require tabular source reports. Summary or matrix snapshots silently fail with a configuration error. Always check the source format before setting up a snapshot.
Trust & references
Cross-checked against the following references.
- Tabular ReportsSalesforce Help
- Group Records in a ReportSalesforce Help
- Export a ReportSalesforce Help
- Limit Rows in a Tabular ReportSalesforce Help
Straight from the source - Salesforce's reference material on Tabular Report.
- Tabular ReportsSalesforce Help
- Build a Report in Lightning ExperienceSalesforce Help
Hands-on resources to go deeper on Tabular Report.
About the Author
Dipojjal Chakrabarti is a B2C Solution Architect with 29 Salesforce certifications and over 13 years in the Salesforce ecosystem. He runs salesforcedictionary.com to help admins, developers, architects, and cert/interview candidates sharpen their fundamentals. More about Dipojjal.
Test your knowledge
Q1. What is a Tabular Report?
Q2. Does it support charts?
Q3. When use tabular?
Discussion
Loading discussion…