Project Management migration

Migrate from Streamtime to Microsoft Project

Field-level mapping, validation, and rollback between Streamtime and Microsoft Project. We move data and schema; workflows are rebuilt natively in Microsoft Project.

Streamtime logo

Streamtime

Source

Microsoft Project

Destination

Microsoft Project logo

Compatibility

58%

7 of 12

objects map 1:1 between Streamtime and Microsoft Project.

Complexity

BStandard

Timeline

3-5 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Moving from Streamtime to Microsoft Project is primarily a project and task structure migration with an important caveat: Streamtime's financial layer (Rate Cards, Quotes, Invoices, POs) has no native equivalent in Microsoft Project. We migrate the project hierarchy—Jobs as Projects, To-Dos as Tasks, Schedules as Resource Assignments—and preserve time-entry data as Actual Work on tasks using the legacy MPP import format or Project Online REST API. We do not migrate commercial documents because Microsoft Project is a scheduling and work-management tool, not a billing or invoicing platform. Template Jobs from Streamtime map to Project template files (.mpt) that customers recreate manually post-migration. We flag the API rate limits on the Streamtime side (60 req/min, 720 req/hour) and the August 2025 Planner consolidation announcement from Microsoft that affects Project for the web destinations.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

Streamtime logo

Streamtime

What's pushing teams away

  • Budgeting and accounting features are limited or require workarounds for agencies with complex billing structures or multi-currency projects.
  • The platform lacks the advanced enterprise features, automation depth, and integrations that growing agencies eventually need.
  • Some users report that the interface feels dated compared to newer project management tools that launched after Streamtime's 2016 web version.
  • Support responsiveness varies, with some customers noting difficulty reaching knowledgeable staff for technical or billing issues.

Choosing

Microsoft Project logo

Microsoft Project

What's pulling them in

  • Organizations already running Microsoft 365 and Azure AD adopt Microsoft PPM because it slots into existing identity, Teams, and SharePoint infrastructure without requiring a separate identity provider or SSO vendor.
  • Enterprise PMOs choose it for critical-path scheduling, baseline comparison, cross-project dependencies, and resource utilization reporting that standalone PM tools cannot replicate at this depth.
  • Project Online's integration with Power BI gives portfolio-level dashboards and cost-rollup reporting that satisfies executive governance requirements without third-party BI tooling.
  • Government, financial services, and healthcare organizations select it because FedRAMP, ISO 27001, and SOC 2 compliance certifications meet enterprise procurement requirements out of the box.
  • Large IT departments default to it as the market-leader in project portfolio management software, often driven by corporate licensing agreements that bundle it with other Microsoft 365 seats.

Object mapping

How Streamtime objects map to Microsoft Project

Each row shows how a Streamtime object lands in Microsoft Project, including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

Streamtime

Job

maps to

Microsoft Project

Project

1:1
Fully supported

Streamtime Jobs map to Microsoft Project as Projects. Job name, description, start date, and due date migrate to Project Name, Project Summary, Start, and Finish. Job status (active, on hold, completed) maps to Project Custom fields since Microsoft Project does not have a native status concept beyond percent complete. Budget burn data from Streamtime Job financial fields does not migrate to Project because Project lacks native budget fields outside of Project Online cost resource tracking.

Streamtime

To-Do

maps to

Microsoft Project

Task

1:1
Fully supported

Streamtime To-Dos map to Microsoft Project Tasks. Each To-Do's Job parent becomes the Project parent so that task hierarchy is preserved. To-Do name maps to Task Name, assigned Team Member maps to Resource Names, and completion status maps to Percent Complete. To-Dos without a date map to undated Tasks in Project; To-Dos with a deadline map to Tasks with a Constraint Type of Finish No Later Than.

Streamtime

Time Entry

maps to

Microsoft Project

Task Actual Work

1:1
Fully supported

Streamtime Time Entries map to Microsoft Project as Actual Work on the corresponding Task. We resolve the Time Entry's Job and To-Do parent to identify the destination Task GUID, then post the hours as a TaskUpdates through the Project Online REST API (Plan 3/5) or legacy MPP import (Project Desktop). Duration per Time Entry converts to hours; multiple entries for the same Task accumulate as Total Actual Work. This preserves budget burn data in the destination but requires the destination project to be checked out for edit in Project Online.

Streamtime

Team Member

maps to

Microsoft Project

Resource

1:1
Fully supported

Streamtime Team Members map to Microsoft Project Resources. We resolve each Team Member by email as the Resource name and assign them to Tasks based on their To-Do assignments in Streamtime. Resource type defaults to Material unless the customer specifies Work-type resources. If Streamtime tracks hourly rates per Team Member, those map to Resource Cost Rate tables in Project Desktop or Project Online if the customer has cost tracking enabled in Plan 5.

