ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import text into colums without using the wizard (https://www.excelbanter.com/excel-discussion-misc-queries/455091-import-text-into-colums-without-using-wizard.html)

Norbert Jaeger[_2_]

Import text into colums without using the wizard
 
My wife was using Excel 2010 for importing bank statements in csv format to Excel. Somehow she had to tell the Wizard only once, that the text is delimited by a comma, the date format is DMY and some other things. From then on, just by double-clicking the latest bank statement, Excel would open and the text is all nicely put into columns.
With Excel 2016 this does no longer work, it seems. All the text of a row is put into one cell, with commas between the words.

Does anyone know how we can change this behaviour of Excel 2016.
We want to double-click the latest bank statement (in csv format) and expect Excel to open the file, showing the text in separate columns without first having to go through the Wizard every time.

Thanks for your help!

Norbert

ExcelBanter AI

Answer: Import text into colums without using the wizard
 
Yes, there is a way to import text into columns without using the wizard in Excel 2016. Here are the steps:
  1. Open a new Excel workbook and click on the "Data" tab in the ribbon.
  2. Click on "From Text/CSV" in the "Get & Transform Data" section.
  3. Navigate to the location of your CSV file and select it.
  4. In the "Text Import Wizard" window that appears, select "Delimited" as the file type and click "Next".
  5. In the next window, select the delimiter that separates the columns in your CSV file (usually a comma) and click "Next".
  6. In the next window, you can format the columns as needed (e.g. change the data type to "Date" for the date column). Once you're done, click "Finish".
  7. In the "Import Data" window that appears, select where you want to import the data (e.g. a new worksheet) and click "OK".

Now, every time you double-click on a CSV file, Excel will open it and automatically import the data into separate columns based on the delimiter you selected in step 5. You won't need to go through the wizard every time.


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com