How to import notpad data into excel

I transferred a file from a database that will only save reports in Notepad.
I then, cut and paste the data into Excel. However all of the info is merged
into one cell. How can I format this data, so that it will be a simple
worksheet with more than one cell? i.e. Name, SSN, Home address should all be in different cells

Do i require any software or is there any technique or tool which can help me to import  into excel....

Replies (2)

Got the ans...

In Excel go to File>Open. Select the 'Text File' in drop down Option of "Files of type"(see bottom area). then browse and single click on the file u want to import, after that Open buton automatically gets highlghted and then click to open.

After clicking open, step 1 of step by step windows opens and proceed further acc to ur own requirement.

 

Enjoy importing..

Just use the import option given in Excel- data. or you can use the following option also.

In Excel go to File>Open. Select the Notepad.txt file and OK.

 

Regards,

Abhi

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details