Click Data > Get External Data > From Text to select a file and open the Text Import Wizard.If you are using Excel 2013 or a previous version without the Power Query add-in, you can use Text Import Wizard which shares a similar user interface with Text to Columns wizard. Use Load or Transform Data buttons to load the data directly into your workbook or modify it in the Power Query window respectively.
However, you can change CSV delimiter easily at a dropdown option. Probably, the Power Query guessed the delimiter correctly. Selecting the file opens the Preview window. You can create the connection by using From Text/CSV command in Data > Get & Transform Data. You can find the option in the Preview dialog. Power Query allows you to choose the delimiter when creating a connection.
You can learn more about Power Query at Power Query 101. Excel 2016 has the Power Query features by default. However, Microsoft released it as an add-in. Disclaimer: Power Query has been part of Excel 2010 and Excel 2013 as well.
0 kommentar(er)
