Question: how to convert text file to csv?
Answer: Select the Data tab., On the far right, click “Get External Data”, then select the “From Text” option., Find the TXT file on your computer and click “Open”., In the first step of the Import Wizard, select “Delimited”.