How to Properly Open an octapipe Export in Excel
Learn how to import CSV files into Excel without accent or character encoding issues, ensuring all exported data is displayed correctly.
Support Team
Last Update 8 months ago
When exporting data in CSV format, Excel may open the file with accentuation issues, displaying some characters incorrectly. This happens because Excel does not always automatically recognize the UTF-8 encoding standard used by octapipe. Follow the step-by-step guide below to resolve this issue.
1º Step: Open Excel
Open Microsoft Excel normally.
2º Step: Access the import menu
In the top menu, click:
Data → Get Data → From File → From Text/CSV
This path forces Excel to respect the file’s encoding standard.
3º Step: Select the CSV file
Locate the file exported from octapipe and click “Import”.
4º Step: Configure the import correctly
In the preview screen, confirm exactly the following options:
- File Origin: 65001 : Unicode (UTF-8)
- Delimiter: Semicolon (;)
Important: octapipe exports CSV files using “UTF-8” encoding and “Semicolon” as the separator. Any other combination may cause reading errors.
Click “Load”.
The data will be imported correctly, with all accents and special characters preserved.
- Always use Data → Get Data → From File → From Text/CSV.
- If Excel applies incorrect settings, close the file without saving and repeat the process.
- This procedure applies to any CSV export from the platform.
By following this import flow, you ensure that data exported from octapipe is displayed correctly in Excel, without information loss or character encoding issues. This prevents rework, reading errors, and misinterpretation of data.