Letterboxd Export

# Export user 912's ratings to Letterboxd CSV
npx node-csfd-api export ratings 912 --letterboxd

# Install globally
brew install bartholomej/tap/csfd

# Export to Letterboxd format
csfd export ratings 912 --letterboxd

import { csfd } from 'node-csfd-api';
import { writeFile } from 'fs/promises';

// Fetch all movie ratings
const ratings = await csfd.userRatings('912', {
  includesOnly: ['film'],  // Only movies
  allPages: true,
  allPagesDelay: 2000     // Be respectful with rate limiting
});

// Convert to Letterboxd CSV format
const letterboxdCSV = convertToLetterboxdFormat(ratings);

// Save to file
await writeFile('letterboxd-import.csv', letterboxdCSV);
console.log(`✅ Exported ${ratings.length} ratings`);

function convertToLetterboxdFormat(ratings) {
  // CSV header
  let csv = 'Title,Year,Rating,WatchedDate\n';
  
  ratings.forEach(rating => {
    // Convert 0-5 stars to 0-10 scale (Letterboxd uses 0.5 increments)
    const letterboxdRating = rating.userRating * 2;
    
    // Parse date from DD.MM.YYYY to YYYY-MM-DD
    const [day, month, year] = rating.userDate.split('.');
    const watchedDate = `${year}-${month}-${day}`;
    
    csv += `"${rating.title}",${rating.year},${letterboxdRating},${watchedDate}\n`;
  });
  
  return csv;
}

// Conversion formula
const letterboxdRating = csfdRating * 2;

// ČSFD format: "01.11.2020"
const csfdDate = "01.11.2020";

// Convert to Letterboxd format: "2020-11-01"
const [day, month, year] = csfdDate.split('.');
const letterboxdDate = `${year}-${month}-${day}`;

Title,Year,Rating,WatchedDate
"The Matrix",1999,10,2020-11-01
"Pulp Fiction",1994,10,2020-10-28
"Inception",2010,8,2020-10-25

import { csfd, CSFDUserRatings } from 'node-csfd-api';
import { writeFile } from 'fs/promises';

interface LetterboxdEntry {
  title: string;
  year: number;
  rating: number;
  watchedDate: string;
}

async function exportToLetterboxd(userId: string) {
  console.log(`📥 Fetching ratings for user ${userId}...`);
  
  // Fetch all movie ratings
  const ratings = await csfd.userRatings(userId, {
    includesOnly: ['film'],
    allPages: true,
    allPagesDelay: 2000
  });
  
  console.log(`✅ Found ${ratings.length} movie ratings`);
  
  // Convert to Letterboxd format
  const letterboxdData: LetterboxdEntry[] = ratings.map(rating => ({
    title: rating.title,
    year: rating.year,
    rating: rating.userRating * 2,
    watchedDate: convertDate(rating.userDate)
  }));
  
  // Generate CSV
  const csv = generateCSV(letterboxdData);
  
  // Save file
  const filename = `${userId}-for-letterboxd.csv`;
  await writeFile(filename, csv);
  
  console.log(`💾 Saved to ${filename}`);
  console.log(`📊 Statistics:`);
  printStatistics(letterboxdData);
}

function convertDate(csfdDate: string): string {
  const [day, month, year] = csfdDate.split('.');
  return `${year}-${month}-${day}`;
}

function generateCSV(data: LetterboxdEntry[]): string {
  let csv = 'Title,Year,Rating,WatchedDate\n';
  
  data.forEach(entry => {
    csv += `"${entry.title.replace(/"/g, '""')}",`; // Escape quotes
    csv += `${entry.year},`;
    csv += `${entry.rating},`;
    csv += `${entry.watchedDate}\n`;
  });
  
  return csv;
}

function printStatistics(data: LetterboxdEntry[]) {
  const byRating = data.reduce((acc, entry) => {
    acc[entry.rating] = (acc[entry.rating] || 0) + 1;
    return acc;
  }, {} as Record<number, number>);
  
  console.log('Rating distribution:');
  [10, 8, 6, 4, 2].forEach(rating => {
    const count = byRating[rating] || 0;
    const percent = ((count / data.length) * 100).toFixed(1);
    console.log(`  ${rating}/10: ${count} (${percent}%)`);
  });
}

// Run the export
exportToLetterboxd('912');

ts-node export-letterboxd.ts

// ❌ Wrong: "01.11.2020"
// ✅ Correct: "2020-11-01"

const [day, month, year] = csfdDate.split('.');
const correctDate = `${year}-${month}-${day}`;

// ČSFD: 0-5
// Letterboxd: 0-10
const letterboxdRating = csfdRating * 2;