Preparing Excel Files for Data Import

To import data from Microsoft Excel or similar formats, first save it to character-delimited format.

Follow these steps:

  1. In Microsoft Excel, open the file that contains the data you are importing.
  2. Click Save as, then select Comma Separated Values (.csv).
  3. Choose a file name, such as MyCSVdata, and click Save.