Omnibus research spreadsheet template

193 views
Skip to first unread message

Alex Cabal

unread,
Sep 25, 2025, 3:52:39 PM (10 days ago) Sep 25
to Standard Ebooks
Over the years we've done a lot of great research to determine what
works to include in our omnibuses. This is done on spreadsheets which we
compile in https://standardebooks.test/contribute/spreadsheets

However, each producer has their own style of spreadsheet, and this
makes it more difficult to *quickly* review to see what's being
proposed, what we already have collected, and what remains to be included.

With that in mind I've created a new spreadsheet template, which I'd
like for everyone to use when starting new spreadsheets in the future:
https://docs.google.com/spreadsheets/d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU

It includes some basic columns that are common to all omnibus research,
and producers can add their own special columns at the end.

It also has some prebuilt formatting like greying out items that are not
PD yet, and checkboxes to indicate that an item already exists in one of
our omnibuses.

More detailed instructions are here:
https://standardebooks.org/contribute/spreadsheets

I'm happy to entertain suggestions for more default columns, or other
tweaks, if anyone has suggestions. However I want to keep the basic
template both simple and universal - remember you can always add custom
columns at the end.

Now that we have a template, it would be extremely useful - and
extremely tedious - to convert our existing spreadsheets to use our
template. Would anyone be interested in doing working on that?

Hendrik Kaiber

unread,
Sep 25, 2025, 4:07:18 PM (10 days ago) Sep 25
to Standard Ebooks
For my latest spreadsheets I've been putting the titles as Something, The instead of The Something, since I think this makes it easier for ordering, do you think I should keep doing this way or follow your template and put the article in front?

I'll start to convert my spreadsheets for the new format.

--Hendrik

Alex Cabal

unread,
Sep 25, 2025, 4:16:46 PM (10 days ago) Sep 25
to standar...@googlegroups.com
Let's exclude title sorting for now. I think it's more common to sort by
publication year and work type than title in these cases.

To convert your existing spreadsheets, please:

1. Make a copy of the template into your account using File -> Make a copy

2. Remove the example items

3. Put your information into the copy as closely aligned with the
template as possible. Exclude custom columns unless absolutely, truly
necessary.

Let's do one to start with to see how the new template works. Once
you've finished, let me know and we'll take a look. Thanks!

On 9/25/25 3:07 PM, Hendrik Kaiber wrote:
> For my latest spreadsheets I've been putting the titles as /Something,
> The/ instead of /The Something/, since I think this makes it easier for
> ordering, do you think I should keep doing this way or follow your
> template and put the article in front?
>
> I'll start to convert my spreadsheets for the new format.
>
> --Hendrik
> On Thursday, September 25, 2025 at 4:52:39 PM UTC-3 Alex Cabal wrote:
>
> Over the years we've done a lot of great research to determine what
> works to include in our omnibuses. This is done on spreadsheets
> which we
> compile in https://standardebooks.test/contribute/spreadsheets
> <https://standardebooks.test/contribute/spreadsheets>
>
> However, each producer has their own style of spreadsheet, and this
> makes it more difficult to *quickly* review to see what's being
> proposed, what we already have collected, and what remains to be
> included.
>
> With that in mind I've created a new spreadsheet template, which I'd
> like for everyone to use when starting new spreadsheets in the future:
> https://docs.google.com/spreadsheets/
> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU <https://
> docs.google.com/spreadsheets/
> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU>
>
> It includes some basic columns that are common to all omnibus research,
> and producers can add their own special columns at the end.
>
> It also has some prebuilt formatting like greying out items that are
> not
> PD yet, and checkboxes to indicate that an item already exists in
> one of
> our omnibuses.
>
> More detailed instructions are here:
> https://standardebooks.org/contribute/spreadsheets <https://
> standardebooks.org/contribute/spreadsheets>
>
> I'm happy to entertain suggestions for more default columns, or other
> tweaks, if anyone has suggestions. However I want to keep the basic
> template both simple and universal - remember you can always add custom
> columns at the end.
>
> Now that we have a template, it would be extremely useful - and
> extremely tedious - to convert our existing spreadsheets to use our
> template. Would anyone be interested in doing working on that?
>
> --
> You received this message because you are subscribed to the Google
> Groups "Standard Ebooks" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to standardebook...@googlegroups.com
> <mailto:standardebook...@googlegroups.com>.
> To view this discussion visit https://groups.google.com/d/msgid/
> standardebooks/883c05d8-d99f-4cf9-adce-b538c821563dn%40googlegroups.com
> <https://groups.google.com/d/msgid/standardebooks/883c05d8-d99f-4cf9-
> adce-b538c821563dn%40googlegroups.com?utm_medium=email&utm_source=footer>.

Vince

unread,
Sep 25, 2025, 5:02:49 PM (10 days ago) Sep 25
to standar...@googlegroups.com
I think either Year Published should be Date Published, or there should be a Date Published column. What’s typically being categorized in these have multiple works per year, and in order to get them in chronological order for the omnibus, we have to sort on the full publication date, when available. In all the ones I’ve worked on at least, that full publication date is usually available. IOW, I think this common enough it shouldn't be pushed to “Custom column”.

