Locoia
WebsiteApp
Search…
Overview
Account and User Settings
Reset your Password
Invoices and Payments
Automation
Flow Builder
Flow Debugger
Community Library
Connectors & Helpers
Connectors
Helpers
Authentication Types Available
Building Connectors
Building Connector Actions
Webhook Trigger for Connectors
Data Mapping and Env Variables
Embed - White Label Portal
1. Embed Setup
2. Embed Flow Building
Embed FAQs
Data and Dashboards
Dashboards & Insights
Charts
Forecasts
Best Practice Guides
Integration Best Practices
Integration Check List
CSV Files in Excel
Multi-Tenant Flows
On-Premise Integrations
Database Connection Setup
Data and General Security
Using Tags
FAQ
API
Locoia API Authentication
Create Connector Authentication
Contact us
Status of Service
Data Privacy
Imprint
Powered By GitBook
CSV Files in Excel
Encoding CSV Files in Excel with UTF-8 with BOM
When working with CSV files and special characters, such as the German Umlaute, one has to be careful with opening those files in Excel, as often the special characters are not transformed correctly and are saved as such. This results in wrong formatting when uploading the CSV to a Locoia flow or any other system.
As a solution, one should use Sublime Text to handle such files and open them and then Save with Encoding > UTF-8 with BOM. This should preserve the "Umlaute" when you now open the CSV with Excel.
Sublime - Save with Encoding - for encoding issues Excel
Also see encoding for AWS S3 files.
Best Practice Guides - Previous
Integration Check List
Next - Best Practice Guides
Multi-Tenant Flows
Last modified 7mo ago
Copy link