Jump to content

excel export

Guest cs120

Recommended Posts


how do i export to excel all the coins in the collection?  for example a excel file that shows:

id, denomination, type, year, MM, variety, grade, qty, amount paid, current value


Link to comment
Share on other sites

Here's how I've done it, highlight "My Collection" on the left, then right click and choose "Output Report Using...". Then choose "Coins by Collection" report, then in the dialog box that come up about the print options choose and then in the drop-down list that you can direct to -- choose Microsoft Excel Format. Then you'll get an Excel file that you can tweak and format. In the reports menu you can also choose "Create a Collection Report" and then just direct the print options to Microsoft Excel Format. I do this frequently to have a workbook for my collection.


Link to comment
Share on other sites

  • 1 month later...

Hi, yes the best way to export any data to Excel is to use the reporting,  specify Microsoft Excel as the output destination from the dropdown.

if a report does not have the info you need exported, you can change an existing report to add the additional fields, before running the report.

Link to comment
Share on other sites

Join the conversation

You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...