Forge Json
Get Started
import

Export Harvest to JSON

Convert Harvest CSV and Excel exports into normalized timesheet JSON

  • Imports Harvest CSV and Excel exports
  • Normalizes timesheet rows into stable JSON
  • Produces downstream-ready reporting payloads

Paste or upload a Harvest export — instantly preview normalized JSON rows locally in your browser.

Continue

Why this package exists

Common problems

  • Harvest exports are business-readable spreadsheets, but downstream automation systems need deterministic JSON row structures.
  • CSV and Excel exports frequently contain extra reporting columns that do not belong in APIs, dashboards, analytics, or AI workflows.
  • Timesheet exports need stable keys and normalized rows before warehouse ingestion or downstream processing.
  • Different reporting exports often drift in column naming and formatting across teams.

When to use

Use this when converting Harvest CSV or Excel exports into normalized timesheet JSON for dashboards, analytics, warehouse ingestion, APIs, automation workflows, or AI analysis.

Expected outcome

A normalized JSON timesheet dataset with stable keys and consistent row structure ready for downstream reporting, APIs, dashboards, warehouse loads, and automation workflows.

Automatically detects

  • Dates
  • Clients
  • Projects
  • Tasks
  • Hours
  • Notes
  • Billable flags

What the wizard asks

3 steps

Each step shows your input, the question, and a preview of the output.

  1. 1

    Normalize Harvest export columns into stable JSON fields?

    Convert Harvest export headers into deterministic JSON field names downstream systems can reliably consume.

  2. 2

    Remove empty values from the exported rows?

    Trim strings and remove empty values left over from optional reporting columns.

  3. 3

    Which fields should land in the final timesheet JSON rows?

    Keep only the normalized reporting fields downstream systems actually require.