...
A .CSV standard file will be as follows:
????????? - where is this screen
This same .CSV by column file will be displayed as an Excel workbook. As follows: ????????? - where is this screen
4. Select
4. In the standard .CSV file, select the first column (A).
5. Open the Data tab.
6. Click Convert Text to Columns. ????????? - where is this screen
...
The Conversion Wizard screen is displayed. ????????? - where is this screen
...
7. Click the file type you want to convert. In our example, we will click on the delimited file type because our .CSV file (see screen above point 4) contains commas and tabs separating each field. If our .CSV file displayed the fields in columns and separated by spaces (see example below), we would have clicked on Fixed width.
...
The screen below appears. ????????? - where is this screen
...
9. Choose Semi-colon or Comma depending on what separates your values on your .CSV and make sure that the text indicator qualifier shows “.
10. Click Next. ????????? - where is this screen
...
11. Click End. ????????? - where is this screen Finish.
Your file is displayed .
????????? - where is this screen
...
in the columns mode.
12. Click Save to save your file.
????????? - where is this screen
...
An import is limited to files of 75 000 lines. Make sure that your csv files to import do not exceed this limit. If not, split your files and make more than one import.
...