14,830 bells
 
 
» AC:NL General Board
Topic: Excel Catalog tracker - Updated 9/25 with streetpass, found, and seasonal items » ARCHIVED

Page of 2
ArtieMcD
 
Name
Artie
ACNL Town
Last Active
9/6/2015 9:55pm
In order to track my missing catalog items in New Leaf I made an Excel spreadsheet to track my purchases since I didn't find any readily available and useful (ie one I could save, print, search, filter, sort, etc) checklist for the furniture/clothing items in game.

I'd figured I'd share it since others may find it useful.  Since it's in Excel you can download the spreadsheet to your own device or you can keep it up on the web and edit/save it from any web browser, phone, or tablet.  

http://sdrv.ms/15f6pGS

Since this info is all in Excel, you can easily sort/filter based on any criteria you need including filtering furniture out by series, HHA theme, whether you have it or not, etc.  

The spreadsheet contains trackers for:
Furniture
Clothes
Stationary
Songs
Handhelds
Gyroids
Art
Bugs
Fish
Dive Catches
and
Fossils

I included the spreadsheet posted on geckonori Tublr with the Bug/Fish/Diving catches with minor correction to incorrect names/data.   The others are the best I could accumulate from other web sources and or info I've seen in game so far.     I have found a lot of the web information is either wrong, incomplete or not matching up with in game information so I tried the best I could to make sure the data matched exactly as it appears in the NA version of the game.     Please let me know if you find any discrepancies and I can update them asap.  

BTW, I still plan to post a badge and tour checklist (plus any other features anyone may request).
Bells: 282,630 Catalog: 0 Feedback: 0 WiFi:  (69) Patterns: 0  
giamiabia
 
Name
Georgia
ACNL Town
Last Active
4/8/2020 4:26am
I love you.

I use a basic spreadsheet to keep track of what I have in my catalog. Excel is life.
Signature--------------

georgiacrossing.tumblr.com
Bells: 92,900 Catalog: 805 Feedback: 0 WiFi:  (133) Patterns: 0  
wouwter
 
Name
Wouter
ACNL Town
Last Active
6/28/2020 5:28pm
I'm not sure if I'm really going to use it, but thank you for making and sharing it.
Signature--------------
You beautiful tropical fish.
+6 hours ACC time (CET)
Bells: 640,800 Catalog: 0 Feedback: 0 WiFi:  (211) Patterns: 1  
ArtieMcD
 
Name
Artie
ACNL Town
Last Active
9/6/2015 9:55pm
Ok, I just posted a major update.

Along with some minor typos and tweaks I made to the original set I included in the first version, the spreadsheet how has checklists for the following items:

Public Works
Tour/Medal Tracker
Jokes/Emotions
Tools

I'm reworking the old handhelds tab so the next version I'll try to include all the random seasonal items that are not considered furniture/clothes.. As well as the streetpass gifts.

I see that an iOS app exists... I'm quite tempted to make a Windows and Windows Phone version of this tracker for those of us who don't carry iStuff.   (Of course Excel is the ultimate "app" anyways so maybe not)
Bells: 282,630 Catalog: 0 Feedback: 0 WiFi:  (69) Patterns: 0  
marlasinger
 
Name
Orion
ACNH Town
Last Active
12/26/2020 1:57pm
This is awesome, thank you so much!
Signature--------------
marlasinger
Grownup Gamers Only Please
Bells: 298,900 Catalog: 0 Feedback: 0 WiFi:  (53) Patterns: 0  
kkrulez64
 
Name
Kory
ACNL Town
Last Active
10/7/2013 8:18pm
Sorry if this is stupid to ask but how would I edit it in my browser? I can't seem to figure this out. I'd love to be able to use it in Excel but I need a product key to use it :/

Edit: Nevermind, I figured it out. Thank you for this checklist though!
Bells: 28,900 Catalog: 0 Feedback: 0 WiFi:  (1) Patterns: 0  
DodieOH
 
