Piano delivers CSV reports in the American format, where columns are separated by commas and decimals use dots (e.g., 1,234.56). However, many European systems expect CSVs with semicolons as column separators and commas as decimal markers (e.g., 1.234,56). This guide shows how to manually convert a CSV to the European format.
Step 1: Change the Column Delimiter
-
Generate and download the CSV report from Piano (for example the Transaction Log).
-
Open the CSV in a spreadsheet program (e.g., Excel or Google Sheets).
-
Save the file as "Text (Tab delimited) (.txt)".
-
Open the
.txtfile in a text editor (e.g., Notepad). -
Select and copy a Tab character.
-
Use Find and Replace to replace all Tab characters with semicolons (;).
-
Save the file and rename it with a
.csvextension if needed.
Step 2: Change the Decimal Separator
-
Open the modified file in your spreadsheet program.
-
Select the currency columns (or any columns with decimal numbers).
-
Use Find and Replace to replace all dots (.) with commas (,).
-
Save the updated file.
Your report is now in European CSV format, ready for import into systems that expect semicolon-separated values and comma-based decimals.