Etsy's Handmade Blog
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

66 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. brennx0r

thankyouthankyouthankyou!

I have been bugging y'all about this in the forums for awhile, and I am very happy that this is finally here :D

March 21, 2008 at 8:06 a.m. elisasherejewelry

This is the best thing ever (except for Etsy itself)! Now we have more time to make things. Yeah!

March 21, 2008 at 11:29 a.m. meloearth

I need to learn how to make a spreadsheet for my other ventures this year. Is there a tutorial on Etsy?

March 22, 2008 at 6 p.m. sylviavincent

This is fabulous :-)

April 26, 2008 at 5:31 p.m. blackbird72

this is SAVING me!

May 2, 2008 at 6:36 p.m. miriam

:D
I think in a mac with leopard and microsoft office 2008 it's quiet different :s

May 21, 2008 at 11:12 a.m. debrlee

I'm assuming this does not work with Works??? ;( Boohoo

June 30, 2008 at 6:47 a.m. glasstastictreasures

Wow, this is awesome. If I wasn't so busy chatting and goofing off in the forums, maybe I would have seen this, say....BEFORE tax time! lol

July 29, 2008 at 11:29 p.m. jellygnite

thank you for the great info!

Aug. 19, 2008 at 10:11 a.m. DenikDesigns

I have to keep this one in mind

Oct. 19, 2008 at 10:36 p.m. PenguinsPlunder

great help! I didn't know i could do this, thank you

Dec. 5, 2008 at 8:22 p.m. craftyfolk

just discovered this, thank YOU!

Jan. 17, 2009 at 3:51 p.m. blanketsbyjulie

Thanks for your help

July 1, 2009 at 5:17 p.m. PamLefcourt

Great, I'd just love a sale!

July 14, 2009 at 3:15 p.m. toybreaker

I would sell my soul (if I had one left) for more than one page of csv at a time - for long-established sellers, this is unfortunately an impossibility. :(

July 14, 2009 at 3:21 p.m. soundimages

This is great - but it still takes me forever to convert to Canadian currency at the time of sale. Any tips in this area?

July 14, 2009 at 3:31 p.m. foofooandmore

Yeah! This is a huge time saver for me.

July 14, 2009 at 3:49 p.m. musicalkitten

So I totally have the 1984 vintage item featured in this article. It was my favorite as a baby!

July 14, 2009 at 3:50 p.m. JudiPaintedit

Thank you, Thank you, Thank you!!!

July 14, 2009 at 3:51 p.m. midnightcoiler

What a helpful article! thanks!

July 14, 2009 at 3:54 p.m. JulieMeyer

If you're trying to separate the info into their own columns, here's how to do it in Excel:

In Excel, go to Data, then Get External Data, then select Import Text File.

Select your saved file, then select Delimited, click Next, in the Delimiters section, unclick Tabs and click Comma, under Text qualifier select the comma then finish.

July 14, 2009 at 4:04 p.m. clothpaperstitches

This is all helpful. Thanks.

July 14, 2009 at 4:05 p.m. Gypsymoondesigns

Thank you!!!

July 14, 2009 at 4:43 p.m. Fishstikks

Ooooh this is quite awesome and oh so easy!

July 14, 2009 at 4:44 p.m. ashjewels

ooohh this is great!

July 14, 2009 at 4:56 p.m. ApplewoodHandwovens

For being a non tec. savy person you keep creating and showing me these great helpful paths ... Thank You

July 14, 2009 at 5:31 p.m. graffiti2

Directions in Apple-speak would be nice. I have done this on my Mac and all I get is zillions of words with commas.

Anyone know how to make this work on a Mac Computer?

July 14, 2009 at 5:55 p.m. den10studio

This is great to know! It really simplifies things. Thanks!

July 14, 2009 at 6:09 p.m. xneoncanvas

Hmm... Not sure if this is working for me the way it is supposed to.
All the tab names and information is sorted into the wrong categories... am i doing anything wrong?

July 14, 2009 at 6:10 p.m. sweetrice

I used this feature when doing my taxes. I was able to import the information into a Microsoft excel sheet and add columns to it. It was wonderful to use!

I use a mac and it worked perfect.

July 14, 2009 at 6:43 p.m. novella

Aw, thank you thank you thank you.

July 14, 2009 at 6:59 p.m. Butterflysenses

This is useful. Thank you.

July 14, 2009 at 8:18 p.m. PaperPixieCreations

wow, sounds great! Hopefully a sale will come real soon so that I can try it out. :)

July 14, 2009 at 9:55 p.m. TheNightjar

thanks thats awesome!

July 14, 2009 at 10:38 p.m. KasualBead

Thank you. This is very helpful.

July 14, 2009 at 11:06 p.m. claycass

Thank you. This is a nice new tool.

July 15, 2009 at 8:12 a.m. willkaystudios

Thank you so much, this is a great time saver!

July 15, 2009 at 11:09 a.m. kinaloon

Thanks!

July 15, 2009 at 2:15 p.m. AccountingSPOT

This download is a GREAT way to efficiently and accurately track your bookkeeping!

I have set up my spreadsheets work from an easy copy/paste of the file.

July 16, 2009 at 5:24 a.m. SweetGraphics

Good to hear that it works on Mac as well!

July 16, 2009 at 1:45 p.m. HurricanePottery

Thanks, this is what I was looking for!

July 18, 2009 at 10:43 a.m. GimCarry

Thank you (* v *)

Aug. 18, 2009 at 6:32 p.m. MesaBlue

Thanks

Previous Page | Next Page