Export Microsoft To Do to CSV (Excel, Sheets & Notion)

CSV

Quick answer

Use To Do Mover to export your Microsoft To Do lists locally as todo-tasks.csv (UTF-8 with BOM, all lists merged into one table), then open it directly in Excel or Numbers, or upload it via Import → CSV in Google Sheets or Notion.

Step-by-step

  1. Load your tasks in To Do Mover

    Open To Do Mover's export tool, sign in with Microsoft or load a saved todo-backup.json file offline, and verify your export time zone.

  2. Select “CSV spreadsheet” and check the formula guard option

    Check “CSV spreadsheet” (and keep “JSON backup” selected). Leave “Protect against Excel formulas” on for spreadsheets; you can turn it off if importing strictly into Notion and you have titles starting with - or @.

  3. Download todo-tasks.csv

    Click Export to save the file. If CSV is the only selected format and attachments are not downloaded, your browser downloads todo-tasks.csv directly.

  4. Open or import in your spreadsheet app or Notion

    Open directly in Excel or Numbers, use File → Import → Upload in Google Sheets, or use Settings → Import → CSV in Notion and adjust column property types.

When CSV is a good fit

Ahead of the Microsoft To Do app retirement on June 30, 2027, exporting to CSV is ideal when you want to search, filter, audit, or archive every task in a single table—or build a structured Notion database from your lists.

The To Do Mover export tool merges all selected lists into one RFC 4180–compliant todo-tasks.csv file encoded in UTF-8 with a BOM. Pair it with a JSON backup if you also want raw Graph fields and downloaded attachments archived safely.

Columns included and what gets simplified

todo-tasks.csv contains 19 columns (headers match your chosen UI language; in English: List, Title, Status, Importance, Due date, Start date, Reminder, Repeat, Completed date, Created, Modified, Categories, Notes, Steps, Step progress, Links, Has attachments, Task ID, and List ID):

Data item CSV representation Details
List and Title Dedicated columns All lists merge into one sheet; filter or group by the List column
Status and Importance Localized text E.g., Not started, In progress, Completed; High, Normal, Low
Due, Start, and Completed dates YYYY-MM-DD Restored in your selected export time zone
Reminder, Created, and Modified Local timestamps Converted to your selected export time zone
Repeat rules Readable text Plain-language text (such as Every 2 weeks on Mon, Wed); static text in a spreadsheet
Categories ; -separated text Multiple categories joined with a semicolon and space
Notes Plain text Original HTML formatting becomes plain text; line breaks stay inside the quoted cell
Steps and Step progress Plain text columns Steps uses [x] Step A | [ ] Step B; Step progress shows 1/2
Links Plain text column Title (url) joined by |; Outlook flagged-email fields have not yet been verified on a live account
Attachments Yes / No flag only Binary attachment files are not inside CSV; download them alongside your JSON backup
Task ID and List ID Preserved verbatim Useful for deduplication, scripts, or cross-referencing todo-backup.json
My Day and list groups Not available Not exposed by Microsoft Graph; lists appear flat in the List column

Opening or importing in each app

Microsoft Excel

  • Double-click todo-tasks.csv to open it directly. Because the file includes a UTF-8 BOM, current versions of Excel recognize non-English text and emoji automatically.
  • If an older Excel version displays garbled characters, open a blank workbook, click Data → From Text/CSV, choose todo-tasks.csv, select 65001: Unicode (UTF-8), and load the table.

Apple Numbers (Mac)

  • Open Numbers and choose File → Open, or drag todo-tasks.csv directly onto the Numbers app icon.
  • If columns do not split as expected, click the table before making any edits, open the Format sidebar → Table tab, and click Adjust Import Settings to verify comma delimiting.

Google Sheets

  1. Open Google Sheets and create a new spreadsheet (or open an existing one).
  2. Click File → Import, switch to the Upload tab, and drop in todo-tasks.csv.
  3. Choose an import location (such as creating a new spreadsheet or inserting a new sheet), leave separator detection automatic, and click Import data.

Notion database

To Do Mover does not provide a Notion-specific format, but Notion imports standard CSV files straight into databases:

  1. In Notion on the web or desktop, open Settings → Import from the sidebar, or click ••• → More → Import on a page.
  2. Select CSV and upload todo-tasks.csv (creating a new database or merging into an existing one).
  3. After importing, change property types for List, Status, and Importance to Select, Categories to Multi-select, and date columns to Date so you can build board, table, or calendar views.

If you prefer Notion pages with checkboxes instead of a database, follow the Markdown export guide for Obsidian and Notion.

Post-import checks and troubleshooting

  • Leading apostrophes (') in cells: That prefix comes from “Protect against Excel formulas” (enabled by default) for cells starting with =, +, -, or @. Excel hides the apostrophe in normal view, whereas Notion or plain text editors display it. Uncheck the option and re-export if you do not need formula protection.
  • Dates shifted by one day: Verify that Export time zone matches the time zone you normally used Microsoft To Do in, then re-export (or convert offline from your saved todo-backup.json).
  • Fewer rows than expected: Confirm whether “Include completed tasks” was enabled on the preview screen and check for any failed lists; see the FAQ for full troubleshooting tips.

Common questions

Will non-English text look garbled in Excel, and what if an older Excel has issues?

No. To Do Mover writes todo-tasks.csv as UTF-8 with a BOM and CRLF line endings so modern Excel, Apple Numbers, and Google Sheets display non-English characters and emoji accurately when opened directly.

If an older version of Excel still garbles text, open a blank workbook, go to Data → From Text/CSV, select todo-tasks.csv, and choose 65001: Unicode (UTF-8) before loading.

What does “Protect against Excel formulas” do, and should I turn it off for Notion?

When enabled (the default), any user-text cell beginning with =, +, -, or @ gets a leading apostrophe (') so Excel will not treat task titles like “- Call vendor” or “@Alex” as formulas.

If you are importing exclusively into a Notion database and have titles starting with - or @, uncheck this option before exporting so the extra leading apostrophe does not show up inside Notion.

Does To Do Mover offer a Notion-specific export format?

No. To Do Mover does not have a dedicated Notion format. Use this general CSV format if you want a filterable Notion database, or export Plain text Markdown if you prefer Notion pages with checkboxes.

Sources

Ready to export your tasks?

Everything runs locally in your browser. Start with a lossless JSON backup or try the demo first.