Reading your P&L Answer 28 of 36 Updated

Why does the export ask about number format?

Because Excel in German and most other tools read a CSV file in opposite ways. A CSV is a plain text file that holds a table. Excel set to German expects a comma before the cents and semicolons between the columns. It reads a full stop as a thousands mark. A reporting tool, a script or another system wants a plain decimal point and commas between the columns.

So when you export a CSV in Settings, Data export, you choose each time. In the Numbers row, pick 1.234,56 for German Excel, or 1234.56 for imports and BI tools. BI tools are reporting tools. 1.234,56 writes money as 1.234,56 and percentages as 19,0%. It puts semicolons between the columns, so the file opens straight into columns in German Excel. 1234.56 writes money with no thousands marks and percentages as fractions, like 0.19. It puts commas between the columns.

Dates are written as 2026-10-01 in both. Every Excel reads that the right way, whatever its language. Excel and JSON files do not ask. They store real numbers and let the program decide how to show them. The full account export uses the plain format on purpose, because other software reads it.

If you are not sure, use this simple rule. Will you open the file yourself in Excel on a German or Austrian computer? Pick 1.234,56. Will it go to a tool, a developer or your accountant's software? Pick 1234.56. Why the app itself writes 1.234,56 is in why numbers look like 1.234,56.

Where you find it Settings · Data export

app.nouz.co/settings
The number format choice set to 1.234,56 (German Excel), next to the file format CSV.
1.234,56 for German Excel, or a plain decimal point for other tools, chosen for each download.

Was this answer helpful?

More in Reading your P&L

All 36 questions
  1. 26 What is in the daily profit email?
  2. 27 Can I export the statement itself?
  3. 28 Why does the export ask about number format? You are reading this
  4. 29 Why do numbers look like 1.234,56?
  5. 30 What is on each Insights tab?

See what your store really kept yesterday.

Install nouz in minutes from the Shopify App Store. It imports every order your store has ever taken. Cancel anytime.

Your trialToday
14 days of nouz, every feature€0,00
Card needed to startNone
Access to your storeRead-only
Due today€0,00