Converting a scanned document into an Excel document is a fairly straightforward process that can be done in three general steps. First, scan the document in. Second, use an Optical Character Recognition software package (OCR) to convert it to text. Then use Excel's own Text to Excel wizard to bring the information into Excel.
Things You'll Need
- Microsoft Word software
- Microsoft Excel software
- Optical character recognition (OCR) program such as Microsoft Document Imaging
Under Microsoft Office Tools on your Programs menu, open up "Microsoft Office Document Imaging," then open your file. The computer should automatically recognize it, but if not, click the toolbar option labeled "Recognize Text Using OCR". Click the "Export to Word" button.
Name the file using the "Save As" function and pick the file format labeled "plain text" (.txt) from the drop down box. Once you hit "save", a dialog box will open to give you several options. Be sure to mark the "Page Break" option, or Microsoft Word will save the text all on one line. Once done, click Save and then close out of Microsoft Word.
Open up the file in Microsoft Excel. Microsoft Excel has several programs designed to assist users in tasks, called a Wizard. The conversion wizard should automatically launch in any recent version of Excel. Follow the wizard's steps. It is often best to pick "delimited", which is the default. "Delimited" means that the columns of data are separated by some means, such as commas, spaces, or other similar methods. Excel provides a number of options.
Pick the deliminator, which is what separates the columns of data from one another, in Step 2 of the Wizard. If using the Microsoft-provided converter, the choice is probably 'space'.
Specify the formatting of the columns in Excel in Step 3 of the Wizard. Select the column that does not need to be in the default or general format, and change it in the column data format box, which is in the upper right hand corner of the Wizard. When done, hit finish. At the end, the data should be in Excel and ready for use.
How to Convert Scanned Items to Microsoft Excel or Word
Microsoft Excel and Word both have the capacity to accept scanned items that you import. Your scanner converts the documents or images...
How to Convert Scans Into Editable Text with an HP Scanjet
Scanners are very useful peripherals that allow users to create digital copies of physical documents. In regular use, scanners essentially take a...
How to Convert a Scanned Document to Word
Microsoft Word does not have a scanning application, however, Microsoft Office does have a program called Microsoft Office Document Imaging that allows...
How to Scan a Document
The process of scanning a document involves taking a hard copy and digitizing it to a format that a computer can readily...