Etsy :: The Storque :: How-To :: Tech Update + How-To: Download your Sales and Billing Data to a Spreadsheet

Tech Update + How-To: Download your Sales and Billing Data to a Spreadsheet


Story by kfarrell, TechUpdates Published on March 20, 2008 in How-To	Photo by trungnq

Sellers who do their own accounting will be excited to hear this: you can now download your sales information to your computer in CSV format ( Here here! for "comma separated values")!

A CSV is a type of file that can be opened by programs such as Microsoft Excel or Open Office Calc (a free spreadsheet program). If you go to Your Etsy > Sold (orders) you'll now see a link at the bottom to "Download this sales data as a CSV." By selecting the month and year near the top of the page, you can download sales info from your shop for each month you've been in business.

Did you know CSV files are also available for your monthly Etsy bill? To download a month's worth of billing information, click on the appropriate month in Your Etsy > Your Etsy Bill and click "Download this entire monthly statement as a CSV file."

If you've never used a CSV file before, we'll walk you through downloading it to your computer and opening the file. It's easy!

First, save the file to your hard drive.

Next, open the file with your spreadsheet program. You may need to select "All files" in the list of file types.

It should open up to a list of all your sales for the month. You can use formulas to calculate your total sales for the month, shipping costs, etc. For details on how to set up formulas, see the help documents for your spreadsheet program.

Voila!

Comment below if you have other ideas for fun ways to sort at the data in your new spreadsheets!

Tags	business, How-To, HOW-TO, information, sales, Seller Handbook, selling, site features, Statistics, Tech Updates

All articles in How-To

Related Items

This article was reported by:

kfarrell

shop . profile . contact

TechUpdates

shop . profile . contact

37 comments Login to add your own!

March 20, 2008 at 9:56 a.m.

OneHoney

A big YEA! for this.

Thanks!

March 20, 2008 at 9:59 a.m.

aloka

Thanks so much for this feature! It's very satisfying to see that something you (and many others) have requested on the forums do come true.

Thanks again :-)

March 20, 2008 at 10:03 a.m.

pulpsushi

HOORAY!!!!!!!!!!!!

March 20, 2008 at 10:11 a.m.

annacote

this is incredibly helpful - thank you!

March 20, 2008 at 10:15 a.m.

Stockton

Oh this is exciting - thank you!

March 20, 2008 at 10:20 a.m.

Itybitybags

wow! That is awesome thank you :)

March 20, 2008 at 10:48 a.m.

sushipot

Thank you!!!

March 20, 2008 at 10:53 a.m.

pookeh

ack, thank you so much. you made my life a little less horrible today. :) squee!

March 20, 2008 at 10:53 a.m.

ClaudiaLord

Can't wait to have a sale so that I can try it out!! Thanks!

March 20, 2008 at 11:55 a.m.

melissakate

Woohoo!
Let the glorious trumpets sound!
This makes me so super duper happy that I can't even explain it! No, those aren't tears...
I have to be alone for a minute with my speadsheet.

March 20, 2008 at 1:12 p.m.

KatieCarolinaDesigns

Yay!!! Thank you. I am off to play right now!

March 20, 2008 at 1:46 p.m.

MagpieCollections

great features..!!!

March 20, 2008 at 4:17 p.m.

sewbettie

Yeah! This is a huge timesaver for me.

March 20, 2008 at 4:19 p.m.

janicej

Very helpful. Thanks!

March 20, 2008 at 4:25 p.m.

ErinTyner

Thank you!!

March 20, 2008 at 4:32 p.m.

supastarr

Awesome! Thanks!

March 20, 2008 at 4:56 p.m.

BluewaterStudio

This is fabulous! I love it!

I have an itty bitty request, if possible, could you dump the Etsy Order Number with this data as well, this would allow me to automatically link the data with my PayPal CSV and Personal Tracking System. It could be dumped on each line, with each item... :):)

Thank you!! xoxo Sabine

March 20, 2008 at 5:08 p.m.

mmmfiber

Wow! That's really something!
Thankyouthankyouthankyou

March 20, 2008 at 5:39 p.m.

wildflowerdesigns

YAY!!
i plan on using this all the time now

March 20, 2008 at 6:33 p.m.

marciapalmer

Bravo! Thank you!

March 20, 2008 at 9:55 p.m.

XOHandworks

Is the csv download not on Etsy time?
In my Sold Items list I have 3 items sold on Jan. 1. In the csv file these 3 show as Jan. 2.
Looking through the 1st week of January, none of the daily totals match although the monthly total does.

Is the csv info in a different time zone?

March 20, 2008 at 10:17 p.m.

loosewirestudio

Excellente!

It's a start!
Next round, maybe include the data that is on the Details page? Then we'd have the Transaction number, which we could relate to Paypal info. Then things would get wild! :)

Thanks bunches and bunches!!! :)

March 20, 2008 at 10:59 p.m.

JJMFinance

Coming from an accountant. . . This is great data for Etsy sellers to speed up their record keeping processes.

I have now modified my Business Manager Spreadsheet to accept this .csv file. That means it is as simple as a copy and paste to include your sales data in my business tools.

March 21, 2008 at 1:48 a.m.