![]() You should see that lines have now appeared in the bottom data section splitting the information up into separate columns. When you select your file you will see a Text Import window like the one below. The Import Wizard works automatically but there are a couple of options we need to select to make sure the data loads correctly. If this happens - Happy Days - just double check that your data looks ok. Occasionally your file opens straight into Excel without going through the Wizard. Step 2: Import your Dataīecause 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. Browse to the folder where you saved your files and select the one you want to view. Go into Excel and select Open to load your CSV file. Just so you know, I used the Etsy Payment Report for my examples Step 1: Open Excel The notes below are written for Excel but most Spreadsheet programmes will have a similar process to access your data. To use your information you first need to open it up in your Spreadsheet programme. ![]() So what do you do with it now? How to see your data in your Spreadsheet Hooray - you have now successfully downloaded your Etsy information as a CSV file and saved onto your computer. You can read more about downloading your Sold transactions at Etsy helpĮXTRA TIP: The Etsy Payments Deposits file is great to use alongside the download of your Etsy Payments Account so you can match up what you've received with the detail of each payment. Make your choice and save the file onto your computer. This shows you 1 lines for each orderĮtsy Payments Sales - all payments for Sales made through Etsy Payments - this is also the source of your Etsy 1099 ReportĮtsy Payments Deposits - all deposits made to your bank accountįor each of these, you can also choose whether to download for a specific month or get all the data for a full year in one go. This shows multiple lines per order so you can see exactly what items have been sold. Click on the box CSV Type to make your choice between: The bottom section then gives you a choice of 4 different reports. This downloads all of your Active Listings including Title, Description, Images and Tags. ![]() You can download a number of different reports from Etsy about your shop and they all come down as CSV files.Īt the top you can download a list of all items currently for sale. If you want to know more, check out my detailed post Etsy Payment Account: Everything you need to know Other Information to Downloadįor some reason Etsy hides away most of your other downloads under Settings -> Options -> Download Data This is found under Finances > Payment Account and scrolling down until you can choose an individual month. ![]() ![]() What Data can I download from Etsy?Īt the time of writing you can download the following information Etsy Payment Account If this sounds like the post for you, let's get started. If you're reading this then I'm guessing you want to download some of your data from Etsy? Maybe you're not sure where to find it? Maybe you've found it but you're not sure what to do with it when it's downloaded?ĭon't worry - I'm going to walk you through exactly what information you can download from Etsy, where to find it and how to open your files in your spreadsheet programme once they’re on your computer. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |