Exporting Bidirectional Data (Manual & Auto Export)
What bidirectional PAN-42 data looks like in your CSV exports, and how to add the Export energy counter.
- Getting Started
- Dashboard
- TimeView
- Energy Apps
- Alerts & Notifications
- Reports
- Administration & Settings
- Partners
- Import & Exports
- Mobile App
- Plans & Packages
- Security & Certification
- Deployment
- Hardware Manuals
- Datasheets & Specs
- Frequently Asked Questions (FAQ)
- Legal
- What’s New
- Bidirectional-Power
- Energy Star Portfolio Manager
- Panoramic AI
Table of Contents
What Is Bidirectional Power?
Quick refresher
A bidirectional PAN-42 sensor measures power in both directions:
- Import - power drawn from the grid. Shown as positive.
- Export - power sent back to the grid, for example solar surplus. Shown as negative.
See Bidirectional Power: What to Expect for the full concept.
Energy in Your Exports
- Manual Export and Create exports: the Energy column for a bidirectional device is net - imported minus exported for each time interval. Values can be negative when the device exported more than it imported.
- Auto Export: the energy (Wh) column never goes below zero. Exported energy has its own column.
- Cost and Carbon for bidirectional devices are never negative in any export.
Manual Export: Adding the Export Energy Counter
The Export energy counter is the sensor's running total of all the energy it has ever exported. It only goes up. To find how much was exported in a period, subtract the first value in the period from the last.
- Open Manual Export and start a New manual export.
- Enter an Export name.
- Choose Devices as the Export type. The counter isn't offered for other export types.
- In Data to export, select Export energy counter (kWh). It carries a Pan-42 tag.
- Select the bidirectional PAN-42 devices or circuits, and set the Date range.
- Click Start export.

Which devices can be exported
The counter is only available for PAN-42 devices and circuits marked bidirectional in the Deployment Tool. If your selection includes anything else, you'll see this message under Data to export:
This measurement is only available for PAN-42 sensors marked bidirectional in the Deployment Tool
In the CSV
- The counter has its own column: [device name] - Exported counter - (kWh). Its values are positive running totals.
- Devices in the Generation category, such as PV or solar devices, keep their own - Generation columns.
Note: The CSV data sample on the Manual Export page is an illustration only. It may not match the exact layout of your file.
TimeView's Create Exports Dialog
You can also export straight from a TimeView chart. The download icon opens the Create exports dialog, which turns your current chart selection into a Manual Export job.
- The Energy export is net, the same as in Manual Export.
- If the Export energy counter is on in the chart, it gets its own row in the dialog. Devices that aren't eligible are left out of that row.
- The file is named Devices(Export energy counter) Export - [date].csv.
- 12-month limit. Exports are capped at 366 days. TimeView's Last 12 months preset is a rolling 365 days, so a normal yearly export stays within the limit.
- When the export is ready, download it from Manual Export.
Auto Export
The PAN-42 Auto Export file includes an exported active energy (Wh) column next to consumed active energy (Wh). Both are running totals that only ever count up. Auto Export files are named [job name]_Pan42Measurements.
- Sensors marked bidirectional: the column carries the export counter.
- All other sensors: the column is left blank, not zero. A blank means the sensor can't measure export, not that it measured none.
Notes:
- New and edited jobs only. The column is added to Auto Export jobs you create, and to existing jobs when you edit and save them. Other existing jobs keep the columns they were set up with, so systems that read those files aren't affected.
- Carbon isn't included in Auto Export files.