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:
- In Microsoft Excel, open the file that contains the data you are importing.
- Click Save as, then select Comma Separated Values
(.csv).
- Choose a file name, such as
MyCSVdata
, and click
Save.