You need to create a table that can contain up to eight columns. The most important one is Name. If you fill in only this column, each row will be imported as a separate task. If you fill in the other columns as well, you can recreate in SingularityApp a complex structure of projects, sections, and tasks with dates, priorities, and descriptions.
Column Descriptions
- Id
- Purpose: defines the hierarchy (nesting level) for your projects and tasks.
- How to fill in: use numbering like 1, 1.1, 1.1.1. For example:
- 1 — top-level project
- 1.1 — nested project, section, or task inside project 1
- 1.1.1 — task nested inside task 1.1
- Nesting rules: a project can contain other projects, sections, and tasks. A section can only contain tasks. A task can only contain other tasks (subtasks).
- If left empty: all rows will be imported as a flat list.
- Type
- Purpose: defines whether the row is a project, section, or task.
- How to fill in: use one of the following values:
- project — for a project
- section — for a section
- task — for a task
- If left empty: all rows will be imported as tasks.
- Name (Required Column)
- Purpose: this is the name of your project, section, or task.
- Description
- Purpose: allows you to add a detailed description or notes for a project or task (sections don’t have descriptions). Links are supported.
- Priority
- Purpose: sets the task priority.
- How to fill in:
- 0 — pin the task at the top (highest priority)
- 1 — high priority (task name appears in bold)
- 3 — low priority (task name appears dimmed)
- Status
- Purpose: allows you to import tasks with a specific status.
- How to fill in:
- x — canceled task
- — — completed task
- . — task in progress (it will appear in „Today“ every day until completed)
- Date
- Purpose: sets the start date for the task.
- How to fill in: use the format YYYY-MM-DD. You can also specify the time, for example: 2025-12-31 18:30.
- Deadline
- Purpose: sets the due date (deadline) for the task.
- How to fill in: use the format YYYY-MM-DD.
Example File and Saving
You can download an example file to better understand the structure: SingularityApp-CSV-example.csv
When saving the file, make sure that:
- File format is CSV.
- Encoding is UTF-8.
- Column separators are commas.
If you’re using Google Sheets, simply select File → Download → Comma-separated values (CSV). The file will automatically be saved in the correct format.