Name
Dodie
ACNL Town
Last Active
10/8/2013 3:23pm
This is very nice.  Thank you.
Signature--------------
- Dodie, Mom to 8 (ages 30 to 6) and Grandma to 2
Respectful Gamer
Bells: 87,600 Catalog: 0 Feedback: 0 WiFi:  (0) Patterns: 0  
maloryjane
 
Name
Mal
ACNL Town
Last Active
6/3/2014 1:11pm
This is pretty sweet. And I know for furniture and clothes this would work best but just thought I'd share for those who didn't know there's a pretty sweet app that allows you to track badges, fossils, villagers, fish and all that! (: It's pretty sweet
Bells: 7,100 Catalog: 89 Feedback: 0 WiFi:  (3) Patterns: 0  
ArtieMcD
 
Name
Artie
ACNL Town
Last Active
9/6/2015 9:55pm
Yeah, there is an App someone made.. But for those of us who don't buy Apple products... Or don't use Android, the app is pretty useless.  

Bells: 282,630 Catalog: 0 Feedback: 0 WiFi:  (69) Patterns: 0  
estitch
 
Name
Chellish
ACNL Town
Last Active
3/21/2020 11:50pm
What is the app name? :0
Signature--------------
My time is ACC +12
I can order any reorderable items for you. PT me :)
Bells: 611,800 Catalog: 249 Feedback: 0 WiFi:  (333) Patterns: 0  
Monty_Monkey
 
Name
Chris
ACNL Town
Last Active
3/12/2014 1:24am
Estitch, search for "ACNL guide" in the apple app store.
Bells: 29,700 Catalog: 0 Feedback: 0 WiFi:  (2) Patterns: 0  
estitch
 
Name
Chellish
ACNL Town
Last Active
3/21/2020 11:50pm
Will do
Thanks a lot for the information.
I think this excel also pretty neat! Awesome ^^
Signature--------------
My time is ACC +12
I can order any reorderable items for you. PT me :)
Bells: 611,800 Catalog: 249 Feedback: 0 WiFi:  (333) Patterns: 0  
ArtieMcD
 
Name
Artie
ACNL Town
Last Active
9/6/2015 9:55pm
just posted an update.   this one includes a medal tracker.
Bells: 282,630 Catalog: 0 Feedback: 0 WiFi:  (69) Patterns: 0  
OishiSushi
 
Name
Luffy
ACNL Town
Last Active
10/11/2016 1:20am
i saw a typo, but who cares?

thank you, this is pretty useful, sometimes i dont have my iphone with me, this will do.
Signature--------------
-3 hrs. behind ACC
Bells: 100,825 Catalog: 162 Feedback: 0 WiFi:  (47) Patterns: 0  
ArtieMcD
 
Name
Artie
ACNL Town
Last Active
9/6/2015 9:55pm
ok, posted a new update tonight.   No new tabs, but I did update the Furtniture/Clothing catalog to better show which foreign events some items come from.. Also, minor tweaks to the Tours and badges list.

Still working on a list of Seasonal collectibles/Photos for a future update. (I haven't gotten many in my game yet to see the best way to track these).

The download is still at:
http://sdrv.ms/15f6pGS
Bells: 282,630 Catalog: 0 Feedback: 0 WiFi:  (69) Patterns: 0  
Cinders
 
Name
Cindy
ACCF Town
Last Active
5/9/2020 9:16pm
Thank you for all your hard work. I know it couldn't have been easy. It took time to get it together. You deserve a medal. hehe!
Signature--------------
Northeast USA
Proud Member of Adult Gamers United
Bells: 42,100 Catalog: 0 Feedback: 0 WiFi:  (38) Patterns: 0  
estitch
 
Name
Chellish
ACNL Town
Last Active
3/21/2020 11:50pm
I really appreciate the update, but I can't possibly use the new ones and move all of the data over again xD
Signature--------------
My time is ACC +12
I can order any reorderable items for you. PT me :)
Bells: 611,800 Catalog: 249 Feedback: 0 WiFi:  (333) Patterns: 0  
penelopePINK
 
Name
Aeryn
ACNL Town
Last Active
3/31/2020 8:38pm
Thanks, so much.
I will finally get organized!
Signature--------------
-3 hours difference from ACC time
Bells: 127,900 Catalog: 0 Feedback: 0 WiFi:  (0) Patterns: 0  
TaylorGS
 
