Create Anki Decks Quickly Using CSV - With Images

Поділитися
Вставка
  • Опубліковано 16 лис 2024

КОМЕНТАРІ • 56

  • @gennadygennady3458
    @gennadygennady3458 12 днів тому

    Instead of using bulk edit for images in Excel, you can create your own note type in Manage Note Type. Just clone the Basic type and add a new field called "image". Then, in the same window, click the Cards button and, in the Back Template, write where {{image}} is the name of your new field. After that, you just need to enter the file name in the CSV file, not full html code sample as in video. Easy peasy!

    • @MandarinMania
      @MandarinMania  11 днів тому

      Thank you. I have pinned your comment as it is a very good one. I made the video 4 years ago and my Anki skills have since improved but I am always learning. Appreciate you sharing with the community.😄

  • @하루3096
    @하루3096 4 роки тому +14

    Thanks for the video. Spent close to 6-7 hours though other videos and stuff but didn't understand anything. Thanks once again.

  • @michaelmich6111
    @michaelmich6111 4 роки тому +2

    This saves so much time...so many important info. Concurrently on my search I did find the export to CSV addon before finish viewing this video. Please create more videos. I'm tackling Chinese calligraphy (traditional of course) as a complete beginner to the language and learning Anki at the same time. As a visual, spatial, kinesthetic learner, the way layout of the menu items and sub items presents a steep learning curve.

  • @Lyriks_
    @Lyriks_ Рік тому +1

    I usually HATE music with narrated video but yours was a bliss. Thanks !!

    • @MandarinMania
      @MandarinMania  4 місяці тому

      Ha ha! My eyes fell on your comment. I hate it to now. All my videos are music-free.

  • @caminandoporlasendaantigua971
    @caminandoporlasendaantigua971 4 роки тому +1

    Wow...!!! This videos was so helpul and your voice is so understandable for an English learner like me. :D U are doing and excellent job Mss.
    God bless you.

  • @dfzfddz003
    @dfzfddz003 2 роки тому +1

    Thank you so much, I've been trying to do this for almost 5 hours but nothing seemed to work, until I found this, you saved me!!!!

  • @Mahdi25009
    @Mahdi25009 7 місяців тому +1

    the images aren't showing up, it just gives me the name of the image. can you please help?

    • @MandarinMania
      @MandarinMania  4 місяці тому

      Is the image name formatted exactly like this: when viewing it in Anki?? In this example, test.jpg would be the file name you are using.

  • @nahnoc
    @nahnoc 2 роки тому +1

    This video has helped me a lot. Thank you so much♥. Have a great day

  • @SallyBunBun
    @SallyBunBun 9 місяців тому +1

    I just can’t get the formula to work, Excel keeps telling me there is an error. I have tried and tried. :(

    • @MandarinMania
      @MandarinMania  4 місяці тому

      If this is still a problem for you, copy and paste your formula from your spreadsheet into a reply here...I will take a look at it.

    • @SallyBunBun
      @SallyBunBun 4 місяці тому +1

      @@MandarinMania I’ll have to watch the video again! It was such a long time ago now I’m not sure what I was trying to do! Knowing me I will have found an alternative… but I will check

  • @45L31K
    @45L31K 3 роки тому +2

    what a great, GREAT tutorial. I'm simply amazed by the quality and narration. 11 out of 10

  • @haja6917
    @haja6917 3 роки тому +1

    I had problem with syncing & running the deck I made using this method on Ankimobile. The image not appeared on iOS app. Solved this problem by changing ".jpg" from front field into ".JPG".. lol for those have same problem with iOS app, check if the upper/lower case of the image file name matches the one you wrote.

    • @MandarinMania
      @MandarinMania  3 роки тому +1

      Thanks for sharing that. It may help others. 😀

  • @leonardo-cx3iq
    @leonardo-cx3iq 3 роки тому +1

    maybe you can't add images because excel, try it =""

  • @spadaacca
    @spadaacca 6 місяців тому +1

    What about the audio field?!

    • @MandarinMania
      @MandarinMania  5 місяців тому

      I have other videos that discuss audio. 🙂

    • @MandarinMania
      @MandarinMania  4 місяці тому

      This video also mentions adding audio to CSV: ua-cam.com/video/w_gieyVnKXs/v-deo.html

  • @etdah6642
    @etdah6642 9 місяців тому +1

    Hi. What is the formula for inserting a voice file? Thank you

    • @MandarinMania
      @MandarinMania  4 місяці тому

      I use HyperTTS to automatically add audio: ua-cam.com/video/QYK2GPxksq4/v-deo.html

    • @MandarinMania
      @MandarinMania  4 місяці тому

      I also have a video that discusses adding your own audio via CSV: ua-cam.com/video/w_gieyVnKXs/v-deo.html

  • @acampos8422
    @acampos8422 4 роки тому +1

    Great information. Thank you so much. You explain to the point

  • @hightfly9300
    @hightfly9300 4 роки тому +2

    When I copy the formula, Excel does not let me enter and says I have a problem with the formula ( the '" following the src poses a problem). I have typed in the angle brackets but it still does not work. Have any idea how to fix it ?
    I've tried finding the exact error, on LibreOffice it says error 501 which means there is a problem with the symbols (parentheses opener/closer missing or something like that). It's really frustrating.

    • @MandarinMania
      @MandarinMania  4 роки тому

      Have you tried typing the whole formula without copying and pasting any of it? Some other people reported a problem when pasting.

  • @YusufAlthawadii
    @YusufAlthawadii Рік тому

    I did exactly like the video and everything worked fine but when i flip to view the picture it appears like a line or a slit and i cant see anything, i can view the full picture in edit though.

  • @deep-learning-mastery
    @deep-learning-mastery 2 роки тому +1

    Thank you

  • @savatagedude
    @savatagedude 3 роки тому +1

    Great video!

  • @locnguyenminh2185
    @locnguyenminh2185 4 роки тому +1

    thaks for the video. i love this.

  • @drryanjames93
    @drryanjames93 2 роки тому +1

    I just love your two Anki creation videos. I am, however, having a problem. I typed in the formula as per your instructions, but it is not picking up the names of my image. All it does is re-create the same formula without changes all the way down. Thank you so much for sharing these. Are you planning on any new ones, not specifically for Chinese?

    • @MandarinMania
      @MandarinMania  4 місяці тому

      I took a much-needed break for a while and only saw your comment now...sorry. I hope you solved your problem. If you haven't seen it already, I created a new Anki video on automatically adding audio, that can be used for any language not just Chinese: ua-cam.com/video/QYK2GPxksq4/v-deo.html

    • @drryanjames93
      @drryanjames93 4 місяці тому +1

      @@MandarinMania Thank you, but I have given up on using Anki.

  • @jeanvlinhares
    @jeanvlinhares 3 роки тому +1

    Excuse me! You are my SAVIOR

  • @hoangphuong5664
    @hoangphuong5664 3 роки тому

    Insert picture is not working. Can you help me?

  • @lualejo2015
    @lualejo2015 4 роки тому +1

    Hey there!
    I have pictures that I want to turn into Anki flashcards. Front : Picture 1 - Back: Picture 2. Is it possible to do it by using your method? Thanks in advance!

    • @MandarinMania
      @MandarinMania  4 роки тому +1

      Alejandro Arevalo Yes just base your cards on a note type that has back and front pictures. I discuss note types briefly in this video. If you do not have a note type you can copy and edit a note type to your liking.

    • @lualejo2015
      @lualejo2015 4 роки тому +1

      @@MandarinMania Thank you! A friend of mine actually helped me out thanks to your video. I am glad to report that we have done what we wanted.

    • @shilpa9737
      @shilpa9737 3 роки тому

      @@lualejo2015 hey ,can you please elaborate on how your friend helped?
      because ,even i want to make similar anki flashcards as you.
      or maybe i could connect you on some other social media app?

    • @lualejo2015
      @lualejo2015 2 роки тому

      @@shilpa9737 Hey friend! I am sorry I didn't see your message. Still struggling? I can help you out!

    • @shilpa9737
      @shilpa9737 2 роки тому

      Yeah please,where can I connect you?

  • @monniebiloneyart
    @monniebiloneyart 4 роки тому +2

    or...just hear me out.
    Just put img src="{{Feild}}.png" on the note-type you're importing into...

    • @haja6917
      @haja6917 3 роки тому +1

      this seems good

    • @jeanvlinhares
      @jeanvlinhares 3 роки тому

      Smart!

    • @Mahdi25009
      @Mahdi25009 7 місяців тому

      where do i put this? im having trouble getting the images to work.

    • @monniebiloney
      @monniebiloney 7 місяців тому

      @@Mahdi25009 So your gonna have to learn how to Customizing Card Styling.
      ua-cam.com/video/HgKDRTTTnh4/v-deo.html
      I'd skip to 2:28 but this video seems fine from a glanse.
      Personally, The very first thing I learn about anki was how to find the edit the styling (for example, I have no idea how to do close Q) so I think that parts like, pretty easy. You just copy and past things and the preview window changes.