There are several ways to import the data into Excel.
One way to import data into Microsoft Excel: click on Data, then click the From Text button in the Get External Data menu. This will bring up the Text Import Wizard.
In the first step, make sure you have Delimited set as the first option.
You can also select which row you would like to start from. In this example, we’re doing the whole thing starting with the first row.
The example data are separated using the ';'.
This will then show your data in columns at the bottom.
The third step simply lets you choose the format of the data, such as numbers, text, or dates. After you’ve done that, just click Finish and the data will be imported into your spreadsheet.
