We help IT Professionals succeed at work.

transfer data from notepad to excel

2,483 Views
Last Modified: 2008-08-08
i have data in notepad file ,i want to transfer the data to excel,is it possible?
Comment
Watch Question

Photographer
CERTIFIED EXPERT
Awarded 2007
Top Expert 2008
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
leonard79,

How does the notepad file separate what will eventually become cells in Excel, e.g., are they fixed width, comma delimited, etc.

In Excel, click File-->Open, change the file filter to Text Files (*.prn, *.txt, *.csv") and choose open.  You will get an error of "This file is not in a recognizable format", but click OK anyway.  Follow the steps of the Text Import Wizard and you should be OK.

If the format does not appear to work, you will need to try the various options available, e.g., fixed width/delimited.

Hope this helps.
Scott

Commented:
The first thing to understand is how excel imports data.  Typically when using notepad there are two standard formats: comma and tab.  Excel will import the data into different cells based on where the commas are or where the tabs are located in the notepad file.  I find the best way to import a file into excel is to first use the replace all feature and be creative with what you are replacing to get commas inserted where you would want the data to go into different cells.

Once you have the commas in the file just go to file open.  Change the file type to all files and select the text file.  This will bring you into the import wizard and it will step you through importing the file into excel.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.