When opening a report or gate export CSV file from Formulayt in Excel, you may encounter an issue where records appear misaligned. This typically happens when fields contain line breaks, causing Excel to incorrectly interpret the data structure.
The problem
This issue occurs because of how Excel processes CSV files that contain text fields with line breaks. Excel misinterprets these line breaks as new records, causing your data to appear misaligned or broken across multiple rows.
The solution
Since this is an Excel limitation rather than a problem with the exported CSV files, follow these steps to properly work with your data:
Use alternative spreadsheet software to open the CSV file:
Google Sheets
LibreOffice Calc
OpenOffice Calc
Then choose one of these options:
Continue working with your data in the alternative software
Export the data to Excel format (.xlsx) from the alternative software
Open the exported Excel file, which should now display correctly
Why this works
Alternative spreadsheet applications handle the CSV import process differently and correctly parse fields with line breaks, preserving your data structure.
Important note
Unfortunately, because this is an Excel limitation rather than an issue with Formulayt's exported CSV files, we cannot offer other solutions to this problem. Using an intermediate application to process the CSV is the most reliable approach.