Streamtime

Schedule

maps to

Microsoft Project

Resource Assignment

1:1
Fully supported

Streamtime Schedules represent allocated time for a Team Member on a Job. These map to Microsoft Project Resource Assignments on Tasks with Units set to the allocated percentage and Work calculated from duration. Schedule notes and allocation rationale do not have a native Project field; we write them to the Task Notes field during migration. Customers using Project Online can surface allocation data in the Resource Center view post-migration.

Streamtime

Company

maps to

Microsoft Project

Project Custom Field

1:1
Fully supported

Streamtime Companies represent clients and have no direct Microsoft Project equivalent. Project is a scheduling container without a native account or client object. We map Companies to a Project-level custom text field (Client Name) populated from the Job's linked Company. If the customer uses SharePoint Online alongside Project, we can optionally create a SharePoint List of Companies and link them via a Project detail page; this requires separate configuration outside migration scope.

Streamtime

Rate Card

maps to

Microsoft Project

Resource Cost Rate Table

lossy
Fully supported

Streamtime Rate Cards define pricing tiers by role, item, or expense. Microsoft Project does not have a rate card object. If the customer enables Resource cost tracking in Project Online Plan 5, we map Rate Card role entries to Resource Cost Rate Table rows (per-hour rates by date range). Non-role rate items (expenses, line items) do not migrate because Project lacks an expense line object; we export them as CSV for the customer's finance team.

Streamtime

Quote

maps to

Microsoft Project

Not migrated

lossy
Fully supported

Streamtime Quotes have no Microsoft Project equivalent. Project is a scheduling and work-management tool, not a commercial document system. We export Quotes as structured CSV with line items, pricing, and status so that the customer's finance team can import into their accounting tool. We document the Quote export format during scoping and include it in the handoff package. Customers planning to use Microsoft Dynamics 365 Project Operations alongside Project can configure Quote mapping in that system separately.

Streamtime

Invoice

maps to

Microsoft Project

Not migrated

lossy
Fully supported

Streamtime Invoices are commercial documents tied to Jobs and Time Entries with no Microsoft Project equivalent. We export Invoices as CSV with vendor associations, line items, amounts, currency, and payment status. This export is included in the handoff package for reconciliation in the customer's accounting tool. We do not recommend recreating invoices inside Project because Project lacks invoice generation, payment tracking, and accounts receivable fields.

Streamtime

Purchase Order

maps to

Microsoft Project

Not migrated

lossy
Fully supported

Streamtime POs represent vendor commitments against a Job and have no Microsoft Project equivalent. We export POs as CSV with vendor, line items, amounts, and status. Customers using Project Online with Microsoft Dynamics 365 Project Operations can import these into the Project invoicing module; standard Project Plan 3 and Plan 5 do not include PO functionality.

Streamtime

Template Job

maps to

Microsoft Project

Project Template (.mpt)

lossy
Fully supported

Streamtime Template Jobs store repeatable project structures with pre-configured To-Dos. Microsoft Project stores templates as .mpt files (Project Template) that must be created manually in Project Desktop or through the Project Online template library. We cannot programmatically create .mpt files because the format requires local desktop tooling. We deliver a written template map: for each Streamtime Template Job, we document the To-Do structure, default durations, and Resource assignments so the customer's PM can recreate them as Project templates post-migration.

Streamtime

Attachment

maps to

Microsoft Project

SharePoint Document Library

1:1
Fully supported

Streamtime Attachments linked to Jobs and commercial documents do not have a native Microsoft Project attachment system. Project Online files attach to SharePoint, and Project Desktop files attach locally. We map Attachment file references and metadata, but actual file transfer depends on the destination SharePoint library or local file storage configuration. We export attachment URLs and metadata in a reconciliation CSV for the customer's admin to re-attach post-migration.

Gotchas + challenges

What specifically takes care here

Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.

Streamtime logo

Streamtime gotchas

High

API rate limits can interrupt bulk migration jobs

Medium

Only the account subscriber can access the API key

Medium

Financial export permissions are separate from job permissions

Low

Template Jobs require upfront setup before migration

Microsoft Project logo

Microsoft Project gotchas

High

Project for the web is being retired and merged into Microsoft Planner

Medium

Planner-tier portfolio features are incomplete despite Plan 5 labeling

Medium

Web app constraint controls are weaker than the Windows desktop client

High

Project requires a separate license not bundled with standard Microsoft 365

Medium

Project Online API is edition-gated and inconsistently documented

