How to add sheets in the same CSV document like you do in Excel
-
I need to compile data in one document with multiple sheets in it.
How do I do that in NotePad++ -
@HargulS said in How to add sheets in the same CSV document like you do in Excel:
How do I do that in NotePad++
You don’t.
Some explanation of what a text editor is, and how it compares to other types of editing, is found HERE. -
@HargulS - CSV is a plain text format that can be viewed and edited using Notepad++. The CSV file format does not have, nor can it support, the concept of “sheets.”
Excel files are containers that hold multiple objects, including sheets which themselves are stored as sets of objects. While the individual objects stored within an Excel file are plain text they contain many cross referenced details between the objects. Spreadsheet applications such as Excel keep track of the details. It’s not practical to edit the object files using Notepad++ as you likely would break the cross referenced details that Spreadsheet applications rely on.
