Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 41
  • Last Modified:

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?
0
Mike Caldwell
Asked:
Mike Caldwell
1 Solution
 
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 CaldwellDirector of Business Development, AnaquaAuthor 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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now