Pair-specific challenges

  • Streamtime Rate Cards and financial objects have no Microsoft Project destination

    Microsoft Project does not have Rate Card, Quote, Invoice, or PO objects. Migrating away from Streamtime means losing the native commercial layer unless the customer adopts a separate accounting or PSA tool. We export Quotes, Invoices, and POs as structured CSV and map Rate Card roles to Resource Cost Rate tables in Project Online Plan 5 if cost tracking is enabled, but non-role rate items and all commercial documents must live outside Project. Customers must confirm their billing and invoicing strategy before migration begins, otherwise financial records become inaccessible in the destination system.

  • Microsoft Project lacks native time tracking at Plan 1 and Plan 3 web tiers

    Streamtime's core value is embedded time tracking without separate timesheet submission. Microsoft Project Plan 1 and Plan 3 web do not include a native timesheet feature. Time Entry data from Streamtime can be written as Actual Work on Tasks through the Project Online REST API, but this requires the project to be checked out and edited per-task, which is manual for large datasets. Project Online Plan 5 includes the timesheet feature, but team members still must submit timesheets separately, which is a workflow change from Streamtime's embedded model.

  • Streamtime API key requires subscriber account access

    The Streamtime Public API key is accessible only to the account subscriber, not to general administrators. Before migration scoping, we confirm the subscriber account credentials are available. If the subscriber is no longer active or reachable, account recovery or ownership transfer is required before API access can be obtained. Streamtime's API enforces 60 requests per minute and 720 requests per hour, which we respect through pagination and throttling. We contact [email protected] in advance for customers needing elevated limits during migration windows.

  • Project for the web is consolidating into Microsoft Planner in August 2025

    Microsoft announced in May 2025 that Project for the web will redirect to Microsoft Planner in August 2025, and the Project and Roadmap apps in Teams will retire. Customers migrating to Project for the web should clarify with their Microsoft account team whether their destination is Planner for the web (which inherits Project for the web plans) or the desktop Project client. We do not migrate to Roadmap because Roadmap is retiring. We recommend confirming the destination product tier before schema design begins.

  • Financial export permissions in Streamtime are separate from job permissions

    Exporting financial data in Streamtime requires the user to have both permission to view and edit Jobs and permission to export finances. During scoping we verify the migration user account has both permission sets to avoid missing billing data. Incomplete permissions result in Time Entry exports without associated cost rates, requiring manual reconciliation post-migration. We request the subscriber account for migration runs specifically to avoid this permission gap.

Migration approach

Six steps for a successful Streamtime to Microsoft Project data migration

  1. Discovery and permission verification

    We audit the Streamtime account for active Jobs, To-Dos, Team Members, Time Entries, Companies, Rate Cards, and Template Jobs. We verify that the migration user account is the account subscriber and has both Job edit and financial export permissions. We identify which Streamtime tier (Standard, Plus, Enterprise) is active to understand Rate Card complexity. On the destination side we confirm whether the customer is licensing Project Plan 1, Plan 3, Plan 5, or Project Desktop, and whether Project Online is in scope. We also clarify whether Planner consolidation affects the destination and whether a separate accounting tool exists for Quote and Invoice export ingestion.

  2. Schema design and resource mapping

    We design the Microsoft Project structure based on the customer's Streamtime data. Jobs become Projects with a custom Client Name field populated from the linked Company. To-Dos become Tasks with hierarchy preserved from the Job parent. Team Members become Resources with type (Work or Material) set per the customer's specification. If Resource cost tracking is enabled, Rate Card role rates are mapped to the Resource Cost Rate Table. Template Jobs are documented as a written template map rather than created as .mpt files because .mpt creation requires desktop tooling.

  3. Time entry resolution and Actual Work mapping

    We extract all Time Entries and resolve each to its Job and To-Do parent in Streamtime. We match each To-Do to its destination Task GUID in the Project Online environment and aggregate hours by Task. For Plan 5 destinations with timesheet features enabled, we post hours as Actual Work through the Project Online REST API. For Plan 3 destinations without timesheet, we deliver the Actual Work data in a CSV format that the customer's admin imports manually per project. Duration-to-hour conversion uses the Streamtime Time Entry's logged hours directly.

  4. Commercial document export and financial handoff

    We export Quotes, Invoices, and POs as structured CSV with all line items, amounts, currency, status, and Job associations. Rate Card role entries are mapped to Resource Cost Rate rows in a separate CSV if the destination uses Project Online Plan 5 cost tracking. These exports are packaged in the handoff package with a field dictionary mapping each Streamtime column to the destination system the customer designates for financial records. We do not load commercial documents into Microsoft Project because no destination object exists.

  5. Template Jobs documentation and admin handoff

    We document every Template Job in Streamtime as a written template map specifying the Job name, To-Do structure with names and default durations, Resource assignments, and any linked Rate Card. This document allows the customer's Project administrators to recreate the equivalent .mpt files in Project Desktop or through the Project Online template library. Template recreation is outside migration scope because .mpt file creation requires local desktop access and cannot be automated via API.

  6. Production migration and validation

    We run production migration in dependency order: Resources first, then Projects (Jobs), then Tasks (To-Dos), then Actual Work (Time Entries). Each phase emits a row-count reconciliation report. The customer's Project Manager spot-checks 20-30 random Tasks against the source Streamtime To-Dos, verifies Resource assignments match Team Member allocations, and confirms that Actual Work totals match the Time Entry sum per Job. Any mapping corrections are made before the final phase closes.

  7. Cutover and post-migration handoff

    We freeze Streamtime writes at cutover, run a final delta migration of any records modified during the migration window, then deliver the handoff package including Projects and Tasks reconciliation report, Actual Work CSV, commercial document CSV, Rate Card CSV, and Template Job map. We do not rebuild Streamtime workflows or automations inside Microsoft Project because Project lacks a native workflow engine at Plan 1 and Plan 3; the customer uses Power Automate for custom process automation post-migration. We provide a one-week hypercare window for reconciliation issues.

