How to Import Data from TXT to Excel

Date:2019-7-30 Author:Cordelia

Not all the people are used to organize information with Excel all the time. Sometimes we already have the data recorded in Word or TXT and want to import them to Excel for convenience and intuition. How can we convert all the text content into a table?

The first step is organizing the data in notepad. If you’ve collect all the data in Word, then copy them to a new TXT.

How to Import Data from TXT to Excel

The different data items should be separated by spaces or commas or tabs. In my case, I put my cursor in front of each data item and press Tab key to align them.

How to Import Data from TXT to Excel

Then save this TXT at anywhere you like. Open an Excel file, switch to Data tab and choose From Text in Get External Data section.

How to Import Data from TXT to Excel

Find the TXT you just saved in the folder. Double click it or select it then hit Import.

How to Import Data from TXT to Excel

The Text Import Wizard will pop out.

Choose the Original data type as Delimited since I separated those data items with spaces and tabs. Check My data has headers (according to your actual condition). Then hit Next to continue the process.

How to Import Data from TXT to Excel

Check the list of Delimiters according to your situation. For me, I check Tab and Space. How to Import Data from TXT to Excel

In the next step you can select the data format of each column.

How to Import Data from TXT to Excel

After finishing all the settings, click Finish and choose where to output the new table.

How to Import Data from TXT to Excel

Click OK and all the preparations have been made. You can see the imported data in the new table and make some adjustments to it.

How to Import Data from TXT to Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *