Importing data: Microsoft Excel

textimport01

  • Click on File/Open
  • In the Look In: box select either the Floppy (A:\) drive or the directory on your hard drive that you saved the file to.
  • In the Files of Type: box choose All Files.
  • Locate your file and double click on it.
  • A Text Import Wizard will appear.
  • Under Choose the file type that best describes you data, select Delimited and hit Next.
  • In step 2, under Delimiters, you will want to put a check mark in the box that says Comma and optionally take the check mark out of Tab.
  • Make sure that the Text Delimiter is ” and hit Next.
  • In step 3, under Column Data Format select Text and hit Finish.
  • You will now see the data you downloaded in the spreadsheet.
BACK


Still didn’t find an answer to you question? Contact us we will be glad to help