|
|
|
|
|
|
by kccqzy
440 days ago
|
|
|
Google Sheets does have this feature. But it was fairly recent. Numbers had it for a long time and in any case I still prefer the implementation in Numbers. In Numbers, data is referenced through these tables exclusively while getting rid of sheet-level references; tables in Google Sheets do not go that far. My mental model for tables in Numbers is just sheets but relocatable and multiple can be viewed at the same time. My mental model for tables in Sheets is just it helps me with formatting and with referencing the entirety of the data like an upgraded named range. https://support.google.com/docs/answer/14239833?hl=en |
|
|
In Numbers, you have multiple tables that are entirely separate row:column spaces that can be resized and positioned arbitrarily and independently, with small finite extent by default such that they fit on screen. That UI makes the capability to have multiple tables on one sheet more discoverable, and easier to comprehend what it's doing. When you drag and drop a CSV file onto a Numbers sheet, it creates a new table rather than populating cells in an existing table. When you resize column A in one table, it doesn't affect the column A of any other table.
That finite vs seemingly-infinite distinction is a fundamental difference in conceptualizing what a spreadsheet is, which can have pretty far-reaching consequences. I've encountered programs with a "CSV export" feature that generates a CSV file that's more or less what you'd expect to get if you wrote a report in a single Excel sheet, and then exported that to CSV: you get a file that contains tabular data embedded in it, but so polluted with unrelated text and unstructured metadata that having it as CSV format barely helps with parsing and you'd be better off trying to extract data from HTML.