Microsoft quietly replaced the comfortable Text Import Wizard from Excel & replaced it with the “Get và Transform” tools. The “Get & Transform” tools offer a lot of options & are very powerful. Unfortunately, they are quite complicated lớn use. Here is what you should now.
Bạn đang xem: Text import wizard
In a hurry? Click on “File” –> “Options” –> “Data” & set the corresponding checkmarks for reactivating the “Text Import Wizard” in Excel. Start the text import by clicking on “Data” –>”Get Data” –> “Legacy Wizards” –>“From Text (Legacy)”.
In Excel 365 (only) 2016 (since version 1704) the “Text Import Wizard” was removed. It was replaced by the powerful “Get & Transform” tools. The “Get và Transform” tools also provide a function lớn import text and CSV files into Excel.
You have the following two options:Luckily, the comfortably “Text Import Wizard” still exists. You can re-activate & use it for importing text and csv files into Excel.Use the import function of the “Get và Transform” tools.
Xem thêm: Tuổi Quý Tỵ Sinh Năm Bao Nhiêu Tuổi, Tuổi Quý Tỵ Hợp Tuổi Nào & Màu Gì
March 19, 2021 at 10:34 pm
Is there a way to lớn always xuất hiện de legacy text import wizard when opening a csv tệp tin from windows file explorer?Im on windows 10 excel 365 & it just opens the cvs as plain text so a I to lớn select all data & use split coloumns.
Leave a comment Cancel reply
Your e-mail address will not be published. Required fields are marked *