I would also suggest Name, date, and book order columns (of whatever name) for the (main) book the work appears in. Since the books are where most of the transcriptions are coming from, it’s important to have all of that information while working on it, so we can find the story we’re reading in the (almost always multiple) scans. This is again a common thing; I’ve had and needed it on every one of these I’ve done. It can be shunted to custom columns, but that means all of these I’ve done would have custom columns. :)
("Also published in” to me is for when a story is published in more than one paper/magazine, which is common, or for more than one book, which is less so.)
> To unsubscribe from this group and stop receiving emails from it, send an email to standardebook...@googlegroups.com.
> To view this discussion visit https://groups.google.com/d/msgid/standardebooks/a5420f0b-5070-44ba-873e-207f8f99b483%40standardebooks.org.

Alex Cabal

unread,
Sep 25, 2025, 5:51:56 PM (10 days ago) Sep 25
to standar...@googlegroups.com
OK, I changed it to date published.

I think book order, etc., should go in custom columns. For the general
purpose case, which is organizing a list of items to decide where to put
them, that info isn't necessary. However it can certainly useful for
tasks beyond organizing, like putting the actual ebook together.

Hendrik Kaiber

unread,
Sep 25, 2025, 7:45:18 PM (10 days ago) Sep 25
to Standard Ebooks
Another question, when should I add something to "Also published in"? I ask because some authors (like Lovecraft) had their stories compiled in several publications, and adding them doesn't seem very useful.

I started migrating my spreadsheet of Fyodor Dostoesvsky, please take a look and tell me if I'm doing something obviously wrong.

--Hendrik

Alex Cabal

unread,
Sep 25, 2025, 7:47:22 PM (10 days ago) Sep 25
to standar...@googlegroups.com
Hold off for a little while longer, I want to make some minor tweaks.

Also published in is useful to determine if there are items that were
published in multiple collections, which would help decide whether an
omnibus is necessary or if we can publish individual collections.

On 9/25/25 6:45 PM, Hendrik Kaiber wrote:
> Another question, when should I add something to "Also published in"? I
> ask because some authors (like Lovecraft) had their stories compiled in
> several publications, and adding them doesn't seem very useful.
>
> I started migrating my spreadsheet of Fyodor Dostoesvsky <https://
> docs.google.com/spreadsheets/
> d/1jv0oZdFmcsoiqEfAu1wL_J22vhUDXzCWYWHSU9x_uP4/edit?usp=sharing>, please
> >>> <https://standardebooks.test/contribute/spreadsheets <https://
> standardebooks.test/contribute/spreadsheets>>
> >>> However, each producer has their own style of spreadsheet, and
> this
> >>> makes it more difficult to *quickly* review to see what's being
> >>> proposed, what we already have collected, and what remains to be
> >>> included.
> >>> With that in mind I've created a new spreadsheet template,
> which I'd
> >>> like for everyone to use when starting new spreadsheets in the
> future:
> >>> https://docs.google.com/spreadsheets/ <https://docs.google.com/
> spreadsheets/>
> >>> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU <https://
> >>> docs.google.com/spreadsheets/ <http://docs.google.com/
> spreadsheets/>
> >>> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU>
> >>> It includes some basic columns that are common to all omnibus
> research,
> >>> and producers can add their own special columns at the end.
> >>> It also has some prebuilt formatting like greying out items
> that are
> >>> not
> >>> PD yet, and checkboxes to indicate that an item already exists in
> >>> one of
> >>> our omnibuses.
> >>> More detailed instructions are here:
> >>> https://standardebooks.org/contribute/spreadsheets <https://
> standardebooks.org/contribute/spreadsheets> <https://
> >>> standardebooks.org/contribute/spreadsheets <http://
> standardebooks.org/contribute/spreadsheets>>
> >>> I'm happy to entertain suggestions for more default columns, or
> other
> >>> tweaks, if anyone has suggestions. However I want to keep the
> basic
> >>> template both simple and universal - remember you can always
> add custom
> >>> columns at the end.
> >>> Now that we have a template, it would be extremely useful - and
> >>> extremely tedious - to convert our existing spreadsheets to use
> our
> >>> template. Would anyone be interested in doing working on that?
> >>> --
> >>> You received this message because you are subscribed to the
> Google Groups "Standard Ebooks" group.
> >>> To unsubscribe from this group and stop receiving emails from
> it, send an email to standardebook...@googlegroups.com
> <mailto:standardebook...@googlegroups.com>.
> >>> To view this discussion visit https://groups.google.com/d/
> msgid/ <https://groups.google.com/d/msgid/> standardebooks/883c05d8-
> d99f-4cf9-adce-b538c821563dn%40googlegroups.com
> <http://40googlegroups.com> <https://groups.google.com/d/msgid/
> standardebooks/883c05d8-d99f-4cf9- <https://groups.google.com/d/
> msgid/standardebooks/883c05d8-d99f-4cf9-> adce-
> b538c821563dn%40googlegroups.com?utm_medium=email&utm_source=footer
> <http://40googlegroups.com?utm_medium=email&utm_source=footer>>.
> >>
> >> --
> >> You received this message because you are subscribed to the
> Google Groups "Standard Ebooks" group.
> >> To unsubscribe from this group and stop receiving emails from
> it, send an email to standardebook...@googlegroups.com.
> >> To view this discussion visit https://groups.google.com/d/msgid/
> standardebooks/
> a5420f0b-5070-44ba-873e-207f8f99b483%40standardebooks.org <https://
> groups.google.com/d/msgid/standardebooks/
> a5420f0b-5070-44ba-873e-207f8f99b483%40standardebooks.org>.
> >
>
> --
> You received this message because you are subscribed to the Google
> Groups "Standard Ebooks" group.
> To unsubscribe from this group and stop receiving emails from it, send
> standardebooks/270b0363-8eee-4278-adc1-282396c75bb0n%40googlegroups.com
> <https://groups.google.com/d/msgid/standardebooks/270b0363-8eee-4278-
> adc1-282396c75bb0n%40googlegroups.com?utm_medium=email&utm_source=footer>.

Alex Cabal

unread,
Sep 25, 2025, 10:51:12 PM (10 days ago) Sep 25
to standar...@googlegroups.com
OK, I made some tweaks to the template and imported your spreadsheet
into it.

You can make a copy from
https://docs.google.com/spreadsheets/d/1T4mK-ehA9OvMAThIc6nw1xrr6gMiN4aK0oTjbJsiWW4/edit?gid=0#gid=0
and then finish up your edits.

Let me know when you're done. Thanks!

On 9/25/25 6:45 PM, Hendrik Kaiber wrote:
> Another question, when should I add something to "Also published in"? I
> ask because some authors (like Lovecraft) had their stories compiled in
> several publications, and adding them doesn't seem very useful.
>
> I started migrating my spreadsheet of Fyodor Dostoesvsky <https://
> docs.google.com/spreadsheets/
> d/1jv0oZdFmcsoiqEfAu1wL_J22vhUDXzCWYWHSU9x_uP4/edit?usp=sharing>, please
> >>> <https://standardebooks.test/contribute/spreadsheets <https://
> standardebooks.test/contribute/spreadsheets>>
> >>> However, each producer has their own style of spreadsheet, and
> this
> >>> makes it more difficult to *quickly* review to see what's being
> >>> proposed, what we already have collected, and what remains to be
> >>> included.
> >>> With that in mind I've created a new spreadsheet template,
> which I'd
> >>> like for everyone to use when starting new spreadsheets in the
> future:
> >>> https://docs.google.com/spreadsheets/ <https://docs.google.com/
> spreadsheets/>
> >>> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU <https://
> >>> docs.google.com/spreadsheets/ <http://docs.google.com/
> spreadsheets/>
> >>> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU>
> >>> It includes some basic columns that are common to all omnibus
> research,
> >>> and producers can add their own special columns at the end.
> >>> It also has some prebuilt formatting like greying out items
> that are
> >>> not
> >>> PD yet, and checkboxes to indicate that an item already exists in
> >>> one of
> >>> our omnibuses.
> >>> More detailed instructions are here:
> >>> https://standardebooks.org/contribute/spreadsheets <https://
> standardebooks.org/contribute/spreadsheets> <https://
> >>> standardebooks.org/contribute/spreadsheets <http://
> standardebooks.org/contribute/spreadsheets>>
> >>> I'm happy to entertain suggestions for more default columns, or
> other
> >>> tweaks, if anyone has suggestions. However I want to keep the
> basic
> >>> template both simple and universal - remember you can always
> add custom
> >>> columns at the end.
> >>> Now that we have a template, it would be extremely useful - and
> >>> extremely tedious - to convert our existing spreadsheets to use
> our
> >>> template. Would anyone be interested in doing working on that?
> >>> --
> >>> You received this message because you are subscribed to the
> Google Groups "Standard Ebooks" group.
> >>> To unsubscribe from this group and stop receiving emails from
> it, send an email to standardebook...@googlegroups.com
> <mailto:standardebook...@googlegroups.com>.
> >>> To view this discussion visit https://groups.google.com/d/
> msgid/ <https://groups.google.com/d/msgid/> standardebooks/883c05d8-
> d99f-4cf9-adce-b538c821563dn%40googlegroups.com
> <http://40googlegroups.com> <https://groups.google.com/d/msgid/
> standardebooks/883c05d8-d99f-4cf9- <https://groups.google.com/d/
> msgid/standardebooks/883c05d8-d99f-4cf9-> adce-
> b538c821563dn%40googlegroups.com?utm_medium=email&utm_source=footer
> <http://40googlegroups.com?utm_medium=email&utm_source=footer>>.
> >>
> >> --
> >> You received this message because you are subscribed to the
> Google Groups "Standard Ebooks" group.
> >> To unsubscribe from this group and stop receiving emails from
> it, send an email to standardebook...@googlegroups.com.
> >> To view this discussion visit https://groups.google.com/d/msgid/
> standardebooks/
> a5420f0b-5070-44ba-873e-207f8f99b483%40standardebooks.org <https://
> groups.google.com/d/msgid/standardebooks/
> a5420f0b-5070-44ba-873e-207f8f99b483%40standardebooks.org>.
> >
>
> --
> You received this message because you are subscribed to the Google
> Groups "Standard Ebooks" group.
> To unsubscribe from this group and stop receiving emails from it, send

Alex Cabal

unread,
Sep 25, 2025, 10:57:36 PM (10 days ago) Sep 25
to standar...@googlegroups.com
Actually, I gave you edit access to the sheet on the SE account, so just
edit that directly. Thanks!

Alex Cabal

unread,
Sep 26, 2025, 6:41:58 PM (9 days ago) Sep 26
to standar...@googlegroups.com
I see some people are updating their spreadsheets to the new format.
Please let me know when you do that, as I'm still making small tweaks to
the template.

I've organized the spreadsheets page to list those that are in the new
format vs the legacy format. If you want to edit any that are in the new
format, let me know so I can give you access.

Lukas Bystricky

unread,
Sep 28, 2025, 4:10:27 AM (8 days ago) Sep 28
to Standard Ebooks
I wanted to edit the Somerset Maugham spreadsheet that I made a few years ago, but the link is invalid. The most likely explanation is that I deleted it from my Google drive, but maybe you have a copy somewhere on your end Alex? Not a huge deal either way since I basically copied the data from here, and I guess re-copying it from there wouldn't be much more work than copying it from an unorganized spreadsheet. 

Do you want us to include short work that is already on SE, but not part of an omnibus? For Maugham I'm thinking specifically of Ashenden and On a Chinese Screen. They're not really relevant for future productions, but maybe for research purposes it's good to note that we are aware of them and that they don't need to go into an omnibus, especially since some of the works may have alternate titles. 

Alex Cabal

unread,
Sep 28, 2025, 2:48:21 PM (7 days ago) Sep 28
to standar...@googlegroups.com
I don't have a copy, no. You might just have to start over.

I think Ashenden was a kind of compilation? They are a series of shorts.
So yes they should go in the spreadsheet so that we have a complete
overview of where all his short fiction fits. You can also add Chinese
Screen since I think it was first published in one volume but perhaps
some of the vignettes may have been anthologized later.

On 9/28/25 3:10 AM, Lukas Bystricky wrote:
> I wanted to edit the Somerset Maugham spreadsheet that I made a few
> years ago, but the link is invalid. The most likely explanation is that
> I deleted it from my Google drive, but maybe you have a copy somewhere
> on your end Alex? Not a huge deal either way since I basically copied
> the data from here <https://www.mymaughamcollection.com/p/free-ebook-
> short-stories.html#ss>, and I guess re-copying it from there wouldn't be
> much more work than copying it from an unorganized spreadsheet.
>
> Do you want us to include short work that is already on SE, but not part
> of an omnibus? For Maugham I'm thinking specifically of Ashenden
> <https://standardebooks.org/ebooks/w-somerset-maugham/ashenden> and On a
> Chinese Screen <https://standardebooks.org/ebooks/w-somerset-maugham/on-
> a-chinese-screen>. They're not really relevant for future productions,
> but maybe for research purposes it's good to note that we are aware of
> them and that they don't need to go into an omnibus, especially since
> some of the works may have alternate titles.
>
> On Saturday, September 27, 2025 at 12:41:58 AM UTC+2 Alex Cabal wrote:
>
> I see some people are updating their spreadsheets to the new format.
> Please let me know when you do that, as I'm still making small
> tweaks to
> the template.
>
> I've organized the spreadsheets page to list those that are in the new
> format vs the legacy format. If you want to edit any that are in the
> new
> format, let me know so I can give you access.
>
> On 9/25/25 9:57 PM, Alex Cabal wrote:
> > Actually, I gave you edit access to the sheet on the SE account,
> so just
> > edit that directly. Thanks!
> >
> > On 9/25/25 9:51 PM, Alex Cabal wrote:
> >> OK, I made some tweaks to the template and imported your
> spreadsheet
> >> into it.
> >>
> >> You can make a copy from https://docs.google.com/spreadsheets/
> d/1T4mK- <https://docs.google.com/spreadsheets/d/1T4mK->
> >> ehA9OvMAThIc6nw1xrr6gMiN4aK0oTjbJsiWW4/edit?gid=0#gid=0 and then
> >> finish up your edits.
> >>
> >> Let me know when you're done. Thanks!
> >>
> >> On 9/25/25 6:45 PM, Hendrik Kaiber wrote:
> >>> Another question, when should I add something to "Also
> published in"?
> >>> I ask because some authors (like Lovecraft) had their stories
> >>> compiled in several publications, and adding them doesn't seem
> very
> >>> useful.
> >>>
> >>> I started migrating my spreadsheet of Fyodor Dostoesvsky <https://
> >>> docs.google.com/spreadsheets/ <http://docs.google.com/
> spreadsheets <https://standardebooks.test/contribute/spreadsheets>
> >>>     <https://standardebooks.test/contribute/spreadsheets
> <https://standardebooks.test/contribute/spreadsheets>>
> >>>      >>> <https://standardebooks.test/contribute/spreadsheets
> <https://standardebooks.test/contribute/spreadsheets> <https://
> >>>     standardebooks.test/contribute/spreadsheets>>
> >>>      >>> However, each producer has their own style of
> spreadsheet, and
> >>>     this
> >>>      >>> makes it more difficult to *quickly* review to see
> what's being
> >>>      >>> proposed, what we already have collected, and what
> remains
> >>> to be
> >>>      >>> included.
> >>>      >>> With that in mind I've created a new spreadsheet
> template,
> >>>     which I'd
> >>>      >>> like for everyone to use when starting new
> spreadsheets in the
> >>>     future:
> >>>      >>> https://docs.google.com/spreadsheets/ <https://
> docs.google.com/spreadsheets/> <https://docs.google.com/ <https://
> docs.google.com/>
> >>>     spreadsheets/>
> >>>      >>> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU <https://
> >>>      >>> docs.google.com/spreadsheets/ <http://docs.google.com/
> spreadsheets/> <http://docs.google.com/ <http://docs.google.com/>
> >>>     spreadsheets/>
> >>>      >>> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU>
> >>>      >>> It includes some basic columns that are common to all
> omnibus
> >>>     research,
> >>>      >>> and producers can add their own special columns at the
> end.
> >>>      >>> It also has some prebuilt formatting like greying out
> items
> >>>     that are
> >>>      >>> not
> >>>      >>> PD yet, and checkboxes to indicate that an item already
> >>> exists in
> >>>      >>> one of
> >>>      >>> our omnibuses.
> >>>      >>> More detailed instructions are here:
> >>>      >>> https://standardebooks.org/contribute/spreadsheets
> <https://standardebooks.org/contribute/spreadsheets> <https://
> standardebooks.org/contribute/spreadsheets> <http://
> groups.google.com/d/ <https://groups.google.com/d/>
> >>>     msgid/ <https://groups.google.com/d/msgid/ <https://
> groups.google.com/d/msgid/>> standardebooks/883c05d8-
> >>>     d99f-4cf9-adce-b538c821563dn%40googlegroups.com
> <http://40googlegroups.com>
> >>>     <http://40googlegroups.com <http://40googlegroups.com>>
> <https://groups.google.com/d/msgid/ <https://groups.google.com/d/
> msgid/>
> >>>     standardebooks/883c05d8-d99f-4cf9- <https://
> groups.google.com/d/ <https://groups.google.com/d/>
> >>>     msgid/standardebooks/883c05d8-d99f-4cf9-> adce-
> >>>     b538c821563dn%40googlegroups.com?
> utm_medium=email&utm_source=footer <http://40googlegroups.com?
> utm_medium=email&utm_source=footer>
> >>>     <http://40googlegroups.com?
> utm_medium=email&utm_source=footer <http://40googlegroups.com?
> utm_medium=email&utm_source=footer>>>.
> >>>      >>
> >>>      >> --
> >>>      >> You received this message because you are subscribed to
> the
> >>>     Google Groups "Standard Ebooks" group.
> >>>      >> To unsubscribe from this group and stop receiving
> emails from
> >>>     it, send an email to standardebook...@googlegroups.com.
> >>>      >> To view this discussion visit https://
> groups.google.com/d/msgid/ <https://groups.google.com/d/msgid/>
> >>>     standardebooks/
> >>>     a5420f0b-5070-44ba-873e-207f8f99b483%40standardebooks.org
> <http://40standardebooks.org> <https://
> >>> groups.google.com/d/msgid/standardebooks/ <http://
> groups.google.com/d/msgid/standardebooks/>
> >>>     a5420f0b-5070-44ba-873e-207f8f99b483%40standardebooks.org
> <http://40standardebooks.org>>.
> >>>      >
> >>>
> >>> --
> >>> You received this message because you are subscribed to the Google
> >>> Groups "Standard Ebooks" group.
> >>> To unsubscribe from this group and stop receiving emails from it,
> >>> send an email to standardebook...@googlegroups.com
> >>> <mailto:standardebook...@googlegroups.com>.
> >>> To view this discussion visit https://groups.google.com/d/
> msgid/ <https://groups.google.com/d/msgid/>
> >>> standardebooks/270b0363-8eee-4278-
> >>> adc1-282396c75bb0n%40googlegroups.com
> <http://40googlegroups.com> <https://groups.google.com/d/ <https://
> groups.google.com/d/>
> >>> msgid/standardebooks/270b0363-8eee-4278-
> >>> adc1-282396c75bb0n%40googlegroups.com <http://40googlegroups.com>?
> >>> utm_medium=email&utm_source=footer>.
> >>
> >
>
> --
> You received this message because you are subscribed to the Google
> Groups "Standard Ebooks" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to standardebook...@googlegroups.com
> <mailto:standardebook...@googlegroups.com>.
> To view this discussion visit https://groups.google.com/d/msgid/
> standardebooks/44e9c6f5-8bae-4b1b-ad45-98f86b82dd9bn%40googlegroups.com
> <https://groups.google.com/d/msgid/standardebooks/44e9c6f5-8bae-4b1b-
> ad45-98f86b82dd9bn%40googlegroups.com?utm_medium=email&utm_source=footer>.

Lukas Bystricky

unread,
Sep 30, 2025, 1:54:38 AM (6 days ago) Sep 30
to Standard Ebooks
Ashenden wasn't really a compilation. A few of the stories were published in magazines first, but most were first published as part of a collection called Ashenden. 

Anyways, I've redone the spreadsheet. For future reference, are you planning to host a copy on your end? I should probably be more careful when cleaning out my Google Drive anyways. 

Apparently Daphne Du Maurier has a few public domain stories, so I'm also working a spreadsheet for her.  



Alex Cabal

unread,
Sep 30, 2025, 11:20:21 AM (5 days ago) Sep 30
to standar...@googlegroups.com
Can you give me access?

Yes, from now on I'm going to make a copy to the SE account, and give
the person in charge editor access so they can edit that copy instead.
That way we won't lose spreadsheets in the future.

On 9/30/25 12:54 AM, Lukas Bystricky wrote:
> Ashenden wasn't really a compilation. A few of the stories were
> published in magazines first, but most were first published as part of a
> collection called Ashenden.
>
> Anyways, I've redone the spreadsheet <https://docs.google.com/
> spreadsheets/d/1v5yIrJktpK-8qXkn7b1mnmjxxiRF9Bt2JlaN-nUTb2g/edit?
> gid=0#gid=0>. For future reference, are you planning to host a copy on
> your end? I should probably be more careful when cleaning out my Google
> Drive anyways.
>
> Apparently Daphne Du Maurier has a few public domain stories, so I'm
> also working a spreadsheet for her.
>
>
>
> On Sunday, September 28, 2025 at 8:48:21 PM UTC+2 Alex Cabal wrote:
>
> I don't have a copy, no. You might just have to start over.
>
> I think Ashenden was a kind of compilation? They are a series of
> shorts.
> So yes they should go in the spreadsheet so that we have a complete
> overview of where all his short fiction fits. You can also add Chinese
> Screen since I think it was first published in one volume but perhaps
> some of the vignettes may have been anthologized later.
>
> On 9/28/25 3:10 AM, Lukas Bystricky wrote:
> > I wanted to edit the Somerset Maugham spreadsheet that I made a few
> > years ago, but the link is invalid. The most likely explanation
> is that
> > I deleted it from my Google drive, but maybe you have a copy
> somewhere
> > on your end Alex? Not a huge deal either way since I basically
> copied
> > the data from here <https://www.mymaughamcollection.com/p/free-
> ebook- <https://www.mymaughamcollection.com/p/free-ebook->
> > short-stories.html#ss>, and I guess re-copying it from there
> wouldn't be
> > much more work than copying it from an unorganized spreadsheet.
> >
> > Do you want us to include short work that is already on SE, but
> not part
> > of an omnibus? For Maugham I'm thinking specifically of Ashenden
> > <https://standardebooks.org/ebooks/w-somerset-maugham/ashenden
> <https://standardebooks.org/ebooks/w-somerset-maugham/ashenden>> and
> On a
> > Chinese Screen <https://standardebooks.org/ebooks/w-somerset-
> maugham/on- <https://standardebooks.org/ebooks/w-somerset-maugham/on->
> > d/1T4mK- <https://docs.google.com/spreadsheets/d/1T4mK- <https://
> docs.google.com/spreadsheets/d/1T4mK->>
> > >> ehA9OvMAThIc6nw1xrr6gMiN4aK0oTjbJsiWW4/edit?gid=0#gid=0 and then
> > >> finish up your edits.
> > >>
> > >> Let me know when you're done. Thanks!
> > >>
> > >> On 9/25/25 6:45 PM, Hendrik Kaiber wrote:
> > >>> Another question, when should I add something to "Also
> > published in"?
> > >>> I ask because some authors (like Lovecraft) had their stories
> > >>> compiled in several publications, and adding them doesn't seem
> > very
> > >>> useful.
> > >>>
> > >>> I started migrating my spreadsheet of Fyodor Dostoesvsky
> <https://
> > >>> docs.google.com/spreadsheets/ <http://docs.google.com/
> spreadsheets/> <http://docs.google.com/ <http://docs.google.com/>
> > spreadsheets/>
> > >>> d/1jv0oZdFmcsoiqEfAu1wL_J22vhUDXzCWYWHSU9x_uP4/edit?
> docs.google.com/spreadsheets/> <https://
> > docs.google.com/spreadsheets/ <http://docs.google.com/
> spreadsheets/>> <https://docs.google.com/ <https://docs.google.com/>
> <https://
> > docs.google.com/ <http://docs.google.com/>>
> > <https://standardebooks.org/contribute/spreadsheets <https://
> standardebooks.org/contribute/spreadsheets>> <http://
> > groups.google.com/d/ <http://groups.google.com/d/> <https://
> groups.google.com/d/msgid/> <https://
> > groups.google.com/d/msgid/ <http://groups.google.com/d/msgid/>>>
> msgid/> <https://groups.google.com/d/ <https://groups.google.com/d/>
> > msgid/>
> > >>>     standardebooks/883c05d8-d99f-4cf9- <https://
> > groups.google.com/d/ <http://groups.google.com/d/> <https://
> groups.google.com/d/ <https://groups.google.com/d/>>
> > >>>     msgid/standardebooks/883c05d8-d99f-4cf9-> adce-
> > >>>     b538c821563dn%40googlegroups.com
> <http://40googlegroups.com>?
> > utm_medium=email&utm_source=footer <http://40googlegroups.com
> <http://40googlegroups.com>?
> > utm_medium=email&utm_source=footer>
> > >>>     <http://40googlegroups.com <http://40googlegroups.com>?
> > utm_medium=email&utm_source=footer <http://40googlegroups.com
> <http://40googlegroups.com>?
> > utm_medium=email&utm_source=footer>>>.
> > >>>      >>
> > >>>      >> --
> > >>>      >> You received this message because you are subscribed to
> > the
> > >>>     Google Groups "Standard Ebooks" group.
> > >>>      >> To unsubscribe from this group and stop receiving
> > emails from
> > >>>     it, send an email to standardebook...@googlegroups.com.
> > >>>      >> To view this discussion visit https://
> > groups.google.com/d/msgid/ <http://groups.google.com/d/msgid/>
> <https://groups.google.com/d/msgid/ <https://groups.google.com/d/
> msgid/>>
> > >>>     standardebooks/
> > >>>     a5420f0b-5070-44ba-873e-207f8f99b483%40standardebooks.org
> <http://40standardebooks.org>
> > <http://40standardebooks.org <http://40standardebooks.org>>
> <https://
> > >>> groups.google.com/d/msgid/standardebooks/ <http://
> groups.google.com/d/msgid/standardebooks/> <http://
> > <http://40standardebooks.org <http://40standardebooks.org>>>.
> > >>>      >
> > >>>
> > >>> --
> > >>> You received this message because you are subscribed to the
> Google
> > >>> Groups "Standard Ebooks" group.
> > >>> To unsubscribe from this group and stop receiving emails from
> it,
> > >>> send an email to standardebook...@googlegroups.com
> > >>> <mailto:standardebook...@googlegroups.com>.
> > >>> To view this discussion visit https://groups.google.com/d/
> > >>> standardebooks/270b0363-8eee-4278-
> > >>> adc1-282396c75bb0n%40googlegroups.com
> groups.google.com/d/ <https://groups.google.com/d/> <https://
> > groups.google.com/d/ <http://groups.google.com/d/>>
> > >>> msgid/standardebooks/270b0363-8eee-4278-
> > >>> adc1-282396c75bb0n%40googlegroups.com
> <http://40googlegroups.com> <http://40googlegroups.com
> <http://40googlegroups.com>>?
> > >>> utm_medium=email&utm_source=footer>.
> > >>
> > >
> >
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Standard Ebooks" group.
> > To unsubscribe from this group and stop receiving emails from it,
> send
> > an email to standardebook...@googlegroups.com
> > <mailto:standardebook...@googlegroups.com>.
> > To view this discussion visit https://groups.google.com/d/msgid/
> <https://groups.google.com/d/msgid/>
> > standardebooks/44e9c6f5-8bae-4b1b-
> ad45-98f86b82dd9bn%40googlegroups.com <http://40googlegroups.com>
> > <https://groups.google.com/d/msgid/
> standardebooks/44e9c6f5-8bae-4b1b- <https://groups.google.com/d/
> msgid/standardebooks/44e9c6f5-8bae-4b1b->
> > ad45-98f86b82dd9bn%40googlegroups.com?
> utm_medium=email&utm_source=footer <http://40googlegroups.com?
> utm_medium=email&utm_source=footer>>.
>
> --
> You received this message because you are subscribed to the Google
> Groups "Standard Ebooks" group.
> To unsubscribe from this group and stop receiving emails from it, send
> standardebooks/dbeb2b43-6027-4d24-84c2-c5c64ed5b61fn%40googlegroups.com
> <https://groups.google.com/d/msgid/standardebooks/
> dbeb2b43-6027-4d24-84c2-c5c64ed5b61fn%40googlegroups.com?
> utm_medium=email&utm_source=footer>.

Hendrik Kaiber

unread,
Sep 30, 2025, 11:34:21 AM (5 days ago) Sep 30
to Standard Ebooks
I also started a spreadsheet for the works of Edith Wharton. I sent you editor access, Alex.

--Hendrik

Lukas Bystricky

unread,
Sep 30, 2025, 12:22:52 PM (5 days ago) Sep 30
to Standard Ebooks
Whoops, sorry.  You should have access now.

Here's the spreadsheet for Du Maurier. I think I'd like to start producing it. I'll start a thread shortly.

Alex Cabal

unread,
Sep 30, 2025, 12:33:21 PM (5 days ago) Sep 30
to standar...@googlegroups.com
Great, thanks. I've cloned the Maugham sheet so please work on this copy
from now on:

https://docs.google.com/spreadsheets/d/1OYPAAycKaTUZDM9y_m4a4tpfYeTzkmVM2boQxfl68l0/edit?gid=0#gid=0

Here is the Du Maurier copy for you to work from:

https://docs.google.com/spreadsheets/d/1fjsN_XWap97TwESdl20QtEusFZprhPqOGA9WEot2a8o/edit?gid=0#gid=0

Thanks!

On 9/30/25 11:22 AM, Lukas Bystricky wrote:
> Whoops, sorry.  You should have access now.
>
> Here's the spreadsheet <https://docs.google.com/spreadsheets/
> d/1hUmksXB9teoO7jmkly-Qpm79rW35_-VunwcO8-GGXtw/edit?usp=sharing> for Du
> Maurier. I think I'd like to start producing it. I'll start a thread
> shortly.
>
>
> On Tuesday, September 30, 2025 at 5:34:21 PM UTC+2 hendrik....@gmail.com
> wrote:
>
> I also started a spreadsheet <https://docs.google.com/spreadsheets/
> d/1pmgPQVoFUjcLvFw5IUDday7JRP9KrX2amJFAWhq4Aag/edit?gid=0#gid=0> for
> the works of Edith Wharton. I sent you editor access, Alex.
>
> --Hendrik
>
> On Tuesday, September 30, 2025 at 12:20:21 PM UTC-3 Alex Cabal wrote:
>
> Can you give me access?
>
> Yes, from now on I'm going to make a copy to the SE account, and
> give
> the person in charge editor access so they can edit that copy
> instead.
> That way we won't lose spreadsheets in the future.
>
> On 9/30/25 12:54 AM, Lukas Bystricky wrote:
> > Ashenden wasn't really a compilation. A few of the stories were
> > published in magazines first, but most were first published
> as part of a
> > collection called Ashenden.
> >
> > Anyways, I've redone the spreadsheet <https://
> docs.google.com/ <https://docs.google.com/>
> > spreadsheets/d/1v5yIrJktpK-8qXkn7b1mnmjxxiRF9Bt2JlaN-nUTb2g/
> free- <https://www.mymaughamcollection.com/p/free->
> > ebook- <https://www.mymaughamcollection.com/p/free-ebook-
> <https://www.mymaughamcollection.com/p/free-ebook->>
> > > short-stories.html#ss>, and I guess re-copying it from there
> > wouldn't be
> > > much more work than copying it from an unorganized
> spreadsheet.
> > >
> > > Do you want us to include short work that is already on SE,
> but
> > not part
> > > of an omnibus? For Maugham I'm thinking specifically of
> Ashenden
> > > <https://standardebooks.org/ebooks/w-somerset-maugham/
> ashenden <https://standardebooks.org/ebooks/w-somerset-maugham/
> ashenden>
> > <https://standardebooks.org/ebooks/w-somerset-maugham/
> ashenden <https://standardebooks.org/ebooks/w-somerset-maugham/
> ashenden>>> and
> > On a
> > > Chinese Screen <https://standardebooks.org/ebooks/w-
> somerset- <https://standardebooks.org/ebooks/w-somerset->
> > maugham/on- <https://standardebooks.org/ebooks/w-somerset-
> maugham/on- <https://standardebooks.org/ebooks/w-somerset-
> > > >> You can make a copy from https://docs.google.com/
> spreadsheets/ <https://docs.google.com/spreadsheets/>
> > <https://docs.google.com/spreadsheets/ <https://
> docs.google.com/spreadsheets/>>
> > > d/1T4mK- <https://docs.google.com/spreadsheets/d/1T4mK-
> <https://docs.google.com/spreadsheets/d/1T4mK-> <https://
> > docs.google.com/spreadsheets/d/1T4mK- <http://
> docs.google.com/spreadsheets/d/1T4mK->>>
> > > >> ehA9OvMAThIc6nw1xrr6gMiN4aK0oTjbJsiWW4/edit?gid=0#gid=0
> and then
> > > >> finish up your edits.
> > > >>
> > > >> Let me know when you're done. Thanks!
> > > >>
> > > >> On 9/25/25 6:45 PM, Hendrik Kaiber wrote:
> > > >>> Another question, when should I add something to "Also
> > > published in"?
> > > >>> I ask because some authors (like Lovecraft) had their
> stories
> > > >>> compiled in several publications, and adding them
> doesn't seem
> > > very
> > > >>> useful.
> > > >>>
> > > >>> I started migrating my spreadsheet of Fyodor Dostoesvsky
> > <https://
> > > >>> docs.google.com/spreadsheets/ <http://docs.google.com/
> spreadsheets/> <http://docs.google.com/ <http://docs.google.com/>
> > spreadsheets/> <http://docs.google.com/ <http://
> docs.google.com/> <http://docs.google.com/ <http://
> docs.google.com/>>
> > > spreadsheets/>
> > <https://standardebooks.test/contribute/ <https://
> standardebooks.test/contribute/>>
> > > spreadsheets <https://standardebooks.test/contribute/
> > standardebooks.test/contribute/spreadsheets>> <https://
> > > >>>     standardebooks.test/contribute/spreadsheets>>
> > > >>>      >>> However, each producer has their own style of
> > > spreadsheet, and
> > > >>>     this
> > > >>>      >>> makes it more difficult to *quickly* review to
> see
> > > what's being
> > > >>>      >>> proposed, what we already have collected, and
> what
> > > remains
> > > >>> to be
> > > >>>      >>> included.
> > > >>>      >>> With that in mind I've created a new spreadsheet
> > > template,
> > > >>>     which I'd
> > > >>>      >>> like for everyone to use when starting new
> > > spreadsheets in the
> > > >>>     future:
> > > >>>      >>> https://docs.google.com/spreadsheets/
> <https://docs.google.com/spreadsheets/> <https://
> > docs.google.com/spreadsheets/ <http://docs.google.com/
> spreadsheets/>> <https://
> > spreadsheets/>> <https://docs.google.com/ <https://
> docs.google.com/> <https://docs.google.com/ <https://
> docs.google.com/>>
> > <https://
> > > docs.google.com/ <http://docs.google.com/> <http://
> docs.google.com/ <http://docs.google.com/>>>
> > > >>>     spreadsheets/>
> > > >>>      >>> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU
> > <https://
> > > >>>      >>> docs.google.com/spreadsheets/ <http://
> docs.google.com/spreadsheets/> <http://
> docs.google.com/> <http://
> docs.google.com/> <http://docs.google.com/ <http://
> docs.google.com/>>
> > <http://docs.google.com/ <http://docs.google.com/> <http://
> docs.google.com/ <http://docs.google.com/>>>
> > > >>>     spreadsheets/>
> > > >>>      >>> d/1CE2AsQ7E5WS9NORubHuiVAmWHYDrmU3bXWUghmnU4kU>
> > > >>>      >>> It includes some basic columns that are common
> to all
> > > omnibus
> > > >>>     research,
> > > >>>      >>> and producers can add their own special
> columns at the
> > > end.
> > > >>>      >>> It also has some prebuilt formatting like
> greying out
> > > items
> > > >>>     that are
> > > >>>      >>> not
> > > >>>      >>> PD yet, and checkboxes to indicate that an
> item already
> > > >>> exists in
> > > >>>      >>> one of
> > > >>>      >>> our omnibuses.
> > > >>>      >>> More detailed instructions are here:
> standardebooks.org/contribute/spreadsheets>>>> <https://
> > > >>>      >>> standardebooks.org/contribute/spreadsheets
> <http://standardebooks.org/contribute/spreadsheets> <http://
> > > groups.google.com/d/ <http://groups.google.com/d/> <http://
> <https://groups.google.com/d/msgid/> <https://
> > > groups.google.com/d/msgid/ <http://groups.google.com/d/
> msgid/> <http://groups.google.com/d/msgid/ <http://
> > msgid/> <https://groups.google.com/d/ <https://
> > > msgid/>
> > > >>>     standardebooks/883c05d8-d99f-4cf9- <https://
> > > groups.google.com/d/ <http://groups.google.com/d/> <http://
> > groups.google.com/d/ <http://groups.google.com/d/> <https://
> groups.google.com/d/ <https://groups.google.com/d/>>>
> > > >>>     msgid/standardebooks/883c05d8-d99f-4cf9-> adce-
> > > >>>     b538c821563dn%40googlegroups.com
> <http://40googlegroups.com>
> > <http://40googlegroups.com <http://40googlegroups.com>>?
> > > utm_medium=email&utm_source=footer
> <http://40googlegroups.com <http://40googlegroups.com>
> > <http://40googlegroups.com <http://40googlegroups.com>>?
> > > utm_medium=email&utm_source=footer>
> > > >>>     <http://40googlegroups.com
> <http://40googlegroups.com> <http://40googlegroups.com
> <http://40googlegroups.com>>?
> > > utm_medium=email&utm_source=footer
> <http://40googlegroups.com <http://40googlegroups.com>
> > <http://40googlegroups.com <http://40googlegroups.com>>?
> > > utm_medium=email&utm_source=footer>>>.
> > > >>>      >>
> > > >>>      >> --
> > > >>>      >> You received this message because you are
> subscribed to
> > > the
> > > >>>     Google Groups "Standard Ebooks" group.
> > > >>>      >> To unsubscribe from this group and stop receiving
> > > emails from
> > > >>>     it, send an email to
> standardebook...@googlegroups.com.
> > > >>>      >> To view this discussion visit https://
> > > groups.google.com/d/msgid/ <http://groups.google.com/d/
> msgid/> <http://groups.google.com/d/msgid/ <http://
> groups.google.com/d/msgid/>>
> groups.google.com/d/msgid/standardebooks/>> <http://
> > > <http://40standardebooks.org <http://40standardebooks.org>
> <http://40standardebooks.org <http://40standardebooks.org>>>>.
> > > >>>      >
> > > >>>
> > > >>> --
> > > >>> You received this message because you are subscribed to
> the
> > Google
> > > >>> Groups "Standard Ebooks" group.
> > > >>> To unsubscribe from this group and stop receiving
> emails from
> > it,
> > > >>> send an email to standardebook...@googlegroups.com
> > > >>> <mailto:standardebook...@googlegroups.com>.
> > > >>> To view this discussion visit https://
> groups.google.com/d/ <https://groups.google.com/d/>
> > > >>> standardebooks/270b0363-8eee-4278-
> > > >>> adc1-282396c75bb0n%40googlegroups.com
> <http://40googlegroups.com>
> > <http://40googlegroups.com <http://40googlegroups.com>>
> > > <http://40googlegroups.com <http://40googlegroups.com>
> <http://40googlegroups.com <http://40googlegroups.com>>> <https://
> groups.google.com/d/ <https://groups.google.com/d/>> <https://
> > > groups.google.com/d/ <http://groups.google.com/d/> <http://
> groups.google.com/d/ <http://groups.google.com/d/>>>
> > > >>> msgid/standardebooks/270b0363-8eee-4278-
> > > >>> adc1-282396c75bb0n%40googlegroups.com
> <http://40googlegroups.com>
> > <http://40googlegroups.com <http://40googlegroups.com>>
> <http://40googlegroups.com <http://40googlegroups.com>
> > <http://40googlegroups.com <http://40googlegroups.com>>>?
> > > >>> utm_medium=email&utm_source=footer>.
> > > >>
> > > >
> > >
> > > --
> > > You received this message because you are subscribed to the
> Google
> > > Groups "Standard Ebooks" group.
> > > To unsubscribe from this group and stop receiving emails
> from it,
> > send
> > > an email to standardebook...@googlegroups.com
> > > <mailto:standardebook...@googlegroups.com>.
> > > To view this discussion visit https://groups.google.com/d/
> > > standardebooks/44e9c6f5-8bae-4b1b-
> > ad45-98f86b82dd9bn%40googlegroups.com
> > standardebooks/44e9c6f5-8bae-4b1b- <https://
> groups.google.com/d/ <https://groups.google.com/d/>
> > msgid/standardebooks/44e9c6f5-8bae-4b1b->
> > > ad45-98f86b82dd9bn%40googlegroups.com
> <http://40googlegroups.com>?
> > utm_medium=email&utm_source=footer <http://40googlegroups.com
> <http://40googlegroups.com>?
> > utm_medium=email&utm_source=footer>>.
> >
> > --
> > You received this message because you are subscribed to the
> Google
> > Groups "Standard Ebooks" group.
> > To unsubscribe from this group and stop receiving emails from
> it, send
> > an email to standardebook...@googlegroups.com
> > <mailto:standardebook...@googlegroups.com>.
> > To view this discussion visit https://groups.google.com/d/
> msgid/ <https://groups.google.com/d/msgid/>
> > standardebooks/dbeb2b43-6027-4d24-84c2-
> c5c64ed5b61fn%40googlegroups.com <http://40googlegroups.com>
> > <https://groups.google.com/d/msgid/standardebooks/ <https://
> groups.google.com/d/msgid/standardebooks/>
> > dbeb2b43-6027-4d24-84c2-c5c64ed5b61fn%40googlegroups.com
> <http://40googlegroups.com>?
> > utm_medium=email&utm_source=footer>.
>
> --
> You received this message because you are subscribed to the Google
> Groups "Standard Ebooks" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to standardebook...@googlegroups.com
> <mailto:standardebook...@googlegroups.com>.
> To view this discussion visit https://groups.google.com/d/msgid/
> standardebooks/cca331cf-79f5-4ada-810d-d7b2d42ee1f1n%40googlegroups.com
> <https://groups.google.com/d/msgid/standardebooks/
> cca331cf-79f5-4ada-810d-d7b2d42ee1f1n%40googlegroups.com?
> utm_medium=email&utm_source=footer>.

David

unread,
Oct 1, 2025, 8:27:55 AM (5 days ago) Oct 1
to Standard Ebooks
I'm a bit spreadsheet-phobic, so I'm taking the Trollope Shorts data in stages. I've got all the data needed in my "INI" file format, and have converted it to CSV format, which is now in a Google Sheet here:


Is there a simple way of dropping this into the SE Research Template? I've attempted to copy/paste using the CRTL-SHIFT-V method as instructed, but I'm not having much success.

Alex Cabal

unread,
Oct 1, 2025, 10:23:40 AM (4 days ago) Oct 1
to standar...@googlegroups.com
Open the template and use "make a copy" to copy it into your own
account. Then in the old sheet, select an entire column, copy, and then
paste into the new sheet without formatting using ctrl + shift + v. That
should be all there is to it, that's how I've converted the other legacy
spreadsheets. Formatting in the template is automatic, you shouldn't
copy any formatting over.

For the checkmarks, use TRUE or FALSE instead of Y/N. Then pasting in
should work for that too.

The SE Category column and the Is PD column are calculated automatically
so don't paste those in.

On 10/1/25 7:27 AM, David wrote:
> I'm a bit spreadsheet-phobic, so I'm taking the Trollope Shorts data in
> stages. I've got all the data needed in my "INI" file format, and have
> converted it to CSV format <https://www.sudalyph.org/seci/at-sf/spsh-
> csv.php>, which is now in a Google Sheet here:
>
> https://docs.google.com/spreadsheets/
> d/146R3ZTYzaPdC35HIWPufudvQfs2rYSfh3RDaYqUBqg0/edit?usp=sharing
>
> Is there a simple way of dropping this into the SE Research Template?
> I've attempted to copy/paste using the CRTL-SHIFT-V method as
> instructed, but I'm not having much success.
>
> --
> You received this message because you are subscribed to the Google
> Groups "Standard Ebooks" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to standardebook...@googlegroups.com
> <mailto:standardebook...@googlegroups.com>.
> To view this discussion visit https://groups.google.com/d/msgid/
> standardebooks/52ab5d98-2780-4af9-9f16-46fafcefc69dn%40googlegroups.com
> <https://groups.google.com/d/msgid/
> standardebooks/52ab5d98-2780-4af9-9f16-46fafcefc69dn%40googlegroups.com?
> utm_medium=email&utm_source=footer>.

David Reimer

unread,
Oct 1, 2025, 11:22:44 AM (4 days ago) Oct 1
to standar...@googlegroups.com
Doh! And here was me copy/pasting rows....

This should look better:
https://docs.google.com/spreadsheets/d/1vMQ8NKjb48fcg2kbCBpUefgkgGxUIWajUGLLOB2724U/edit?usp=sharing

I don't know that the three "missing" stories will ever be
include-able, but at least there's a record of what we've got.

Hope that helps!

Alex Cabal

unread,
Oct 1, 2025, 11:35:11 AM (4 days ago) Oct 1
to standar...@googlegroups.com
Excellent work, thanks!

ʗharlie ßowman

unread,
Oct 3, 2025, 2:58:58 PM (2 days ago) Oct 3
to Standard Ebooks
I had been working on a spreadsheet of George MacDonald fiction. I've converted it to the new template:
https://docs.google.com/spreadsheets/d/1i9weAghb7cOMzqcvE-qDIgwusSlJZtQhtfyM_Otg3ks/

Alex Cabal

unread,
Oct 3, 2025, 3:02:17 PM (2 days ago) Oct 3
to standar...@googlegroups.com
Great work! I've made a copy at
https://docs.google.com/spreadsheets/d/1BcKbCc9s08jOdEaRbuRIelPDqwvM3TxTAFl2NcJgrI8

Please work on that copy from now on. Thanks!

On 10/3/25 1:58 PM, ʗharlie ßowman wrote:
> I had been working on a spreadsheet of George MacDonald fiction. I've
> converted it to the new template:
> https://docs.google.com/spreadsheets/d/1i9weAghb7cOMzqcvE-
> qDIgwusSlJZtQhtfyM_Otg3ks/
>
> On Wednesday, October 1, 2025 at 11:35:11 AM UTC-4 Alex Cabal wrote:
>
> Excellent work, thanks!
>
> On 10/1/25 10:22 AM, David Reimer wrote:
> > Doh! And here was me copy/pasting rows....
> >
> > This should look better:
> > https://docs.google.com/spreadsheets/
> d/1vMQ8NKjb48fcg2kbCBpUefgkgGxUIWajUGLLOB2724U/edit?usp=sharing
> <https://docs.google.com/spreadsheets/
> d/1vMQ8NKjb48fcg2kbCBpUefgkgGxUIWajUGLLOB2724U/edit?usp=sharing>
> sf/spsh- <https://www.sudalyph.org/seci/at-sf/spsh->
> >>> csv.php>, which is now in a Google Sheet here:
> >>>
> >>> https://docs.google.com/spreadsheets/ <https://docs.google.com/
> spreadsheets/>
> >>> d/146R3ZTYzaPdC35HIWPufudvQfs2rYSfh3RDaYqUBqg0/edit?usp=sharing
> >>>
> >>> Is there a simple way of dropping this into the SE Research
> Template?
> >>> I've attempted to copy/paste using the CRTL-SHIFT-V method as
> >>> instructed, but I'm not having much success.
> >
>
> --
> You received this message because you are subscribed to the Google
> Groups "Standard Ebooks" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to standardebook...@googlegroups.com
> <mailto:standardebook...@googlegroups.com>.
> To view this discussion visit https://groups.google.com/d/msgid/
> standardebooks/ed019166-7f28-4199-9201-d7b5722813efn%40googlegroups.com
> <https://groups.google.com/d/msgid/standardebooks/
> ed019166-7f28-4199-9201-d7b5722813efn%40googlegroups.com?
> utm_medium=email&utm_source=footer>.

Reply all
Reply to author
Forward
0 new messages