Name
Tay
ACNL Town
Last Active
5/2/2020 3:16pm
Oh my gosh! THIS IS AWESOME. I didn't even know you could have Excel sort stuff like that. Then again I only know how to do super simple stuff in Excel, haha. Gonna share this with my friends. :0
Bells: 348,020 Catalog: 2142 Feedback: 85 WiFi:  (126) Patterns: 23  
ArtieMcD
 
Name
Artie
ACNL Town
Last Active
9/6/2015 9:55pm
I just posted a pretty major update to the spreadsheet... The following new tabs are present:

Streetpass items
Seasonal (non-cataloged) items
other items found in the game
Plants
Dinosaur Models

This update now should contain every item that your character can possess in the game.

Existing users, you can simply copy/paste the new tabs to your existing book.   You may also want to refresh the stationary tabs as I have removed items that were listed on some online guides that never show up in the game catalog or could be owned by your character.   There have also been some tweaks to the data for the clothing and furniture catalogs.

Let me know if you find any other discrepancies.
Bells: 282,630 Catalog: 0 Feedback: 0 WiFi:  (69) Patterns: 0  
estitch
 
Name
Chellish
ACNL Town
Last Active
3/21/2020 11:50pm
The stationary you removed can be owned. Museum paper, post-office paper, etc are rare items and unorderables. You can get from your villagers randomly.
And for clothing, there are Gracie items that listed as Able Sister's.
Signature--------------
My time is ACC +12
I can order any reorderable items for you. PT me :)
Bells: 611,800 Catalog: 249 Feedback: 0 WiFi:  (333) Patterns: 0  
ArtieMcD
 
Name
Artie
ACNL Town
Last Active
9/6/2015 9:55pm
Ok, in regards to the stationary.. Do those stationaries actually appear in the catalog once you've possessed it?   (IE not just unorderable.. but does it even show in the list?)    IE, if that's the case, I'll move them to the Other items tab so that the stationary tab continues to tracks the players actual catalog completion levels..  IE, Melody paper was done that way since Melody paper does not show up or affect the catalog completion percentage.

As for the clothing.. Let me know which ones and I will update.. It's likely those are some I have not encountered in the game yet (since I still haven't unlocked Gracie).

Bells: 282,630 Catalog: 0 Feedback: 0 WiFi:  (69) Patterns: 0  
NicksFixed
 
Name
Kai
ACNH Town
Dream Code
8180-7538-3145
Last Active
10/22 9:06pm
Those stationerys don't appear in the catalogue but, like Chellish said, you can own them ...
Signature--------------
Pointy Floaty Thing
In Ireland: The Land of the Rising Damp: AC Time: ACC +5
Bells: 1,551,900 Catalog: 0 Feedback: 0 WiFi:  (234) Patterns: 0  
NicksFixed
 
Name
Kai
ACNH Town
Dream Code
8180-7538-3145
Last Active
10/22 9:06pm
Oh and the Sandcastle is a Club Tortimer item, not DLC ...
Signature--------------
Pointy Floaty Thing
In Ireland: The Land of the Rising Damp: AC Time: ACC +5
Bells: 1,551,900 Catalog: 0 Feedback: 0 WiFi:  (234) Patterns: 0  
Aemi
 
Name
Aemi
ACNL Town
Last Active
5/19/2014 4:04am
its only showing me floor, furniture, and wall. Did i grab a wrong copy somewhere?

nevermind im a moron. i see the tabs. however, its in read only mode and i cant seem to change anything o_0
Signature--------------
Town Rules: Only run on the worn grass. Do not pick/trample flowers!
I'm easier to get ahold of on Skype. Just look me up!
Bells: 113,300 Catalog: 516 Feedback: 0 WiFi:  (16) Patterns: 1  
AC:NL General Board » Topic: Excel Catalog tracker - Updated 9/25 with streetpass, found, and seasonal items » ARCHIVED

Page of 2

Legend:   Site Owner    Administrator    Moderator    Researcher    Developer    Scout    New Member   Honorary Citizen   Birthday