Spreadsheet Columns to Things (dates and tasks)


#1

HI! I’ve got a spreadsheet with a bunch of dates in column A and tasks in column B. I’d like to get this into Things 3 on iOS using Shortcuts with the dates as “When” dates and the task names as title. Does anyone have any idea how to do this?

Thanks!

Todd


#2

I suggest using the spreadsheet to create a URL scheme for each task and then opening those URLs via Shortcuts. The formula to create the URL scheme in numbers would be something like this:

="things:///add?title="&A1&"&when="&B1"

(Full URL scheme documentation is available here: https://support.culturedcode.com/customer/en/portal/articles/2803573)

Then you copy that new column, and run something like this shortcut: Open Clipboard URLs. In my experience the URL action encodes any characters it doesn’t like, so that should work.


Another approach is to put the data on your clipboard as a CSV and then run something like this shortcut: CSV Clipboard to Things, you need to specify the column numbers for the titles and deadlines on import.


#3

This is amazing! Thanks so much. You’ve saved me hours and hours of time!