Updating specific LT Fields using export, Excel, import process

TalkHacking LibraryThing

Join LibraryThing to post.

Updating specific LT Fields using export, Excel, import process

1JonathonL88
Feb 10, 9:52 am

Tue 10Feb2026 14:47
I have a number of records with wrong/missing data in a field that I cannot correct using Power edit.

As all the entries need the same value, it could be done very easily via an Excel spreadsheet.

If I just exported
Work id
Edition Id
FieldX

changed FieldX in Excel
reimported

Would LT be kind and just update or would it ONLY add these as duplicates.

If the above does not work, any suggestions for alternative solutions.

2DebiCates
Feb 10, 9:55 am

This is of great interest to me too!

3bnielsen
Feb 10, 3:00 pm

>1 JonathonL88: Book_Id and FieldX would be enough, but alas the answer is no.

4GraceCollection
Feb 13, 3:20 am

This is why I wish there were more options for Power Edit... or that the import/export loop would be closed!

5JonathonL88
Feb 13, 8:30 am

So how do you back up your library entries, just in case you make a big mistake say in power edit?
One would expect that you can backup ALL fields and equally reimport ALL fields without losing any data or having LT second guess and "improve" the data being imported. e.g. ISBN lookup for "better fields.

6kristilabrie
Feb 13, 9:06 am

>5 JonathonL88: We do track Edit History, now, on individual book pages and in "Your books" across your catalog. (There's a sub-page in the dropdown next to the List | Covers toggle.) You can Restore certain edits, and filter by Power Edits, etc.

7JonathonL88
Feb 13, 10:16 am

Where can I find documentation on this please.

8kristilabrie
Feb 17, 9:40 am

>7 JonathonL88: The Talk post announcing the feature lives in the New Features Group: https://www.librarything.com/topic/373960, although I'm not sure Help documentation has been written for it, yet.