Top tip to help import lists into your CRM database - Vertical Text Selection

After a conference or seminar I often want to import the attendee list into a CRM database. If the organiser has been kind enough, this can be a straightforward exercise when provided with a tabulated format such as tables in a Word document, an Excel spreadsheet, or even HTML tables. Sometimes though you end up with a list where you can see the columns, but they are formatted with spaces instead of tabs or cells, and you get stuck having to either re-type it or do a lot of cutting and pasting.

I used to have a fancy text editor that allowed me to make vertical text selections to save me from this frustration, and until now I thought that was the only way to do it. That was until I read this great tip from Windows Fanatics:

In Word, if you press the ALT key while left clicking the mouse, you can select text vertically as well as horizontally. This could save you hours of re-typing information!