Importing files | ATX AnalyticsTable Docs

Importing filesExcel, CSV/TSV, JSON, NDJSON and Parquet imports, and the import history. Imports a sheet from an .xlsx file into a cached table and pins it into the grid. The binding remembers the file path and sheet, so Refresh re-reads the FILE (picking up edits made in Excel) rather than the frozen snapshot. The path may contain ${parameters}, so a dated filename loads the right day's file on every refresh, and the import can be scheduled.

Where to find it

Get Data → Data Sources → History

What this page covers

Get Data → Excel Imp
Get Data → Text/CSV
Get Data → JSON

Settings and controls documented

Read from
File path or glob
Storage connection
Object key
Key prefix
New sheet name
Start cell
Cache table
Column types
Treat as NULL
Date format
Time zone
Thousands separator
Keep only these columns
Remove duplicates
Row filter
Row limit
Skip rows
Delimiter
Write mode
Key columns
If the columns changed
Minimum rows
If a row cannot be read
Read many files as one table
Only files modified since
Save as connection (optional)
Excel file path
Range
Load into sheet
Cache table name
Skip first rows
Bad rows
Load into sheet named

Full page

The full page — procedures and the explanation of every setting — is available to signed-in users.

ATX Institute on LinkedIn

This site needs JavaScript for the full experience. Every page above is reachable without it.