To open CSV-file using MS Excel:
- Run MS Excel;
- Open blank workbook;
- Go to tab Data and select From Text;
- In Import Text file Window select BusinessCards.csv file and press “Import”;
- In Text Import Wizard window mark checkbox “Delimited” and press “Next” button;
- Select Tab and Semicolon as delimiters and press “Next” button;
- Select General as Column data format and press “Finish” button;
- Select how you want to view data in workbook and press “OK”.
The delimiters set suggested in step 6 may slightly differ depending on the region. You can always control the output in the Data Preview window to select the needed delimiters.
Comments
0 comments
Article is closed for comments.