Platform deep dives

Context on both ends of the pair

Streamtime logo

Streamtime

Source

Strengths

  • Time tracking is embedded in the workflow without requiring separate timesheet submission from team members.
  • Rate cards support per-client, per-project, and multi-currency pricing configurations out of the box.
  • Financial reporting covers work-in-progress, client profitability, and team capacity without requiring third-party integrations.
  • Template Jobs allow teams to standardize recurring project structures and reduce manual setup time.
  • CSV export is available for reports and list views, enabling data portability for analysis outside the platform.

Weaknesses

  • Budgeting and accounting features are limited compared to dedicated agency finance tools, with some customers reporting gaps for complex billing scenarios.
  • The interface has not received major visual updates since the 2016 web version launch, feeling dated compared to newer competitors.
  • Enterprise-tier features such as advanced automation, custom workflows, and deep third-party integrations are limited compared to platforms like monday.com or Asana.
  • Rate card setup requires navigating multiple settings screens, creating a learning curve for new administrators.
Microsoft Project logo

Microsoft Project

Destination

Strengths

  • Deep critical-path scheduling with baseline comparison and cross-project dependency tracking unmatched by lighter PM tools.
  • Native Azure AD authentication, Teams integration, and Power BI reporting sit on infrastructure enterprises already license and manage.
  • Enterprise governance controls including demand intake workflows, resource request approval, and portfolio-level capacity analysis.
  • Supports both Waterfall and Agile methodologies within the same project, accommodating hybrid delivery teams.
  • Scalable from Project Plan 1 for small teams to Project Server on-premises for regulated industries with strict data-sovereignty requirements.

Weaknesses

  • Ease-of-use scores trail the category average by a wide margin; onboarding friction frustrates new users consistently across G2 and Capterra reviews.
  • Pricing ranks 42nd of 49 tools in its category — the total cost of ownership including IT administration and training is rarely recovered for small or mid-market teams.
  • No built-in client portal, external stakeholder sharing, or proofing workflow, limiting use cases to internal PMO environments only.
  • The web interface (Project for the web / Planner Premium) has materially weaker constraint controls and resource auto-leveling than the Windows desktop client.
  • Project for the web is being consolidated into Microsoft Planner, creating uncertainty about which product tier will host project portfolio data long-term.

Complexity grading

How hard is this migration?

Standard Project Management migration. 2 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across Streamtime and Microsoft Project.

  • Object compatibility

    B

    2 of 8 objects need a mapping; the rest are 1:1.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    Streamtime: 60 requests/min, 720 requests/hour, 30s processing/min, 300s processing/hour.

  • Data volume sensitivity

    B

    Streamtime doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your Streamtime to Microsoft Project migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about Streamtime to Microsoft Project data migrations

Answers to the questions buyers ask most during Streamtime to Microsoft Project migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your Streamtime to Microsoft Project migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Migrations under 200 active Jobs and 5,000 To-Dos typically complete in three to five weeks. Migrations with large historical time-entry archives (over 50,000 Time Entry records), multiple Template Job structures requiring manual .mpt recreation, or multi-department resource pools requiring Rate Card mapping across dozens of roles move to seven to twelve weeks. The commercial document export (Quotes, Invoices, POs) adds minimal time because it is a CSV extraction rather than a structured API load.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Streamtime.
Land in Microsoft Project, intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day