Upload a CSV File

Upload large CSV, TSV, or TXT files in 3 clicks.

Auto-detect file format

By default, Acho auto-detects the column delimiter and the data types (schema). If you data looks good, simply click the Upload button to start the process.

Configure a CSV file manually

In case your CSV file does not have a row that contains column names, or it has unsupported values (e.g. special characters, and reserve words), you can configure your CSV file's header manually. By unchecking the Auto-detect button, you can

  1. select a delimiter: Acho Studio detects the column delimiter automatically. We support comma, semicolon, tab, and pipe. Please let us know if you need extra file type supported

  2. add a header row: If your file does not have column names, you can check this box to enter your custom column names.

  3. Columns (name and data type): Change your column name, refine your column data types, and remove unwanted columns.

When your CSV file looks good, simple click the Upload button to start the process.

Safe mode upload

Safe mode is a feature built to ensure success of your CSV file upload. There is a number of reasons that could cause your upload to fail,

  • Use of invalid character like (-) hythen, ()parentheses (.)period, colon(;), Asterisks (*) and other characters.

  • Line breaks in the column fields

  • Separator characters in the text of the CSV files

  • Long numbers that have leading zeroes

  • CSV file not using UTS

  • Non-printable ASCII control characters like CR or LF at the end of the line

  • Blank lines at the end of the corrupted CSV files

  • Duplicate column (data field) names

  • Text field with unescaped delimiter

  • Quoted string with an unescaped double quote

  • CRLF/Dos line endings

  • Non-standard escape characters

  • Unrecognized Unicode/Illegal Codepoint

When Safe mode is checked, Acho Studio's system will handle all these error cases and make sure your data can be parsed by a relational database management system (RDBMS). Within safe mode, Acho needs to change all your column data types to string, thus your CSV upload become more likely to be successful.

Please contact us if you have any problems uploading your file.