How to import scanned documents into Excel

Sdílet
Vložit
  • čas přidán 20. 08. 2024
  • I show the students of my class at WTAMU how to utilize Optical Character Recognition to save time with data entry for excel documents.

Komentáře • 49

  • @RS-ux7sb
    @RS-ux7sb Před 7 lety +3

    This is what I have been looking for for months! Thanks for posting I am going to try to convert today. There is some kind of bonus if I go to the site from you link. Not sure if you want or need bonus credit. I will be doing it later and see if you post a link that you can get credit on . Thanks again for sharing.

    • @thetechwhiz45
      @thetechwhiz45  Před 7 lety +1

      I actually don't get any kickback from using my link, I put up these tutorial videos mainly for people at my work when I see a common problem. Thanks for the kind words! The main way you could help out is by posting comments requesting a topic for a video.

  • @user-kg1tt8pw4t
    @user-kg1tt8pw4t Před 7 měsíci

    boss you are a savior!

  • @anallelysalinas8075
    @anallelysalinas8075 Před 3 lety +4

    Is there an OCR program that I can buy so I don’t have to upload my documents online? For security purpose?

  • @budzbb1826
    @budzbb1826 Před 2 lety

    Thank you! Literally was handed the same task!

  • @esferundito
    @esferundito Před 9 lety +2

    OMG! That´s exactly what I´ve been looking for!! :)

  • @kashifhaleem2673
    @kashifhaleem2673 Před 6 lety

    bundles of thanks dear. GOD BLESS YOU...

  • @omoniyialao7080
    @omoniyialao7080 Před rokem

    Thank you

  • @asiyasura9811
    @asiyasura9811 Před 7 lety +1

    Thank You So much for sharing wonderful technic

  • @shaileshmishra9978
    @shaileshmishra9978 Před 6 lety

    THANK YOU SO MUCH YOU MADE WORK EASY.

  • @elmnycollin1508
    @elmnycollin1508 Před 5 lety +7

    Dude it is nice trick but don’t do that again. Company or organisation data should be kept confidential specially when it involves people’s details. Tell your boss to buy scanner with OCR software. It is cheap. It is ok if it is personal use though. Don’t get fired buddy

  • @Ad2-Inc
    @Ad2-Inc Před 5 lety +1

    Can you can several forms choosing to only capture some of the information from the forms and load the data from the forms into a spreadsheet?

  • @kendrabean606
    @kendrabean606 Před 3 lety +1

    This is so helpful. I have a list of 1000 names, addresses, etc that someone handed over on PAPER and no longer has file access. So this will be a lifesaver. Will let you know how it goes. Oh, quick question! Since there are spaces in addresses but I want the entire address in the same cell, would you recommend a colon or something not typically used in addresses as the delimiter?

  • @mazevlogger8377
    @mazevlogger8377 Před 5 lety

    Thank you for sharing👍

  • @sandrafreeman3869
    @sandrafreeman3869 Před 4 lety +1

    Hi thank you so much for this - it has been such a boon, and I will definitely beginning this a go to try and stop her manually typing each thing in. I am trying to help my daughter out (she's recently bought an interior design business and is trying to supply info for someone to build her website). The problem is if I manage to get an excel sheet as you have just shown above, is there a quick and easy way to merge that into the excel document she has painstakingly been working on? Other than cutting and pasting that is? Thank you again for this video.

    • @thaddeusskye8316
      @thaddeusskye8316 Před rokem

      there is. in short, you set up 2 sheets in a single workbook, on a third sheet choose merge tables. once merged, the other sheets can be deleted or hidden.

  • @andreadecola7329
    @andreadecola7329 Před 2 lety

    what about if i take a picture of a list in a magazine and then move it will that work

  • @mahonysylvia1667
    @mahonysylvia1667 Před 7 lety +1

    thank you its great

  • @besstinafoster5276
    @besstinafoster5276 Před 3 lety

    I have an 8 page document but I can only get the first page to covert. Is there a way to get all the pages to convert?

  • @rachidrachid-uy5vq
    @rachidrachid-uy5vq Před 10 lety +3

    too many thanks

  • @aleathiarasheed2646
    @aleathiarasheed2646 Před 3 lety

    I have a lot of receipts I need to organize into my budge. Personal, Sunshine Beauties; Non-emergency transportation. My computer is referbished and I have a all in one hp printer, please help. I also have office 365

  • @shivshakti4495
    @shivshakti4495 Před 5 lety

    Thanks dude

  • @gmanz5
    @gmanz5 Před 4 lety +1

    um...thanks for telling me what programs you use to record your audio and video 😊

    • @estebanlucas2483
      @estebanlucas2483 Před 3 lety

      A tip : you can watch movies on Kaldrostream. I've been using them for watching a lot of movies lately.

    • @drakebrixton8169
      @drakebrixton8169 Před 3 lety

      @Esteban Lucas definitely, I have been watching on kaldrostream for since december myself :D

  • @walthersinche2351
    @walthersinche2351 Před 3 lety +2

    Hi

  • @rahhd1
    @rahhd1 Před 6 lety +1

    could you share that machine name?

  • @superduperjoi6800
    @superduperjoi6800 Před 4 lety

    Audacity for the win

  • @Grrrmelon
    @Grrrmelon Před 8 lety +2

    How would I do this for receipts?

    • @DJNuckChorris
      @DJNuckChorris Před 8 lety

      There are software solutions built specifically for this task. I'm not really sure what they're called, a Google search may find it. This is mainly for word and excel documents.

  • @scottguilllot6938
    @scottguilllot6938 Před 5 lety

    I have a ton of identical reeipts that I would like to scan and turn into excel files. How do I scan the receipts and have certain words put into headers and the figure after those words put into the column under the created header?
    example..a gas receipt might have several lines and look like this
    gallons 32.58
    driver John Doe
    price per gallon 3.52
    etc result
    etc2 result
    lets say i have 100 of these, so i want the excel sheet to contain the catagories on reciept to be headers, and the values to be stored under their perspective header. How do I accomplish this?

    • @nanaboatemaaboadi1952
      @nanaboatemaaboadi1952 Před 3 lety

      This is what I also want to do. Have you been able to figure it out please? Kindly assist.

  • @nealvitodavanzo5429
    @nealvitodavanzo5429 Před 4 lety

    How to do Multiple pages ?

  • @geoffreygeorge5855
    @geoffreygeorge5855 Před 7 lety +1

    How to do this if the cell are merge?

  • @alhassanagahu5820
    @alhassanagahu5820 Před 4 lety

    Guy! you save my ass today. thanks

  • @Ra40Rob
    @Ra40Rob Před 7 lety +1

    ok can I pick certain data only to create a CSV file, so say I have 20 A4 invoices I want the date, invoice number and total but leave the rest. could a single CSV be created from these mutlipule auto document feed scan? I have to put this data into an excel file, want to save some time(that I dont get paid for!)

    • @DJNuckChorris
      @DJNuckChorris Před 7 lety +1

      With this method the easiest way would be to convert it to an excel document with the site and copy the individual values. There are other methods of OCR that i didn't cover in this video that could be used, but I'm not familiar with one that'll do what you need.

    • @Ra40Rob
      @Ra40Rob Před 7 lety

      thanks

    • @anshulsharma4894
      @anshulsharma4894 Před 5 lety

      @@Ra40Rob Sir, I have an hard copy of data.. Need to convert in to excel... Please help me.

    • @anshulsharma4894
      @anshulsharma4894 Před 5 lety

      I have hard copy data in excel format.. Need to convert in excel means in boxes.... Please guide / help me.. It's really very important.

  • @notfree25
    @notfree25 Před 5 lety

    I thought life story before actual content was a online recipe only meme

  • @matthewschneider8120
    @matthewschneider8120 Před 4 lety

    Is this a secure site

  • @iteefmedia8483
    @iteefmedia8483 Před 3 lety

    Be direct, Alot Of stories For what