Sometimes you may want that you will place a text file into a specific range of your worksheet. You will at first think that you have to import the text file in a new workbook and then copy the data and paste it into your range where you wanted to place it. But there is a direct way to do it. 🙂
We are going to import this CSV file into our Excel worksheet at Cell B3.
At first, let’s check the inside view of a CSV file. CSV means comma separated value. In this type of files, values are stored with commas.
Let’s import this CSV file in Cell B3 of our worksheet.
- Choose Data (tab) ➪ Get External Data (Group) ➪ From Text (command). “Import Text File” dialog box will appear.
- Navigate to the folder where you have saved the CSV file “DSE Index.csv”.
- Select the file “DSE Index.csv” from the list, click the Import button. The “Text Import Wizard-Step 1 of 2” dialog box will appear now. If you double-click on “DSE Index.csv” file, direct “Text Import Wizard-Step 1 of 2” dialog box will appear.
- In “Text Import Wizard-Step 1 of 2” dialog box, select the ‘Delimited’ Radio button, then click on the ‘Next’ button, deselect ‘Tab’ and select ‘Comma’ from the ‘Delimiters’ list, and Select ‘Finish’ to end our job with “Text Import Wizard-Step 1 of 2” dialog box.
- When you clicked ‘Finish’, the ‘Import Data’ dialog box will appear. You can choose also “New worksheet” to select a new worksheet to place your CSV values.
- Click OK, and Excel imports the data. Observe the following two images.
Read More: Exporting Data in Excel
Download Working File
Download the working file from the link below: