Let’s say I have a large table in a tiddler that is generated via list widgets. Is there a way for me to be able to export that table to csv or excel formats for other manipulation?
Thanks in advance!
You can try to mark the whole table with the browser select function. CTRL-C and CTLR-V it directly into Excel. If you are lucky Excel may be able to make sense of an HTML table on “paste”.
What do you mean be “large table”? How many rows / columns?
Has your table TiddlyWiki format (e.g. uses | as separator) or html format (e.g. uses td, tr, …)?
If the first is your table format, then it is a csv one! So you can simply import it in Excel.
First export the tiddler as a tid file, then remove the file header and keep the table, that’s all.
1 Like
Thanks for the answers. The table has about 28 columns and nearly 1800 rows, so it’s a fairly large table. The table is formatted with html and not using the “|” separators. I’ll have to experiment with your suggestions.
After examining the copy/paste idea and the export to tid file idea, I’ve decided that those aren’t quite the right solution for me. The copy/paste concept works just fine, but the table is going to be so large and ever growing that I find that impractical. Exporting as a tid file seems like that is going to be a lot of extra steps to get what I want.
Would it be possible to write a procedure that could export just the table as csv format?
It depends, how your table is created, if there is a list-widget with a filter and tiddlers, that contain the data, it should be possible.
TW can create all sort of output files using templates, so the data-source is important.
Can you provide some more info about your table creation workflow and your data-structure?
Just one question concerning the described export here. Is it also possiple to export each row to differents tids-file or tiddlers ?
Good to see you online @2right4 
When a table is constructed with | separators, within the editor you could select each sections that represents a row and use the excise tool to send each to a new tiddler.
I don’t know if any way to do it all as a single operation, I believe you’d have to perform it for each row that you would want to excise.
So I’m asking these questions with a future TW project in mind.
I am an avid Shortwave Listener and AM band DXer and I currently use a spreadsheet to log all of the stations I hear. I am considering moving this to a TW project. The reason I’m asking about table export to Excel is because I use Google My Maps to show pins for all of the stations I have logged. Importing an Excel spreadsheet is easy with my current method.
If I move to a TW based log, then I would still like to be able to use Google My Maps and import a spreadsheet. There are other import formats, but Excel is easiest.
After I posted my original message, I remembered the Geospatial plugin so I’m looking at that as well.
Here is a screenshot of a portion of my spreadsheet (there are a few more columns to the right):
Aha – OK. An interesting project. Let me recap
- Your “source of truth” is the Excel table
- It’s easy to import into Google My Maps - you want to keep that
- You want to use TW to create new logs
- New logs should be exported to Excel, so it’s easy to import into Google My Maps
- Export / import should work in both directions
Is that right?
A bit of thinking is needed. – No promises.
That’s exactly right. I appreciate the thought experiment.
Just a thought, @pmario and @HistoryBuff, when looking up info for improving the google calendar interface button I got the impression that the API for Google Sheets is quite robust: Google Sheets API ওভারভিউ | Google for Developers
Might be a good place to start? 
TX,
but this is not a possible way, when you work with long Tables (>1000 rows). Will look if perhaps the commander gives a solution on that.
Best