Importing Problems

If your file is failing to import, check this important tips:

• Check if the file is supported (Supported File Formats);
• Remove full empty columns (without data and header);
• Remove full empty rows/lines;
• Remove all non date, text or number data type column (like images);
• Remove merged cells;
• Remove or format correctly date column not identified by the spreadsheet;
• Remove unknown, strange or control characters;
• Remove special characters and dots (.) from headers titles;
• Remove non-mathematical and complex expressions (Expressions);
• If using headers, fill it for all columns;
• Check for data type mixed columns. All cells in a column must be the same data type;
• Check if some column its not exceeding the size limit (See limits);
• Check if the file its not exceeding the columns limit (See limits);
• Check if the file its not exceeding the rows limit (See limits);

• Specific for CSV files:
  • Check if selected file encoding, column and decimal separator match the file;
  • Try to save as XLS or XLSX to import;