Excel is very powerful in dealing with information. And today we will launch 3 methods to import external data into Excel.
In your daily life, you will use some files to store some daily affairs. For example, you will use the text document to store shopping list. But later you need to import external data into Excel to arrange the information. However, you may find that the format of the pasted information in the Excel like this:
Therefore, here we have three methods to import external data into Excel.
Steps of Using Text to Columns Directly
- Copy the information in the Text Document.
- In the Excel file, press the key “Ctrl + v”.
- And in the “Data” ribbon, click the option “Text to Columns”.
- Then in the new window, click “Next”.
- Then set the certain options in the “delimiter”. In this example, you need to input the “:” in the option of “Others”. In your actual Excel, you should set according to your content.
- Click “Next”.
- And then click “Finish”. You can preview the effect in the “Data preview”.
After all the steps, you can see that the numbers in the second column.
Steps of Pasting Using Text Import Wizard
- Copy the information in the text document.
- In the Excel interface, click the arrow below the button of “Paste”.
- In the drop-down menu, click “Use Text Import Wizard”.
- Then a new window will pop up. And the following steps are exactly the step5-step8 in the previous part.
Steps of Opening a Text Document in Excel
- Click “File” on the ribbon.
- Click “Open”.
- In the new window, selected the “Text Files”.
- Then choose your text document.
- And then click “Open”.
And then the “Text Import Wizard” will pop up. The next steps are the same as the step5-step8 in the first method. You can follow the steps to finish the setting.
- Then click “Save” option on the ribbon. And you will see a new window.
- Click “Yes”.
And then the information is all in your new Excel files.
What to Do with Excel Corruption
Corruption in Excel files are likely to happen when the computer meet with virus, malware or other internal and external reasons. Once you notice that your Excel has corrupted, you should try to repair it as soon as possible. We also recommend that you can use the external third party tool to repair Excel files. With the assist of the software, you can get back almost all the information.
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com