The import looks wrong
A whole column empty, numbers as text, dates as text, the header row inside the data, blank rows, the wrong row count — find the symptom, get the cause. The full version is in the import chapter; this is the quick lookup.
| Symptom | Most likely cause | Fix |
|---|---|---|
| A whole column is empty after appending | The column names in the file don't match the table's | Make them match and import again; hand out the blank Template to whoever fills the file in |
The amount column's header shows T and sums to 0 |
It was guessed as text | Field Type → Numeric; if the contents are mixed with symbols, clean them in a formula column |
| Dates show as text and date-range filters do nothing | Inconsistent formats | Keep the raw column, derive one with dateformat, set its field type to Date |
| Every column is named "untitled" and the headers became the first data row | The first row is a merged title bar | Import again, trimming the title row, or use the merged-header import option |
| Lots of extra blank rows | Rows at the bottom of the source with formatting but no content | Trim them in the preview, or filter empties and delete |
| Fewer rows than the file has | A unique index merged duplicates; only one worksheet imported; merged cells split | Check the index column; import the other worksheets separately |
| More rows than the file has | The same file imported twice with no unique index | Set a unique index, or use Import → replace data |
| A formula column stays empty | Still computing, or a referenced column has the wrong field type | Wait a few seconds; see Formulas that don't compute |
| Nothing happened at all | The file is locked by Excel, or it is over the upload size | Close Excel; split the file |
Each of these is explained at length in When the import looks wrong.