How do I download and open text files in Excel?
3
Updated November 2022
o Follow the instructions for opening a text file in a text editor above.
o Once the file is open in a text editor, select all by choosing Ctrl + A (PC) or
Command + A (Mac). This will highlight the entire document.
o Copy this text by pressing Ctrl + C (PC) or Command + C (Mac), or right click
and select copy
o Open Microsoft Excel
o Again, select the entire worksheet using Ctrl + A (PC) or Command + A
(Mac).
o On the Home ribbon of Excel, in the Number section, find the dropdown
box. Hoovering the mouse over the dropdown box will display the title as
“Number Format” and the default setting is “General”. Click the dropdown
box and select “Text” to format the entire worksheet.
o Now you can paste in the data you copied in the text editor, using Ctrl + V
(PC) or Command + V (Mac), or right click and select the left paste option.
You may get a message about the size and shape of the data on your
clipboard. If you see this message, click OK.
o Save this worksheet as an Excel file.
Note: You may need to convert certain columns, rows or cells stored as text
back to a number format after using this method. However, ensure that none
of the entries in the column, row or the cells contain dates or CASRN’s. First
select the column, row, or cells that should be formatted as numbers. Return
to the dropdown box used to format the sheet and select “Number”.
• Recommended Option 2: Opening with Excel Text Import Wizard
This method uses the Text Import Wizard in Excel. To use this method, you
may need to have some knowledge about the types of data in each column of
the data you downloaded. Used correctly, this method can also prevent Excel
from erroneously formatting CAS numbers.
o After downloading and saving the text file, open Microsoft Excel.
o Select File ribbon then Open
o Navigate to the downloaded text file and change the file type at the
bottom of the Open window from “All Excel Files” to “All Files”. Select the
saved file on your computer, and click Open
o This will open the Text Import Wizard, which has three steps:
1. Ensure the Original data type is set to Delimited. Leave all other
settings as they are. Click Next to proceed to the next step.