How to convert an Excel file to CSV
Although GenerateSEPA accepts .xlsx and .xls directly, sometimes you want a CSV (audits, version control, importing into other systems).
TL;DR
- In Excel: File → Save As → CSV UTF-8 (Comma delimited).
- In Google Sheets: File → Download → Comma-separated values.
- In Numbers: File → Export To → CSV (pick Unicode UTF-8).
- In LibreOffice: File → Save As → Text CSV, tick UTF-8.
Tips to avoid issues
- Use UTF-8 to preserve accents (
é,ñ,ç). - Pick comma or semicolon as separator and keep it consistent.
- Don’t mix decimal separators (all dot or all comma).
- If your Excel has multiple sheets, export only the one you need.
Conclusion
CSV is the “ASCII” of spreadsheets. Generated correctly (UTF-8, single separator, consistent decimals), any system will import it without surprises.
