Home  >  Community  >  The eBay Outlook  >  how do you export info to excel?


<< previous topic post new topic post reply next topic >>
 crowderscomicshop
 
posted on October 20, 2003 07:22:38 AM new
How can I export sales and auction info from Vendio to excel??

 
 local
 
posted on October 20, 2003 08:12:44 AM new
Go to My Account. Click Download report. Save as Comma Separated Value File. Save the file in a location where you will be able to find it. Then you can open this in Excel and save as an xls file.

After looking at other management systems, no one system offered everything I need, so I use my own spreadsheets.
Good Luck.

 
 crowderscomicshop
 
posted on October 20, 2003 08:25:33 AM new
I see no downlaod report feature when I open my accounts, is it under one of the other options?

 
 wgm
 
posted on October 20, 2003 09:58:07 AM new
crowder - I didn't know it was possible to download from Vendio to Excel...

I use Excel also for my spreadsheets, and up to now I have been copy-and-pasting (which is somewhat time-consuming with formatting).

local - could you please be more specific as to where the download feature is? I would love to be able to that also, as I am sure others here would as well...

thank you!


"I have neither the time nor the inclination to explain myself to a man who rises and sleeps under the blanket of the very freedom I provide and then questions the manner in which I provide it." - A Few Good Men
 
 local
 
posted on October 20, 2003 06:51:32 PM new
Look at the top Vendio Tabs. Just to the left of the Community TAB, is My Account. 1. Click My Account
2. Click Online Statements
3. Click Download this statement (Or select the month of the statement you want).
4. A File Download Window displays. Would you like to open or save this file. Select Save.
5. Save it in a folder so you will be able to find it later. Ex. Vendio or Ebay.
6. By default, the file name is "AW_Statement_Current" and file type is Microsoft Excel Comma Separated Values File. Click Save.
7. Launch Excel.
8. Select File Open in Excel. Find the folder where the file is saved.
9. Change the File Type from (Microsoft Excel - Defualt setting) to "All Files" and find your file "AW_Statement_Current".
10. Open your file. You will need to do some formatting of the columns.
11. Unfortunately, this does NOT give you all of the information that you need. You will see all of your items listed with the dates & ebay number. You will see your listing fee & final value fee. You will not see your selling price.

Hope this helps.

 
 
<< previous topic post new topic post reply next topic >>

Jump to

All content © 1998-2024  Vendio all rights reserved. Vendio Services, Inc.™, Simply Powerful eCommerce, Smart Services for Smart Sellers, Buy Anywhere. Sell Anywhere. Start Here.™ and The Complete Auction Management Solution™ are trademarks of Vendio. Auction slogans and artwork are copyrights © of their respective owners. Vendio accepts no liability for the views or information presented here.

The Vendio free online store builder is easy to use and includes a free shopping cart to help you can get started in minutes!