Type of File Required for Importing - UTF-8 / Unicode

Summary: This guide explains that the Tithely importing tool only supports the UTF-8 encoded file format and details why this standard is critical for accurate data detection, especially for non-English characters, to prevent errors like missing fields or garbled text ("??").


Before You Begin

  • The Tithely importing tool only supports UTF-8 encoded files.
  • Incorrect encoding can lead to missing fields and garbled characters like "??."

What is UTF-8 and Why It Matters

UTF-8 is a common method of Unicode (a universal character standard) that uses 8-bit sequences to encode characters. This allows the file to be read correctly even when it contains non-English or special characters (like accents or symbols).

  • Accuracy: Without UTF-8 encoding, the importing tool cannot correctly detect all fields, leading to incorrect imports and data loss.
  • Integrity: It ensures that all characters are recognized, preventing data corruption where actual content is replaced by question marks ("??").
  • Security: Using UTF-8 is considered more secure and provides more accurate results during the import process.

Step-by-Step Instructions

  1. Open your CSV file in your spreadsheet application (e.g., Excel, Google Sheets).
  2. Locate the Save As or Export option.
  3. Choose the file format option, selecting "CSV (Comma delimited)" or similar.
  4. Crucially, look for and select the option to save or export with UTF-8 encoding. (This option varies by application—sometimes found under "Tools," "Web Options," or "Encoding" in the Save As dialog box).
  5. Click Save.
  6. Upload the newly saved UTF-8 encoded CSV file using the importing tool.

Troubleshooting & FAQs

  • Where can I find instructions for my specific application (Excel, etc.)? For a list of common applications and detailed export instructions, check the link: https://www.xadapter.com/how-to-save-csv-excel-file-as-utf-8-encoded/
  • I see "???" after importing: This is the tell-tale sign that your file was not correctly encoded in UTF-8. You must re-save the original file using the correct UTF-8 encoding process.
  • Does Tithely plan to support other encoding formats? Currently, the Tithely importing tool only supports UTF-8 for secure and accurate results.