How to Import Your Library from Excel

Giorgio Bertolotti
Written by Giorgio BertolottiLast updated 1 day ago

Keeping track of your manga in a spreadsheet? You can import it into MangaTime from an XLSX, XLS, CSV or TSV file.

⚠️ The most important rule: the first row of your sheet must contain the column names written exactly as below, all lowercase. Title, Name or Manga won’t work: it must be title. If the names don’t match, nothing gets imported.

Step 1: Prepare your file

The easiest way: copy this example table, paste it into cell A1 of a new sheet, then replace the example rows with your own manga.

titlestatusscorelast_chapter_readnotes
One Piecereading51100Best manga ever
Berserkcompleted4
Vagabondplan_to_read

What each column means:

  • title: the manga title. It’s the only required column

  • status: one of reading, completed, on_hold, dropped or plan_to_read

  • score: a number from 1 to 5

  • last_chapter_read: the number of the last chapter you read

  • notes: any personal note

Cells can be left empty, except title. Don’t add other columns and don’t leave empty rows above the column names.

Step 2: Import the file into MangaTime

  1. Open MangaTime

  2. Open the Profile tab using the bottom navigation bar

  3. Open up the Settings page by tapping on the gear icon in the top right corner

  4. Press on Third Party Import, then choose Excel

  5. Tap on Select Excel File and pick your file

  6. Then press on Start Import, wait a few seconds (based on how big your library is) and TADAAA 🎉

What gets imported

  • Your library: every row with a title

  • Status, score and reading progress from their columns. Completed series are marked as fully read

  • Notes: saved as private notes on each manga

Tips & troubleshooting

  • “We couldn’t read your list”? The column names in the first row don’t match. Check that they are all lowercase and spelled exactly like the example above, with no empty rows above them.

  • Your file has more than one sheet? We only read the sheet that was open when you saved the file. Keep your list on the first sheet and make sure it’s the one selected before saving, or move it to a new file.

  • Some titles were not imported? We match manga by title (including alternative titles), so use the official name when possible. Titles not in the MangaTime catalogue yet are skipped: you can add them manually or report them to us.

  • Status or score ignored? Check that the values match the ones listed above: anything else is left empty.

  • Already have manga in MangaTime? Nothing gets lost: imported titles are merged with your library and chapters you already marked as read stay read.

  • File too large? The file must be smaller than 10 MB.

Did this article help you solve your issue?