Ability to Import Spreadsheet Data as an MT Table?

[inner spoke]

Feel like this has probably been done by someone at one point, but is there a method for importing a simple Excel/GoogleDocs srpeadsheet as an MT table for something like what's in the screenshot?

[red valley]

I don't think so. https://discord.com/channels/296230822262865920/1223678776286642226 can pull stuff in from a public google sheet into json format. Would be down to you to load it into a MT table.

[atomic spruce]

I've used https://wiki.rptools.info/index.php/addTableEntry in the past to convert the contents of a folder into a table (music playlist). If you use CONCAT() in Excel, you can turn each row into a macro line that can be run to fill the table.

[red valley]

Ah yes, good point. I forgot to mention that [MTScript] bit!

Doing a bit of searching, BoT does something already from Excel to MT Tables apparently (though not used it myself)
https://forums.rptools.net/viewtopic.php?p=277637&hilit=excel#p277637

[pearl silo]

I've got a lib token that will take copy & paste from Excel. It assumes only one number (rather than a range) for each row, so it might take some tweaking, but other than that, it works.

[inner spoke]

Can you DM to me, maybe?

BTW, I got so sidetracked looking at my old Bot bare-bones example campiang (which only allows import to a specific BoT type of table, apparently, not MT Tables).

But, wow, I started playing with the Weather token included in BoT, which I had never messed with before. Where has -THAT- been all my life??!! LOL. Some impressive coding must have gone into that!

[pearl silo]

Sent.

[inner spoke]

Thank you!

[alpine laurel]

Hey quick question, does this work with libre office?

[pearl silo]

No idea, but it should work with any spreadsheet where columns are separated by Tab characters.

[alpine laurel]

Neat!

[shadow crypt]

And @dire fossil has macros to import/export CSV files, which is probably sufficient for what you want…