Importing data into Excel from other sources can a real headache, especially if you’re copying and pasting from an Internet source. Data that’s exported from a mainframe; from another program such as Microsoft Access, Lotus, Word or Word Perfect, Adobe Acrobat; or from any other text-based source is, generally, an effortless process, because everything can be reduced to a simple ASCII text file.
Excel’s Import and Parsing options use a Wizard to guide you through these processes. Just follow the directions on the screens. Once the data is imported, the challenge is how to properly parse the data, especially if the information in each parsed field has multiple words, lots of punctuation, special characters, or other complications.