How do you download etsy file as csv file

Once you download your information, this final column is missing. You need to do some manual calculations to work out your running balance. OK, so now you have got your Etsy Payments data into Excel and you know what information is shown. The final question is what do you do with it now?? Click through for full details. PS: Why not pin this for later so you can find it again next month when you download your next Etsy Payments Statement?

The sound on the video above is not working. Thank you so so much for sharing your knowledge because accounting with Etsy is my most dreaded thing with my small buisness! Your email address will not be published. Skip to content. Where to Find your Etsy Payments Statement The option to download your monthly payment transactions is hidden away at the bottom of your Payment Account. Choose the month you want to get the information for, and then click CSV. Related Posts.

Leave a Comment Cancel Reply Your email address will not be published. If you want a really easy way to access your Payments data from Etsy, why not check out the Etsy Payments Dashboard.

Hooray — you have now successfully downloaded your Etsy information as a CSV file and saved onto your computer. To use your information you first need to open it up in your Spreadsheet programme. The notes below are written for Excel but most Spreadsheet programmes will have a similar process to access your data. Browse to the folder where you saved your files and select the one you want to view.

Because the data is in CSV format which just means that it is a text file with the different data sets separated by commas , we need to push the file through the Text Import Wizard to enable Excel to read the data. Occasionally your file opens straight into Excel without going through the Wizard.

If this happens — Happy Days — just double check that your data looks ok. The Import Wizard works automatically but there are a couple of options we need to select to make sure the data loads correctly. You should see that lines have now appeared in the bottom data section splitting the information up into separate columns. We can help the data load along by changing the format of any date column from General to Date — and then by selecting MDY in the drop down box as below.

The issue is in your download settings. Thank you. Do you have another suggestion where it might be hidden? I clicked the "CSV" button and it downloaded fine. I've opened it and it works normally. CSV files are run on gibberish : They're comma or other symbol separated text files that programs like Excel and google docs usually knows how to split up in to columns based on the placement of the commas or other symbol.

It sounds like you might have accidentally associated CSV files with google docs or if you're using Chrome maybe it has done it on your behalf to attempt to be helpful. Are you seeing the "Generate CSV" button? Or is just "CSV"? I have been emailing back and forth with Etsy Support for 2 weeks and they still have not solved the issue.

I don't know how you figured it out but when I right clicked and selected download linked file - it was a CSV file.

I can't thank you enough. I'm on a Mac and this worked for me too, right click to select "download linked file" rather than getting the google link to un organised data. Thank you - it was driving me mad.

This is still an issue in You saved me from crying! Thank you so much. Sign In Help. Turn on suggestions.