Importing your data
When importing data we support the following formats:
- Letterboxd import format (CSV)
- IMDb export files (CSV)
- Delicious Library v2 or 3 export files (XML)*
- ICheckMovies export files (custom)
*Delicious Library files are only supported when importing to a list.
Letterboxd import format
The Letterboxd import format is a CSV file (with UTF-8 character encoding) that supports the following column titles, in any order (other column titles are ignored). You must include at least one of the first four titles listed below on the first line of your file, along with any others your file includes data for.
|LetterboxdURI||String (optional), the URI of the matching film or diary entry, example:
|tmdbID||Number (optional), example:
|imdbID||String (optional), example:
|Title||String (optional), used for matching when no ID or URI is provided|
|Year||YYYY (optional), used for matching when no ID or URI is provided|
|Directors||String (optional), used for matching when no ID or URI is provided|
|WatchedDate||YYYY-MM-DD (optional), creates a Diary Entry for the film on this day|
|Rating||Number (optional), rating out of 5 including 0.5 increments|
|Rating10||Number (optional), rating out of 10|
|Tags||String (optional), added to Diary Entry if
|Review||Text/HTML (optional), allows the same HTML tags as the website, added to Diary Entry if
This column header can also be used when importing to a list, to populate the Notes field.
For example, a valid file might look like this:
Title, Year, Rating
Top Gun, 1986, 5
Gremlins, 1984, 4.5
Your CSV file must use the comma character (",") to delimit columns and must not include a byte order mark (BOM). Strings containing commas (such as director/tag lists or review text) must be placed inside quotes, eg:
"Joel Coen, Ethan Coen". Please escape quotes within quoted text.
Notes on importing
- There is no undo after the confirmation step. Be careful!
- The importer shows you a summary of your file before performing the import, so you can fix any mis-matched titles and/or remove any inappropriate entries (such as TV entries that have matched to similarly named films).
- All films imported to your Films/Diary will be automatically marked as watched (there is an option for marking films watched when importing to a list).
- The importer updates existing Diary Entries if a film is imported with a
WatchedDatethat matches an existing entry for the same film already in your Diary, to allow the addition of tags or a review to existing entries.
- Multiple lines containing the same film with the same
WatchedDatewill be combined into a single entry when the imported data is saved. If these are legitimately separate entries, you’ll need to add them manually.
- If both
Ratingcolumns contain data on any given line of the file, whichever column appears second in the file will take precedence.
- There is a file size limit of 1MB, so you’ll need to divide large files into multiple smaller files (the header row containing column names must be in every file).
The helper scripts and web apps listed below are created and maintained by third parties. We hope you find them useful, but please contact the individual authors for support.
- Trakt2Letterboxd by Anoop Sankar
- RatS (Rating Synchronization for IMDb, Netflix, etc.) by StegSchreck
- Ratings exporter for Rotten Tomatoes by hizki
- CSV generator for Filmow by Larissa Gusmão
- CSV generator for Filmow by Myanari (Portuguese)
- CSV generator for FilmAffinity by Pablo Baeyens
- CSV generator for Vudu by Tieg Zaharia
- CSV converter for Lovefilm by Ian Wootten
- XML to CSV converter by Luxon Software (for services like Listal that offer XML export)
- IMDb matcher by Daniel Crouch (matches film titles to IMDb IDs)
If you create a helper script that generates files for our importer, let us know.