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

TechUpdates

Story by TechUpdates

Published on Mar 20, 2008 in Etsy News

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!

Discuss: 84 comments

Related Items

84 comments

Sign in to add your own
  • OneHoney

    OneHoney says:

    A big YEA! for this. Thanks!

    4 years ago

  • aloka

    aloka says:

    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 :-)

    4 years ago

  • pulpsushi

    pulpsushi says:

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

    4 years ago

  • annacote

    annacote says:

    this is incredibly helpful - thank you!

    4 years ago

  • Stockton

    Stockton says:

    Oh this is exciting - thank you!

    4 years ago

  • Itybitybags

    Itybitybags says:

    wow! That is awesome thank you :)

    4 years ago

  • sushipot

    sushipot says:

    Thank you!!!

    4 years ago

  • pookeh

    pookeh says:

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

    4 years ago

  • ClaudiaLord

    ClaudiaLord says:

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

    4 years ago

  • melissakate

    melissakate says:

    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.

    4 years ago

  • KatieCarolinaDesigns

    KatieCarolinaDesigns says:

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

    4 years ago

  • MagpieCollections

    MagpieCollections says:

    great features..!!!

    4 years ago

  • sewbettie

    sewbettie says:

    Yeah! This is a huge timesaver for me.

    4 years ago

  • janicej

    janicej says:

    Very helpful. Thanks!

    4 years ago

  • ErinTyner

    ErinTyner says:

    Thank you!!

    4 years ago

  • supastarr

    supastarr says:

    Awesome! Thanks!

    4 years ago

  • BluewaterStudio

    BluewaterStudio says:

    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

    4 years ago

  • mmmfiber

    mmmfiber says:

    Wow! That's really something! Thankyouthankyouthankyou

    4 years ago

  • wildflowerdesigns

    wildflowerdesigns says:

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

    4 years ago

  • marciapalmer

    marciapalmer says:

    Bravo! Thank you!

    4 years ago

  • XOHandworks

    XOHandworks says:

    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?

    4 years ago

  • loosewirestudio

    loosewirestudio says:

    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!!! :)

    4 years ago

  • JJMFinance

    JJMFinance says:

    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.

    4 years ago

  • brennx0r

    brennx0r says:

    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

    4 years ago

  • elisasherejewelry

    elisasherejewelry says:

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

    4 years ago

  • meloearth

    meloearth says:

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

    4 years ago

  • sylviavincent

    sylviavincent says:

    This is fabulous :-)

    4 years ago

  • blackbird72

    blackbird72 says:

    this is SAVING me!

    4 years ago

  • miriam

    miriam says:

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

    4 years ago

  • debrlee

    debrlee says:

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

    4 years ago

  • glasstastictreasures

    glasstastictreasures says:

    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

    3 years ago

  • jellygnite

    jellygnite says:

    thank you for the great info!

    3 years ago

  • DenikDesigns

    DenikDesigns says:

    I have to keep this one in mind

    3 years ago

  • PenguinsPlunder

    PenguinsPlunder says:

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

    3 years ago

  • craftyfolk

    craftyfolk says:

    just discovered this, thank YOU!

    3 years ago

  • blanketsbyjulie

    blanketsbyjulie says:

    Thanks for your help

    3 years ago

  • PamLefcourt

    PamLefcourt says:

    Great, I'd just love a sale!

    2 years ago

  • toybreaker

    toybreaker says:

    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. :(

    2 years ago

  • soundimages

    soundimages says:

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

    2 years ago

  • foofooandmore

    foofooandmore says:

    Yeah! This is a huge time saver for me.

    2 years ago

  • musicalkitten

    musicalkitten says:

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

    2 years ago

  • JudiPaintedit

    JudiPaintedit says:

    Thank you, Thank you, Thank you!!!

    2 years ago

  • midnightcoiler

    midnightcoiler says:

    What a helpful article! thanks!

    2 years ago

  • JulieMeyer

    JulieMeyer says:

    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.

    2 years ago

  • clothpaperstitches

    clothpaperstitches says:

    This is all helpful. Thanks.

    2 years ago

  • Gypsymoondesigns

    Gypsymoondesigns says:

    Thank you!!!

    2 years ago

  • Fishstikks

    Fishstikks says:

    Ooooh this is quite awesome and oh so easy!

    2 years ago

  • ashjewels

    ashjewels says:

    ooohh this is great!

    2 years ago

  • ApplewoodHandwovens

    ApplewoodHandwovens says:

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

    2 years ago

  • graffiti2

    graffiti2 says:

    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?

    2 years ago

  • den10studio

    den10studio says:

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

    2 years ago

  • xneoncanvas

    xneoncanvas says:

    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?

    2 years ago

  • sweetrice

    sweetrice says:

    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.

    2 years ago

  • novella

    novella says:

    Aw, thank you thank you thank you.

    2 years ago

  • Butterflysenses

    Butterflysenses says:

    This is useful. Thank you.

    2 years ago

  • PaperPixieCreations

    PaperPixieCreations says:

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

    2 years ago

  • TheNightjar

    TheNightjar says:

    thanks thats awesome!

    2 years ago

  • KasualBead

    KasualBead says:

    Thank you. This is very helpful.

    2 years ago

  • claycass

    claycass says:

    Thank you. This is a nice new tool.

    2 years ago

  • willkaystudios

    willkaystudios says:

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

    2 years ago

  • kinaloon

    kinaloon says:

    Thanks!

    2 years ago

  • AccountingSPOT

    AccountingSPOT says:

    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.

    2 years ago

  • SweetGraphics

    SweetGraphics says:

    Good to hear that it works on Mac as well!

    2 years ago

  • HurricanePottery

    HurricanePottery says:

    Thanks, this is what I was looking for!

    2 years ago

  • GimCarry

    GimCarry says:

    Thank you (* v *)

    2 years ago

  • MesaBlue

    MesaBlue says:

    Thanks

    2 years ago

  • ArtHappens

    ArtHappens says:

    Great...how about downloading a year's worth at one stretch, for taxes?

    2 years ago

  • slugwork

    slugwork says:

    Does anyone know if this works for macs? I don't have microsoft anything... Thanks!

    2 years ago

  • suzysfriend

    suzysfriend says:

    Thanks - too bad it's such a well-kept secret and hard to find. Please consider adding the Etsy seller fees to this list as well for a complete financial overview. If you want to encourage sellers to pay their taxes, please make the tools easy and accessible. Thanks.

    2 years ago

  • CraftyisCool

    CraftyisCool says:

    Yes! yearly totals would be great, as well as seller fees. Taxes are hard without this!!

    2 years ago

  • GiftsofSilk

    GiftsofSilk says:

    WOW!!! Thanks so Much!

    2 years ago

  • bluepiedesigns

    bluepiedesigns says:

    will definately check this out!

    1 year ago

  • JoyfulExpressions2

    JoyfulExpressions2 says:

    Are csv data files only available on items sold? I would like to have a csv copy of all items I have placed on Etsy along with all matching data in a spreadsheet format.

    1 year ago

  • ReverseStitch

    ReverseStitch says:

    I love you guys

    1 year ago

  • gkolb

    gkolb says:

    It would be very good for those of us who spend money on Etsy to have this same service. I purchase lots of lampwork beads for my line of necklaces and need to keep track of the per bead cost of my inventory. Can Etsy help the buyer as well as the seller? Thank you. Gabriele

    1 year ago

  • buzybeeding

    buzybeeding says:

    OH Thank you Thank you!

    1 year ago

  • fieldday

    fieldday says:

    xoxo

    1 year ago

  • buttertownantiques

    buttertownantiques says:

    What a time saver, Thanks

    1 year ago

  • suchastitch

    suchastitch says:

    yipee!

    157 days ago

  • sistersilver

    sistersilver says:

    Since open office is now White Label Office, you might update that on your article. After playing around I tweeked it so I could finally read the information in columns, so yea! it works! Thank you. It would still be great if we could have the sale price of sold items on the billing. I have to spend quite a bit of time going back to see what the price was and it is not something that is not important at tax time! Think we could convince you to work that in?

    153 days ago

  • MartyMay

    MartyMay says:

    Also, why can we not download the csv file for the entire month? You can only go page by page (20 at a time) which takes quite a while for each month if you have many sales.

    140 days ago

  • MartyMay

    MartyMay says:

    Never mind! I figured it out :)

    140 days ago

  • dressingOnTheSide

    dressingOnTheSide says:

    hey there- my accountant suggested having a "TOTAL" column at the bottom to make it easy. Can this be done?

    133 days ago

  • sabastiensnook

    sabastiensnook from sabastiensnook says:

    is there a way to export your customer's contact information?

    58 days ago