Share via

Copy excel 2007 data to notepad.

Anonymous
2015-09-23T09:22:49+00:00

Hello everyone....

                       I am trying to export my excel 2007 data to notepad..But I am not able to get any solution to copy data exactly to the notepad. I need a solution to export my data from excel 2007 to notepad and also from notepad to excel....

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-09-23T09:34:18+00:00

    Please explain what you are doing and why so we have a better idea of what is going on and so that we can make more informed suggestions.

    Notepad is a very simple text editor.  It cannot handle spreadsheets or tables. If you paste from excel, it uses tabs to separate column data.

    Does it have to be Notepad?  Why?

    If it must be Notepad, then you probably should use SAVE AS "CSV" format.  That a text only format with commas separating fields (assumes no text fields with commas!).

    Do you need to maintain table structure?  If you do, then try WordPad.

    Was this answer helpful?

    0 comments
  2. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2015-09-23T09:28:24+00:00

    You can Save it As .csv. Also look into saving as .txt. This way you can import them back into Excel.

    Was this answer helpful?

    0 comments