<div>
I was afraid of that. &nbsp;At least the TSV is more convenient for my purpose than CSV, which has the same limit. &nbsp;Thanks Wayne.
</div>


I was afraid of that.  At least the TSV is more convenient for my purpose than CSV, which has the same limit.  Thanks Wayne.

<div>
<div class="content wysiwyg-content">
Sounds crazy, but a colleague told me one can make a spreadsheet from text data by using tab delineation instead of comma (CSV). &nbsp;I have a circumstance it which it would be better to produce a tab separated file instead of CSV and then just rename it &quot;.XLS&quot;. &nbsp;I tried it, and it works just fine! &nbsp;<br />
<br />
However, I need to have more than one sheet in the Excel file. &nbsp;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?
</div>
</div>


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?

Add a sheet to an Excel file created with Notepad?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.