Report Formats

Send a polished PDF to a buyer, a spreadsheet to an analyst, or a CSV to another system. One report, in whichever format its reader needs.

Format is a single dropdown in the Create Report dialog. Your Report Property Set and selections carry over when you switch, apart from what a format cannot hold, and some options only apply to certain formats.

The same report as a PDF, an XLSX workbook, and a CSV.

Which Format to Choose

If you need toChooseWhy
Present to a buyer in a line reviewPDF (Side-by-Side)The fixture stays in view beside the data on every page
Print a finished plan or send it to storesPDF (Portrait)Each section's image gets a full page, followed by its tables
Fit wide fixtures or reports with many PropertiesPDF (Landscape)The Portrait layout, with more width
Work through the data section by sectionXLSXEach report section gets its own sheet
Sort or pivot the whole report at onceXLSX (Single Sheet)Every section sits on one sheet
Load Position data into another systemCSVPlain rows and the smallest file
Feed a dashboard or BI toolJSONRaw report data through the Web API

Comparing the Formats

FormatPlanogram imagesAggregatesBreakdownsReport sections
PDF (Portrait)YesYesTables and chartsEach starts on a new page
PDF (Landscape)YesYesTables and chartsEach starts on a new page
PDF (Side-by-Side)YesYesTables and chartsEach starts on a new page
XLSXNoYesTablesOne sheet per section
XLSX (Single Sheet)NoYesTablesOne sheet, with section sub-headers
CSVNoYes, after the rowsNoRows run together

Report sections come from the Breaks setting. Each format's options, such as Coversheet or Include Logo, are listed in Creating a Report.

PDF Formats

All three PDF formats carry the same data. They differ only in how each section is laid out on the page.

  • PDF (Portrait) puts the section image on its own page, then the report tables after it.
  • PDF (Landscape) is the same layout in landscape orientation, which suits wide fixtures and reports with many Properties.
  • PDF (Side-by-Side) is landscape with the section image repeated down the left half of every page and the report content on the right half, so the fixture stays in view no matter how long the table runs.
PDF (Portrait)
PDF (Landscape)
PDF (Side-by-Side)

PDFs are the only format that embeds the planogram images previewed in the dialog, and the only one that renders Breakdowns as charts. Most report options apply only to PDFs as well, since they need a page to live on.

A Breakdown in a PDF report: each category's share of square footage and of weekly sales, as a table and a bar chart
A PDF page header with the Plan name, section and page counts, and Header Notes on the right

XLSX

XLSX reports contain the same Properties, Aggregates, and Breakdown tables as a PDF, without images or charts, in a workbook you can sort, filter, and pivot. Header and accent colors let reports match your own template.

The two XLSX formats differ only in how sections are arranged. Plain XLSX gives each report section its own sheet. XLSX (Single Sheet) puts every section on one sheet, which is what you want when you intend to sort or pivot across the whole report.

Sample XLSX report with Aggregates, and a Breakdown comparing each category's share of square footage to its share of weekly sales

CSV

CSV is a plain table of Properties, one row per Position, which makes it the smallest file and the easiest to load into another system. It carries no Breakdowns, images, or formatting, and the dialog disables Breakdowns while CSV is selected.

Any Aggregates you leave checked are written after the Position rows, separated by a blank line. If the system reading the file expects a single table, uncheck them.

Rows from different report sections run together, with no section markers. To keep sections apart, set Breaks and enable One File Per Section.

JSON

JSON is for reports read by another system rather than a person: a dashboard, a BI tool, or your own reporting pipeline. It comes from the Web API, which can hand back the report data directly instead of a file, and it does not appear in the Format dropdown unless it is enabled for your site.

You choose the Report Property Set, Breaks, and options the same way, so a report you designed in the dialog can be pulled as raw JSON without rebuilding it. When someone needs to open and read the report, use one of the file formats above.

Every format on this page, not just JSON, can be generated programmatically. See the Web API documentation. API access is included with the Professional package and above.
GoPlanogram Logo GoPlanogram Copyright 1998-2026 Northwoods Software