Check first our Excel Importing Guide.
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 it not exceeding the columns limit (See limits);
- Check if the file it not exceeding the rows limit (See limits);
- Specific for CSV files:
- Check if selected file encoding, columns, decimal separator and date mask match the file;
- Try to save as XLS or XLSX to import;
Download a sample file here: Sales_en+US.xlsx
Important
To maintain the correct operation of the created dashboards, some definitions and settings can not be changed later in the data source and in the import file:
- Columns can not be added between the original columns in the file;
- It is possible to add column to the end of the file;
- Columns names can not be changed in the file header;
- Column names can be changed in the Input Data Format step, but objects that already use this column will keep the previous name.
- To update, remove and add again the column to the object;
- Columns can not be removed from the file;
- Columns must maintain its original order in the file;
- Columns data type can not be changed;