HOWTO: Create a new checklist

Create a checklist spreadsheet file:
Excel is a spreadsheet program. There are a few others. .... is free. Google Spreadsheets is free and online. This HOWTO will use Excel 2007, just because it's what I have.

  • If it's there, find your set in ACO's Scan Gallery
  • Open your favorite spreadsheet program.
  • Type in the header row. It usually starts with # for number. It should end with OWN.
  • Continue with your checklist. The last cell, under OWN, should be "YES NO ___"
  • Double check your checklist, and save it. If you don't want to POST your own checklist, you can STOP HERE. Send the file to mystavash@animecards.org.
  • Now, click "Save as..." other formats.
  • Save it as a CSV file (see the drop down for file formats for the right one.)
  • Close your file. It may give you some error messages about "Are you SURE you want to keep it as a csv file?" Yes, you are sure.
  • Find the file on your computer. Right click it, and Open with Notepad.
  • A CSV file uses commas to divide information. We don't want commas, we want pipe bars |. Click Edit >> Replace: Find what "," Replace " | " (don't forget the spaces!).
  • Click save. Leave this file open.

Create an ACO checklist

  • Click on Add a new checklist.

  • Select the Anime Series from the drop down list. If you don't see what you need, please select OTHER.
  • Type in the first word of the Set Name. Wait a few seconds. If what you want appears in a drop down, select it. Otherwise, finish typing in the set name.
  • Type in the title of the checklist. Use this format: Series name - Set name (List).
  • If there are any really important details, add them to the details box. The default is N/A (no details).
  • Copy everything from the CSV file into the Checklist box.
  • In the Update box, type <i>Created</i>: Month Day, YEAR