Getting data in

Files, paste, images and JSON come in once; data connections keep coming in. The primary key decides whether repeated data updates a row or adds one.

1. Upload Excel and CSVThe whole Import window: pick the file, pick the worksheet, tidy it up (transpose, cut, merge, delete), append or replace, and how columns line up by name. Multi-sheet merging and empty headers are covered too.
2. Paste to importCopy a block from Excel, a web page or an email and paste it straight into the Import window. The same preview and tidy-up tools as a file import — right for small batches that are not worth saving as a file.
3. Image to table — invoices, receipts, screenshotsTurn an invoice, a scan or a screenshot of somebody's report into a table. Three steps: upload the image, choose the target table, confirm. Needs your own AI key, and the image goes to the model provider you chose.
4. JSON to tableA JSON file returned by an API becomes a table directly — the keys of an object array become columns, one object per row. For when you already have an API result and do not want to configure a connection.
5. Manual entry — Add Row, forms and the import templateNot all data comes from a file. Enter it one row at a time with Add Row or a form view; to have someone else fill in your columns, send them the empty Excel that Template downloads.
6. Data connections — databases, APIs and cloud drivesKeep a table following an external source. Supports HTTP endpoints, MySQL / SQL Server / Oracle / Hana, and Google Sheets, OneDrive, Google Drive, Dropbox, Airtable and Notion. This page covers the four-step wizard and a connection's life cycle.
7. Connect a database — MySQL, SQL Server, Oracle, HanaFour JDBC sources, the four wizard steps in detail, choosing an incremental field so each sync only fetches what is new, and how to read the errors when a step will not pass.
8. Connect an HTTP endpointTwo directions — TableDI pulls your endpoint on a schedule, or an external system pushes into an address TableDI gives you. Covers headers, the debug request, and using JSONPath to point at the array in the response.
9. Connect a cloud drive or online spreadsheetGoogle Sheets, Google Drive, OneDrive, Dropbox, Airtable and Notion. Authorise once, choose a file or a base, and the table follows it. One direction only — from the cloud into TableDI.
10. The primary key — update instead of duplicateName one column as the table's unique key, and from then on re-importing, pasting or syncing the same key updates that row instead of adding another. This is the switch behind "incremental updates" and "no duplicates".
11. When the import looks wrongA column arrives empty, numbers become text, the header ends up as a row, the row count does not match. Eight symptoms, each with the cause and the fix.