CSV export
Overview
CSV export is a Pro feature with two exports, matching the two places you look at your numbers: the dashboard’s per-country threshold breakdown, and the quarterly OSS filing reports.
This feature requires a Pro license. See pricing and Licensing for details.
Dashboard export: country breakdown
On the Dashboard tab at WooCommerce → One Stop Shop, the country breakdown table has an Export CSV button in its header. It downloads the selected year’s per-country standing as oss-export-YYYY.csv with these columns:
- Country — the destination member state.
- Country Code — the two-letter code.
- Net Sales (EUR) — net cross-border B2C sales for the year.
- Orders — the number of tracked orders.
- % of Threshold — that country’s share of the EUR 10,000 limit.
A totals row at the bottom sums the sales and order counts and shows your overall threshold percentage. Use the dashboard’s year selector first to export a previous year.
Quarterly report export
Each quarter on the Reports tab has its own Export CSV action, which downloads oss-report-YYYY-QN.csv — the filing-ready figures for that quarter:
- Country
- Country Code
- Standard VAT Rate (%)
- Net Sales (EUR)
- VAT Due (EUR)
plus a totals row for net sales and VAT due. See Quarterly OSS reports for how these figures are calculated, including how refunds and manual adjustments are treated.
File format notes
- Amounts use a plain decimal point with no thousands separators, so spreadsheets and accounting tools parse them as numbers without locale guesswork.
- All values are hardened against spreadsheet formula injection — a cell can never execute as a formula when the file is opened in Excel, LibreOffice, or Google Sheets.
- Exports require a logged-in user with the WooCommerce management capability; the files are generated on demand and not stored on the server.
Tips
- Export quarterly — even below the threshold, keeping a per-quarter paper trail makes a later registration or audit much easier.
- Verify before filing — cross-check exported totals against the on-screen report before entering them in your OSS portal.
- Store exports securely — treat the files as business records.