Accent characters not treated properly on list export

Since many of our names have accent characters in them, I would like a way to get properly formatted files or CSV files without all the table formatting. Currently, the only workaround I have found is saving the file as text and manually changing coding to 65001 UTF-8, which is quite cumbersome.
  • Brian Hoyt
  • Aug 27 2015
  • Attach files
  • Andrew Teets commented
    4 Mar, 2022 04:38pm

    +1 on allowing different file formats on imports - mac based shop here TY!!

  • Troy Yochelson commented
    4 Aug, 2021 11:01pm

    And, as I forgot to mention it, there's always the Terminal way:


    iconv -t UTF-8 {blackbaud export CSV file} > {new CSV file}


    UTF-8 is for direct Mac > Excel import (without using the Text Import Wizard); if you have a solution that uses another encoding, specify that encoding. If you need a listing, use iconv --list to see how to specify that encoding to iconv -t.

  • Troy Yochelson commented
    4 Aug, 2021 10:55pm

    As an aside for this (and seeing as how this has languished for 6 years now):


    Blackbaud's observed encoding (because of course they don't document it or anything) is ISO-8859-1.


    It is, however, not very difficult to change encodings. Tedious and unnecessary, perhaps, but not difficult.


    FOR IMPORTS TO BLACKBAUD

    In Windows:

    1. Open your CSV file in Notepad, which will automatically detect the correct encoding, unlike Excel);

    2. Select "File > Save as..."

    3. At the bottom, where the "Encoding" drop down is, select "ANSI" (this is Microsoft's ISO-8859-1, and seems close enough to be usable)

    4. Either save over the existing file or enter a new name, make sure your File Type is "All Files", include your .CSV extension and save it as a new file

    5. Upload to Blackbaud for import (and hope they haven't changed the format or messed it up in a novel fashion)


    In macOS:

    1. Open Terminal

    2. Run the following command:
      iconv -t ISO-8859-1 {your CSV filename and path} > {new CSV filename and path}

    3. Upload to Blackbaud for import (and hope they haven't changed the format or messed it up in a novel fashion)


    FOR BLACKBAUD EXPORTS

    On a Windows system, you shouldn't have to do anything; Blackbaud's standard encoding should work just fine.


    If you want to import into Google Sheets, Blackbaud's standard encoding also works...because Google Sheets checks the encoding of the file before importing it.


    On a macOS system, Numbers will also auto-detect the encoding properly.


    With Excel for Mac:

    1. Open an empty spreadsheet file

    2. Select "File > Import"

    3. Select "CSV", then click "Import"

    4. Locate and double-click the Blackbaud export file

    5. At "Text Import Wizard - Step 1 of 3", select "File origin: Windows (ANSI), then click Next
      NOTE: Western (ISO Latin 1) or Western (Windows Latin 1) will also work; however, "Macintosh" will NOT...and of course it can't auto-detect.

    6. At "Text Import Wizard - Step 2 of 3", select "Delimiters: Comma and click Finish OR click Next and make any additional changes in "Text Import Wizard - Step 3 of 3", then click Finish

  • +1