Help Me Convert Hard Copy Data to Excel
November 10, 2010 6:29 AM Subscribe
Scanning, Excel, data input help needed. I need to convert info from a lot of hard copy bank statements into a an excel spreadsheet. Have tried scanning directly into xls and it results in a disorganized mess. Have tried to cut and paste from scan created pdf but it will not allow. Please help in automating this process and making my life a much happier place.
posted by mbx to Computers & Internet (9 answers total) 2 users marked this as a favorite
Trying to avoid manual input of hard copy bank statements into an excel spreadsheet. I have moderate excel skills. Although ultimately all the info will end up on one spreadsheet, I do not require it to be imported to that single spreadsheet now. I can combine later. I have received the statements in 3 formats from my client. 1. Basic hard copy. 2. Scanned into a pdf. 3. Scanned into xls. The scanned pdf does not allow cut and paste and it will not allow conversion into a text file. It appears that it was scanned as an image. The xls scan is a disorganized mess and will be more work reformatting than it's worth. Do you have any suggestions for automating this process? Is there a way to setup excel to receive the scanned info more appropriately? Any ideas will help. I need to get these statements into a spreadsheet. We're talking about a 600+ pages of info. Thank you.