⭐Automated P6-Ready XLS Export for Actuals

On large construction projects, the master schedule lives in Primavera P6, but day-to-day progress tracking happens in VisiLean. Every reporting cycle, getting actuals back into P6 is a multi-step manual process.

Why This Matters

Schedule updates between VisiLean and Primavera P6 are a contractual necessity on most large-scale projects. Clients, PMCs, and joint venture partners expect the P6 master programme to reflect current reality and they expect it updated regularly. When that update cycle depends on manual data wrangling, it creates a bottleneck that doesn't scale. Planners spend hours on formatting instead of analysis, updates get delayed, and every manual touchpoint introduces the risk of transcription errors reaching the master schedule. For enterprise customers running hundreds of projects, this has been a deployment blocker.

What's New?

• One-click XLS export of actuals: Export actual progress data from VisiLean in P6's native spreadsheet import format, targeting the Activities subject area. The file is ready to import via P6's File → Import → Spreadsheet (XLS) workflow with no manual field mapping.

• P6 XLS format, not XML or .xer: The export uses P6's spreadsheet import format by design, sidestepping the calendar, granularity, and duration logic issues that made the previous MPXJ-based approach unreliable.

• Activities subject area only: The export covers actuals-related activity fields (Activity ID, Actual Start, Actual Finish, % Complete, and related columns). Resource assignments, expenses, and predecessor/successor relationships are out of scope for this release.

How It Helps

A Planner managing a 3,000-activity infrastructure programme collects weekly actuals in VisiLean, downloads the P6-ready XLS file, and imports it into Primavera in minutes.

A Project Controls Manager on a joint venture project needs to submit updated actuals to the client's PMC every fortnight. Instead of going through a lot of manual steps, they generate the export directly, verify it against the progress report, and submit it with confidence that P6's import validation will accept it on the first attempt.

A Senior Planner overseeing an enterprise rollout across hundreds of projects exports actuals from each project in sequence, imports them into the corresponding P6 files, and produces a consolidated portfolio-level schedule update within a single afternoon - a process that previously required dedicated support involvement per project.

Key Considerations & Caution Points

Activities subject area only. This release covers activity-level actuals (Actual Start, Actual Finish, % Complete). Resource assignments, expenses, and relationship (predecessor/successor) exports are not included and remain on the roadmap.

Day-level granularity. VisiLean continues to operate at day-level precision. The exported XLS reflects this hourly precision fields in P6 will show day-level values.

Existing MPXJ export unchanged. This new export sits alongside the existing P6 file export. The previous mechanism is not modified or removed.

Available for only .xer file imports. This functionality is available only for .xer type of file