Exporting Data

Describes the ways to extract data from Everdo in a variety of open formats.

The possible export options are:

Copying a specific list as plain text
JSON export of the whole database
CSV export of the whole database
Direct sqlite database access / query

Copy a specific list as text

This feature only available in the desktop app.

With this feature you can obtain a human-readable plain text representation of the current list of Everdo items. To copy the current view as text, use the corresponding button in the Filter Bar at the top of the list of items. As a result, the list will be copied to clipboard in a format similar to the following.

Next
----
[ ] Try using "Export as CSV"
[ ] Try using "Export as JSON"

Done
----
[x](Apr 2)  Use "Copy as Text"

JSON export

With JSON Export you can export all your data in a machine-readable format and move data between different devices. To perform a JSON export/import in the desktop app, use a corresponding menu option in the application’s main menu.

In the mobile apps, use the Export button in the app settings to export your data. To import data into the iOS app, share the JSON file from the Files app into Everdo. On Android, use the Import JSON button in the app settings.

You can learn more about the data structure at the Everdo JSON page.

The Import function works by overwriting the contents of any existing items and creating the missing items. It doesn’t delete any data. The Import function also doesn’t consider item modification times or attempt to merge changes. It simply matches the ids of the imported items to with the ones already in the database and then (a) overwrites the matched items and (b) creates unmatched items.

CSV export

This feature only applies to the desktop app.

The CSV format is useful to work with data in a spreadsheet application, such as Microsoft Excel or LibreOffice. To perform a CSV export, use a corresponding menu option in the application’s main menu.

Direct database access

This only applies to the desktop app.

You can query the actual Everdo database located in the home directory. You will need an SQLite client application to do so.

Warning

Always backup your database and use a copy of the database to perform any custom queries. It is very easy to corrupt a database by accidentally writing bad data, making the app crash on start.

Last modified November 8, 2020