posted on March 25, 2001 06:42:13 AM
Does anybody out there know if the eBay account info can be exported to a spreadsheet?. It would be nice to group the fees together for each item instead of having the listing fee and FVF separated by other entries, I could sort them by number and have an idea as to exact eBay cost of sale for each item number. I also wish they would list the item title next to the fee, but I doubt there is much hope of that. Anybody?
posted on March 25, 2001 07:30:06 AM
If you are using Excel 2000, you can grab the URL of your eBay account info and open it into a blank spreadsheet.
For example, in your browser go to your 'my last invoice' page and copy the URL. Then go to Excel,
File->Open, then paste this URL into the box where you select the filename to open.
The results look a little messy, but it does parse all the columns correctly. From hear you can copy the range of data you want, and insert it into your regular spreadsheet using Paste->Special.
Get your page with the accouny info showing. In your browser, do FILE\SAVE and change the name to something.HTML and save it to your hard drive.
then OPEN that HTML file with Microsoft Word (word 6 or higher) and delete out all the columns and crap you don't want until it's a nice clean table. SAVE AS a DOC file. then open the DOC file, select the table and copy it. Paste it into EXCEL.
posted on March 25, 2001 09:14:39 PM
The following works for most browsers. When you are browsing the ebay data (or any other page, do a FILE, SAVE-AS and give the file an .XLS extension (myfile.xls). Then go to excel and open that file. It should open in a valid spreadsheet format.
It's sort of an undocumented feature that works in both netscape 4.x and explorer 5.x/
This works pretty well for the most part. There are some times when things get a little funny with nested cells. Overall though, this does a pretty good job.
