This documentation relates to CiviCRM version 3.1. It's not maintained anymore.
Current version of documentation.

Error Not CSV File

Skip to end of metadata
Go to start of metadata

This page refers to outdated version of CiviCRM. Check current version of documentation.


Documentation Search


CiviCRM 3.1 Documentation

Support and Participation

Developer Resources


CiviCRM book!

Make sure to check out Understanding CiviCRM as well! You can also support this project by ordering a hard copy.

Not a CSV file, creating UTF-8 files for import.

The CiviCRM import system requires csv files encoded in UTF-8 to correctly import 'accented' characters.

If you get an error message saying that your import is 'not a csv file' even though it is, then it's likely that you have accented characters and don't have UTF-8 encoding.

Although CiviCRM says that you can easily use csv files exported from Excel; Excel can't create UTF-8 encoded csv files. You need to go through an extra step to change the coding.

The simplest route that I have found is to save the csv file from Excel, then open it in Microsoft Word and Save as a 'Text' file (remembering to keep the .csv suffix). When you click Save an encoding box opens and you can choose 'Other encoding | Unicode UTF-8'.

Labels
  • None

Creative Commons License
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-Share Alike 3.0 United States Licence.