LogoLogo
Log InSign UpHomepage
  • 👋Welcome
  • Account and Team Setup
    • Sign up
    • Subscription Plans
    • Profile information
    • Account information
    • Roles
    • Users
    • Tags
    • Logs
  • FAQ
  • UNDERSTANDING MACHINE LEARNING
    • What is Graphite Note?
      • Graphite Note Insights Lifecycle
    • Introduction to Machine Learning
      • What is Machine Learning
      • Data Analitycs Maturity
    • Machine Learning concepts
      • Key Drivers
      • Confusion Matrix
      • Supervised vs Unsupervised ML
  • Demo datasets
    • Demo Datasets
      • Ads
      • Churn
      • CO2 Emission
      • Diamonds
      • eCommerce Orders
      • Housing Prices
      • Lead Scoring
      • Mall Customers
      • Marketing Mix
      • Car Sales
      • Store Item Demand
      • Upsell
    • What Dataset do I need for my use case?
      • Predict Cross Selling: Dataset
      • Predict Customer Churn: Dataset
      • Predictive Lead Scoring: Dataset
      • Predict Revenue : Dataset
      • Product Demand Forecast: Dataset
      • Predictive Ads Performance: Dataset
      • Media Mix Modeling (MMM): Dataset
      • Customer Lifetime Value Prediction : Dataset
      • RFM Customer Segmentation : Dataset
    • Dataset examples - from online sources
      • Free datasets for Machine Learning
  • Datasets
    • Introduction
    • Prepare your Data
      • Data Labeling
      • Expanding datasets
      • Merging datasets
      • CSV File creating and formatting
    • Data sources in Graphite Note
      • Import data from CSV file
        • Re-upload or append CSV
        • CSV upload troubleshooting tips
      • MySQL Connector
      • MariaDB Connector
      • PostgreSQL Connector
      • Redshift Connector
      • Big Query Connector
      • MS SQL Connector
      • Oracle Connector
  • Models
    • Introduction
    • Preprocessing Data
    • Machine Learning Models
      • Timeseries Forecast
      • Binary Classification
      • Multiclass Classification
      • Regression
      • General Segmentation
      • RFM Customer Segmentation
      • Customer Lifetime Value
      • Customer Cohort Analysis
      • ABC Pareto Analysis
      • New vs Returning Customers
    • Advanced ML model settings
      • Actionable insights
      • Advanced parameters
      • Model Overview
      • Regressors
      • Model execution logs
    • Predict with ML Models
    • Improve your ML Models
  • Notebooks
    • What is Notebook?
    • My first Notebook
    • Data Visualization
  • REST API
    • API Introduction
    • Dataset API
      • Create
      • Fill
      • Complete
    • Prediction API
      • Request v1
        • Headers
        • Body
      • Request v2
        • Headers
        • Body
      • Response
      • Usage Notes
    • Model Results API
      • Request
        • Headers
        • Body
      • Response
      • Usage Notes
      • Code Examples
    • Model Info API
      • Request
        • Headers
        • Body
      • Response
      • Usage notes
      • Code Examples
Powered by GitBook
On this page
  • 1. File Too Large
  • 2. Incorrect Delimiters or Quoting
  • 3. Encoding / Special Character Issues
  • 4. Missing or Inconsistent Headers
  • 5. Date/Time Format Confusion
  • 6. Empty or Corrupted Rows
  • 7. Network or Timeout Errors
  • Additional Resources
  • Still Need Help?

Was this helpful?

Export as PDF
  1. Datasets
  2. Data sources in Graphite Note
  3. Import data from CSV file

CSV upload troubleshooting tips

If you’re experiencing problems when uploading CSV files to Graphite Note, this page provides a concise list of common issues and recommended solutions.

1. File Too Large

Symptom: You receive an error indicating that the file exceeds the size limit.

Cause: Graphite Note enforces a maximum 50 MB limit for CSV uploads.

Solution:

  • Split the dataset into multiple smaller CSV files.

  • Remove unnecessary columns or rows to reduce file size.

  • Connect directly to a database (e.g., PostgreSQL, MySQL, BigQuery) for larger datasets.


2. Incorrect Delimiters or Quoting

Symptom: Data is misaligned, or you see parsing errors.

Cause: Inconsistent delimiter usage (e.g., commas in some rows, semicolons in others) or unescaped quotes.

Solution:

  • Ensure a single, consistent delimiter throughout (commas or semicolons).

  • Escape or quote fields that contain the delimiter (e.g., "123, Main Street").


3. Encoding / Special Character Issues

Symptom: Special characters (e.g., accented letters, non-Latin scripts) appear as garbled text or question marks.

Cause: The CSV file is not saved in UTF-8 format.

• Solution:

  • Save or export the file in UTF-8.

  • Convert the file encoding using a text editor (e.g., VSCode, Notepad++) if CSV UTF-8 is not available in your spreadsheet software.


4. Missing or Inconsistent Headers

Symptom: Your upload fails, or certain columns are not recognized.

Cause: The first row does not contain meaningful column names, or column names differ between rows.

Solution:

  • Always include a header row with consistent, clear column names.

  • Avoid special characters or spaces in headers; use underscores or camelCase instead.


5. Date/Time Format Confusion

Symptom: Dates appear as 0000-00-00 or fail to parse entirely.

Cause: Inconsistent date/time formats (e.g., mixing MM/DD/YYYY with YYYY-MM-DD).

Solution:

  • Standardize all date fields to a single format (e.g., ISO 8601: YYYY-MM-DD HH:MM:SS).

  • Confirm your spreadsheet application doesn’t convert date formats automatically.


6. Empty or Corrupted Rows

Symptom: You see blank rows or the upload process halts unexpectedly.

Cause: Hidden rows, line breaks, or a corrupted export process.

Solution:

  • Remove any hidden or blank rows in your spreadsheet before exporting.

  • Open the CSV in a plain text editor to confirm each row is valid and properly delimited.


7. Network or Timeout Errors

Symptom: The file upload keeps failing or timing out.

Cause: Unstable internet connection or very large file size near the 50 MB limit.

Solution:

  • Split the file if it’s too large.

  • Retry on a stronger or wired internet connection.


Additional Resources


Still Need Help?

PreviousRe-upload or append CSVNextMySQL Connector

Last updated 2 months ago

Was this helpful?

Learn how to format and encode your CSV files for best results.

Step-by-step instructions on exporting your data to CSV format.

Explore a code-free approach to sending data directly to Graphite Note without manual file uploads.

If you’ve tried these suggestions and still experience issues, contact our support team by emailing . We’re here to help you resolve any CSV upload problems and ensure your data is correctly imported.

CSV File creating and formatting
Dataset API
hello@graphite-note.com
Creating a CSV from Excel