How to Properly Open an octapipe Export in Excel

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.

5º Step: Load the data

Click “Load”.

The data will be imported correctly, with all accents and special characters preserved.

Best practices:

• 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.

Conclusion:

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.