Hi everyone, I’m building an app to replace (and enhance) the functionality in an existing WordPress website. We have ~ 15,000 ‘summary’ reports, which I will be importing into Glide Big Tables. We also have copies of the ‘Full Text’ that we used to create our summaries. Some ‘Full Texts’ are sma…

[image] mimof: Do you know if the rest of the ‘Full text’ for that report will be truncated during the import, or if it will just ‘drop’ that record? Hopefully it’ll be truncated and imported. I don’t have a sample here that I can use, but I think that would be truncated. [image…

[image] mimof: in an existing WordPress website I would look into exporting the content of the summary reports from WordPress into a CSV file. My only concern would be that 15,000 summary reports feels like a big number, and 50+ pages for some of these reports also sounds big. I have no idea …

[image] Chat and Comments using the Trebuchet Method Project Showcase According to @Jason you can store 1 million characters in a glide table cell. Google sheets limited to 50,000 characters per cell As long as your full text doesn’t contain more than 1 million charac…

Great thanks very much @ThinhDinh and @nathanaelb for your replies. I will check out the ‘Trebuchet Method’ with a small number of examples first, and build it up. Will let you know if it works out.

Why do you need a “Trebuchet Method” here? Wouldn’t each document have its own row?

@ThinhDinh sorry, I misunderstood the quote from Robert Petito that I should check out the Trebuchet Method (I didn’t know what it was so I thought maybe it’s a way to import such data)! But I see you were referring to the 1M character limit per cell. From checking sample files today, I now know th…

Amazing, so helpful, thank you @ThinhDinh . It looks like after the split, I will still manually need to import each of the ~20 files, which is fine. I was thinking there might be a trick for that also, to add the files to a queue for importing one after the other.

It would require interacting with the API. I have only done one file at once, haven’t handled data that large before.

Best approach to import large texts for searching

Ask for Help

ThinhDinh April 5, 2025, 1:17am 3

As long as your full text doesn’t contain more than 1 million characters, I think you’re good to go.

Topic		Replies	Views
Importing a large sheet csv or xlsx into glide table Ask for Help	1	306	February 2, 2023
Unable to import the whole csv file (85megs - 1mil rows) Ask for Help	5	40	November 26, 2025
📤 Allow User to Upload and Import CSV Files Tutorial Community Resources	7	259	September 30, 2025
Excel limit Ask for Help	7	204	June 7, 2024
Glide Import is skipping rows Ask for Help	3	424	May 23, 2023

Best approach to import large texts for searching

Related topics