I have a number of tables in a few documents, and would prefer to put them into a spreadsheet for easier editing and updating. I’ll store the spreadsheet in DTP.
I don’t see any obvious way to move the data out of the table and into a spreadsheet, is there one
I did try copying the table into a spreadsheet (Apple Numbers), but everything ended up in one cell, which is not what I want.
Thanks.
Please remember to provide critical details like what file format you’re referring to. There is no document file type.
Rich Text Document. It has a number of tables in it, created in DTP.
I want to export or copy the tables to an external spreadsheet as csv or similar.
That is just text data, not tabular data.
What version of DEVONthink are you running?
Version 3.9.9.
I inserted tables in the RTF. So the data in the RTF is indeed formatted as a table.
Would there be a straightforward way to put my tables into a spreadsheet?
I inserted tables in the RTF. So the data in the RTF is indeed formatted as a table.
It’s still only text that looks like a table. It’s not actual tabular data, which is required to be used for CSV, TSV, etc.
Would there be a straightforward way to put my tables into a spreadsheet?
It would require scripting in DEVONthink 3, which is feasible but there’s nothing currently built-in or available.
As a test, this is in DEVONthink 4 beta 1…
Note: This does not mean AI is the answer to all such questions. It was a test of capabilities, including various local models (which failed to actually produce a file). Claude Haiku and GPT4o Mini both quickly produced a new sheet.
Interesting as the AI has only access to the plain text of the RTF document, meaning that it was probably helpful to add Table Example: right before the table.
