Add a sheet to an Excel file created with Notepad?

Sounds crazy, but a colleague told me one can make a spreadsheet from text data by using tab delineation instead of comma (CSV).  I have a circumstance it which it would be better to produce a tab separated file instead of CSV and then just rename it ".XLS".  I tried it, and it works just fine!  

However, I need to have more than one sheet in the Excel file.  Is there a command that I can put into the text file to cause the data that follows it to be on a new sheet?
LVL 1
Mike CaldwellConsultant to IP industryAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Commented:
Mike,

Even though you changed the extension to ".XLS", Excel will still recognize it as being a tab-delimited text file and treat it accordingly. As such, there is no way to have multiple sheets with a file created this way.

Wayne
0
 
Mike CaldwellConsultant to IP industryAuthor Commented:
I was afraid of that.  At least the TSV is more convenient for my purpose than CSV, which has the same limit.  Thanks Wayne.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.