CSV Cleaner

Clean an Etsy sold orders CSV for bookkeeping

The Etsy sold orders download has dozens of columns, most of them about shipping. For bookkeeping you need one row per order with a date, a total, the processing fee and the net. Choose the file below: the page cleans it in your browser, shows the first 20 cleaned rows and lists every line it left out, with the reason.

Clean your Etsy sold orders CSV

The cleaner looks for the Sale Date, Order ID, Full Name, Currency, Order Total, Card Processing Fees and Order Net columns in the header row and writes eight fixed columns: date, description, amount, currency, fee, net, reference and source.

Your file is read in your browser and is never uploaded, stored or logged. It is held in the memory of this tab only, and closing or reloading the page discards it. Operator: Augeo. See the privacy notice.

Etsy can change the columns of this download, and this page makes no promise about yours: the free preview shows what it does to your file.

The cleaning logic is checked by an automated test script that runs the engine file of this site over six synthetic sample files and a set of checks of the parsing rules; it ran in a sandbox before this site was published and finished with no failed check. The script does not open this page in a browser, does not test the licence key step, and nothing was tested against a real export from any provider. Use the free preview to check your own file.

Download the full cleaned file

  • Price: 6 USD, paid once on Gumroad. No subscription. You receive a licence key.
  • What the key unlocks: the download of every cleaned row of the file you chose, as one CSV named after your file with -cleaned.csv at the end, instead of the first 20 rows on screen. The report and the way files are read stay the same.
  • The key is for one buyer. Runs are not counted and no number of runs is promised. The key is kept in the memory of this page only, so you enter it again after closing or reloading the page.
  • Refunds are requested through your Gumroad receipt and follow Gumroad's refund policy.
  • Try the free preview first. If the preview cannot read your file, the full download cannot either.

Get a licence key on Gumroad for 6 USD

What the cleaner changes in an Etsy sold orders export

This export covers the card processing fee only. Listing fees, transaction fees, advertising and shipping labels are in the monthly statement, which has its own page.

How to do the same by hand in a spreadsheet

These steps work in Excel, Google Sheets and LibreOffice Calc. The formulas below use placeholder column letters: Sale Date in A, Full Name in D, Order Total in X, Card Processing Fees in Z and Order Net in AA. Read your own header row and change the letters to match. If your spreadsheet uses a decimal comma, write the formulas with semicolons between arguments instead of commas.

  1. Work on a copy and keep the downloaded file untouched.
  2. Import the file with a proper CSV import, and import Sale Date as text. That keeps a quoted name with a comma in one cell and stops the spreadsheet guessing the day and month order.
  3. Set aside orders with no date. Filter the Sale Date column for blanks and move those rows to a separate sheet; look each one up in your shop before you add it back.
  4. Rebuild the date. If your Sale Date is text in the form MM/DD/YY, ="20"&RIGHT(A2,2)&"-"&LEFT(A2,2)&"-"&MID(A2,4,2) turns 02/14/24 into 2024-02-14.
  5. Flip the sign of the fee and fill the gaps with =IF(Z2="",0,-Z2), and fill empty net cells from the total with =IF(AA2="",X2,AA2).
  6. Build the description with ="Etsy order - "&D2, keep the eight columns, paste formulas back as values, delete the original columns and save as CSV UTF-8.
  7. Compare the result with the original: amount plus fee should equal net on every row, and the rows you kept plus the rows you set aside should add up to the rows you started with.

Notices

Other exports