Spreadsheets and Dart

Spreadsheets and Dart overview

Link Dart with spreadsheets to pull in any context into projects and tasks. Dart's importer works with spreadsheets combined in order to bring helpful AI features to your work.

What are spreadsheets?

Spreadsheets are digital tools used for storing, organizing, and manipulating data. They are composed of rows and columns that form cells, where data can be entered and kept. These cells can contain numbers, text, or other more complicated data types. Spreadsheets are widely used in pretty much every field from finance to education and even personal use, offering a versatile platform for tasks like task tracking, project planning, accounting, data analysis, inventory management, and more. Google Spreadsheets and Microsoft Excel are the two most common spreadsheet applications in use, and data can be imported or exported to them through the standard CSV format among others.

Dart spreadsheets importer setup

To use the Dart spreadsheets importer go to the Import page in settings and choose Spreadsheet as the source. The follow the instructions:

1. Open your spreadsheet
2. Make sure that there are no extra rows before the column headers
3. Make sure that the column headers exactly match the required fields
   1. 'ID'
   2. 'Title'
   3. 'Dartboard'
   4. 'Status'
4. Make sure that the other column headers exactly match any optional fields you want to import
   1. 'Description' (empty or the description in markdown format)
   2. 'Parent ID' (empty or the ID of the parent task)
   3. 'Assignee Emails' (empty or a comma-separated list of emails)
   4. 'Tags' (empty or a comma-separated list of tags)
   5. 'Priority' (empty or one of 'Critical', 'High', 'Medium', or 'Low')
   6. 'Start date' (empty or a date in a standard format)
   7. 'Due date' (empty or a date in a standard format)
   8. 'Size' (empty or one of 'XS', 'S', 'M', 'L', or 'XL')
5. Save or export the sheet as a CSV file
6. Upload the CSV file into the designated area