Fast Data Entry in Excel

If you are entering lots of data from your hard copy questionnaire to Excel, then, here is a smart way I have discovered to do it, which increases your efficiency more than by 100%. I will illustrate this techniques using example where I am having 100 cases to input in different rows, each case having different response to every column (or question).

Usually you would do this by individually putting in the data  in every cell then moving across by pressing tab and enter. But here is a small trick by which you can increase your speed and avaoid pressing hundreds of tabs unnecessarily.
Trick is simple and explained in video and below-

  1. Input your data into notepad, separating each case by enter
  2. Use find and replace to create a comma separated file, ready for pasting into excel.
  3. Use Excel Text import wizard to import all data, and you are done!

Let me know through your comments about your views on this  trick, or ask me anything if it is not clear to you.

1 thought on “Fast Data Entry in Excel”

Leave a Reply

Your email address will not be published. Required fields are marked *