Downloadable Monthly Reports

Each month, you can download a report that includes all of the sales details for the previous month. This report is in .tab format, and can be downloaded into programs such as Excel and Access, where you can sort, print, and format the data in a way best suited for your needs. This report contains the same information that is available in the Sales Details pages online.

Below are instructions for downloading the report to your computer and then importing it into Excel or Access. If you would like to import it into any other program, please check that program's Help files.

Important Note: Each month's Downloadable Report is generated on the first Friday of the month following, i.e. January's Downloadable Monthly Report will not be available until the first Friday in February.

Accessing the Downloadable report:

  1. Sign on to your AbeBooks account. 

  2. Click [Your Personal Information] from the Members Menu. 

  3. Select [Download a monthly activity report]. 

  4. Click the [Download] button next to the calendar month you wish to download. 

  5. Select [Save] to save the report. (Please be sure to choose a save location that is easy to access and/or remember. )

The saved report can now be imported into your spreadsheet or database program.

Importing a file into Microsoft Excel 2000:

  1. Open Excel. 

  2. Click [File] and then [Open]. 

  3. Locate the file you want to import. NOTE: You will need to change the File type to [All Files] to be able to see the file. 

  4. Highlight the file and click [Open]. 

  5. The Text Import Wizard will appear and ask you what type of file you’re importing. Ensure the option button is set to [Delimited]. 

  6. Click the [Next] button. 

  7. The screen will ask you what type of delimiter you have chosen for your separator. The default should be “Tab."  Ensure the default is “Tab” and click [Next]. 

  8. Click [Next] again for the final screen of the wizard (no changes should be made here) and click [Finish].

Your file will appear in Excel.
 
(For further information on importing files into Microsoft Excel, please consult the Excel Help files.)

Importing a file into Microsoft Access 2000:

  1. Open Microsoft Access. 

  2. Choose [File] and then [Open] and browse for your export file. 

  3. In the Link Text Wizard, acknowledge the TAB delimited format. 

  4. Progress through the [Next] windows adding Field names to each column (this may take a couple of minutes to go through all the fields). 

  5. To link to your export file, select [Finish].

Your linked file will be listed as a "Database Table."  Simply select the link and click [Open] to bring your database onto the screen in table format.

(For further information on importing files into Microsoft Access, please consult the Access Help files.)

Return to Seller Help Topics