Hi @moviereview101, it's not clear to me what you are asking. Maybe you can clearify your question. A rating is just a number that is associated with a title.

To export -your- tmdb ratings go to this page: https://www.themoviedb.org/u/moviereview101/ratings

Next to "My Ratings" select Movies or TV, then select the 3 dots next to "My Ratings" and then select "Export CSV".

on page https://www.themoviedb.org/settings/import-list are available examples of 6 formats

Movielens doesn't have so many entries.

https://imgur.com/a/f542Ywa

Is there a way I can make it work? It looked like Simkl had the least entries compared to the others. I tried putting whatever values I could in the same rows as the simkl and adding "tt" before all the IMBD titles, but it wouldn't work.

Hi @moviereview101

I was able to get it to work using the following:

Use the simkl_v1 format

Need only 4 fields (keep all the fields, but only need to fill out these): Type, Rating, TMDB, IMDB

Type=movie, Rating=integer from 1-10 (note it will not accept a floating point), TMDB (as is), IMDB

IMDB must be prefixed with "tt", and the number must be zero padded to 7 digits. For example: tt0372784

@robbie3999 said:

Hi @moviereview101

I was able to get it to work using the following:

Use the simkl_v1 format

Need only 4 fields (keep all the fields, but only need to fill out these): Type, Rating, TMDB, IMDB

Type=movie, Rating=integer from 1-10 (note it will not accept a floating point), TMDB (as is), IMDB

IMDB must be prefixed with "tt", and the number must be zero padded to 7 digits. For example: tt0372784

That doesn't work for me. Sometimes when I edit some it will import, but then none of them are accepted, but using that method it says "The file you submitted could not be mapped to one of our supported formats. If you'd like to ask for a new format to be added, head over to the forums."

I tried with ratings 1/5 and 1/10.

https://imgur.com/a/blh21UI

Not sure what the problem is. I loaded the six lines you have into a csv and imported it and it worked fine for me.

Import Results
We were able to import a total of 6 items out of the 6 (100%) items that we detected in your exported list.

Item    Imported?   Reason? (If applicable)
1. Toy Story
2. Jumanji
3. Grumpier Old Men
4. Twelve Monkeys
5. Babe
6. Mortal Kombat

The format is very exact. A CSV is just a text file, you can view it with a text editor and it should look -exactly- like below. Any extra lines, spaces, or extra commas and it won't work. Also of course if you are editing with a spreadsheet program like excel, make sure you save it as a csv.

SIMKL_ID,Title,Type,Year,Watchlist,LastEpWatched,WatchedDate,Rating,Memo,TVDB,TMDB,IMDB
,,movie,,,,,9,,,862,tt0114709
,,movie,,,,,8,,,8844,tt0113497
,,movie,,,,,8,,,15602,tt0113228
,,movie,,,,,9,,,63,tt0114746
,,movie,,,,,6,,,9598,tt0112431
,,movie,,,,,5,,,9312,tt0113855

Thank you, that was very helpful. I guess I was saving it as the wrong type of .csv. I just opened it in notepad and saved as .csv there and it worked.

@moviereview101 said:

Thank you, that was very helpful. I guess I was saving it as the wrong type of .csv. I just opened it in notepad and saved as .csv there and it worked.

I don't know if this will help, but it explains that there are different ways to save csv files in Excel. If you use the correct one it should work: https://excelribbon.tips.net/T013672_Different_CSV_Formats.html

This is FYI in case someone else comes across this thread. I did a little more testing and actually you don't need Type=movie and the TMDB id.

To import to your rating list, all you need is the rating (integer from 1-10) and the IMDB id.

To import to your watchlist or favorites list, you just need the IMDB id.

The IMDB id is the string "tt" followed by a 7 or 8 digit number. The 7 digit number may be zero padded. I think the newer 8 digit numbers always start with a non-zero.