How Do You Export Lists to Excel/Sheets?

General discussion about the Playing Card Database.
Announcements and updates wil lalso be posted here.

Moderator: Playing Card DB Mod

User avatar
james001a
Member
Member
Posts: 829
Joined: Tue Dec 15, 2015 5:46 pm
Collector: Yes
Player: Yes
White Whale: Aurum Laser Cut
Has thanked: 221 times
Been thanked: 256 times
Contact:

How Do You Export Lists to Excel/Sheets?

Unread post by james001a »

Hi friends. I like to have a spreadsheet backup of my collection, trade lists and want lists. I do not want the photos, just a text list, along with the quantities. I am reaching out for some assistance, if anyone can offer any. Thanks in advance.

James001a
I haven't slept for ten days, because that would be too long.

-Mitch Hedberg
Strag
Member
Member
Posts: 2283
Joined: Mon Oct 01, 2012 3:11 pm
Collector: Yes
Player: Yes
White Whale: None
Decks Owned: 0
Has thanked: 213 times
Been thanked: 871 times

Re: How Do You Export Lists to Excel/Sheets?

Unread post by Strag »

As far as I'm aware there isn't one, which is the main reason I have never bothered to use it to track my collection. I have always used a Google Sheets version which I backup locally so that I always know what I have and how much I paid.
User avatar
hsbc
Moderator
Moderator
Posts: 5909
Joined: Wed Sep 05, 2018 2:10 pm
Cardist: Yes
Collector: Yes
Player: Yes
White Whale: Grid 1 LE
Decks Owned: 1500
Location: ATL
Has thanked: 9018 times
Been thanked: 6374 times

Re: How Do You Export Lists to Excel/Sheets?

Unread post by hsbc »

Hasn't P52 had an update planned for like two years now? :uggrin: It's frustrating because it could be SO GOOD... imagine having pages for each creator, with a list of their decks... click on one and you'll see the variants. Pages for printers, artists, searching your collection... being able to drill down by stock, tuck case manufacturer, gilding color, signature

And yeah also exporting :ugthink:
P52DCIGUCr/m/52+J
User avatar
kevork
Member
Member
Posts: 2191
Joined: Mon Mar 28, 2022 12:54 am
Collector: Yes
White Whale: NPCCD 17 Amethyst + Prototypes
Decks Owned: 1000
Location: California
Has thanked: 2283 times
Been thanked: 2797 times

Re: How Do You Export Lists to Excel/Sheets?

Unread post by kevork »

It seems you can now export your collection to a .csv. It includes the deck name and quantity.

Doesn't apply to tradelist and wishlist.
P52 Download.png
Image@playingcardophile
Invisible ink. Who woulda thunk it?
[BUY] Complete Lotrek Collection
[BUY] NPCCD Decks
User avatar
hsbc
Moderator
Moderator
Posts: 5909
Joined: Wed Sep 05, 2018 2:10 pm
Cardist: Yes
Collector: Yes
Player: Yes
White Whale: Grid 1 LE
Decks Owned: 1500
Location: ATL
Has thanked: 9018 times
Been thanked: 6374 times

Re: How Do You Export Lists to Excel/Sheets?

Unread post by hsbc »

Nice! Just the names but better than nothing for sure:

Code: Select all

"Sakura (Spring)",1
"THE PLANETS - MARS",1
Voodoo,1
"Whale Castle",1
"The Planets - Jupiter",1
"Jetsetter - Premier Edition in Jet Black (Private Reserve)",1
Dot,1
Hoody,1
"Casual V2",1
"Prestige Slip Case Blue [Bicycle]",1
P52DCIGUCr/m/52+J
User avatar
Smocito
Member
Member
Posts: 256
Joined: Sun Jan 22, 2017 1:22 pm
Collector: Yes
Location: Portugal
Has thanked: 178 times
Been thanked: 138 times

Re: How Do You Export Lists to Excel/Sheets?

Unread post by Smocito »

Hello,

If you just want a record of your collection with the image and name, it's possible to get it in PDF format.
1 - Choose the deck and name visualization :
Portfolio capture list.jpg
2 - Make sure you go to the end of your collection by pressing multiple times (it dependes on the size of your collection) the "page down" key on your collection page
3 - Print and choose PDF instead of your printer.

By choosing one of the other visualizations options, going to the end of your collection, and saving the site, you'll get a folder with the images of the decks in your collection. You can then use them as screen saver if you wish (choose a slideshow screen saver and indicate the folder with the images as source).

If you want the images, name and description of the decks in your collection (unfortunately it seems limited to 100 pages) it's also possible.
1 - Go to your collection page
2 - Choose the option right of the pinterest button :
Portfolio capture Printfriendly1.jpg
3 - Choose the Print friendly option
Portfolio capture Printfriendly2.jpg
Choose to print to PDF and you'll get a file like this:
PDF Print Friendly exemple.pdf
(1.26 MiB) Downloaded 12 times
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests