SFUMIADocumentation
Private test version

Guide

Import time from a CSV

Map columns, check rows and create drafts without replacing existing time entries.

Updated
In this guide

Prepare the file

Save the table as UTF-8 CSV with a header row. Choose a semicolon, comma or tab separator. Use numbers without formulas or thousands separators.

Open and map

  1. In timesheets, open Entry tools and CSV, then Import time (CSV).
  2. Choose the file, its separator and an identifiable import source.
  3. Map columns, then members, projects, tasks and activities. Also check defaults used when a column is empty.

Example columns

This fictional example uses a date, hours and a stable reference. Map each header to its field; choose the member and project yourself.

datehoursreference
2026-10-122.5example-001
2026-10-133example-002

Choose a suitable duration

Import hours, days based on the configured workday, or start and end times with a break in minutes. Check the calculated duration in the preview.

Night sessions and retained timestamps

CSV does not carry a complete session with UTC timestamps and dated breaks. Use detailed entry for these cases; do not simplify a full session by deleting its information.

Analyse, then confirm

  1. Choose Analyse rows.
  2. Review drafts to create, existing rows and every error.
  3. Correct the batch, analyse again, then confirm Import drafts.

Resume an interrupted import

Keep the same source and references, then analyse the file again. Existing rows are identified. An existing reference with different content is refused; correct the entry through its usual workflow.

Available features depend on your version and installation.

Search the guides

Type a word or choose a guide.

Language

العربيةবাংলাEnglishEspañolFrançaisहिन्दीBahasa IndonesiaPortuguêsاردو简体中文

Change theme