Back to Blog

Atlas Weekly: W-26

Atlas TeamAtlas Team
Share this page
Atlas Weekly: W-26

A big week for connections and data management: Excel files on SharePoint can now be synced directly into Atlas, Snowflake gained OAuth support, and the datatable picked up column freezing. There were also meaningful improvements to interfaces, the field app, and workspace administration.

Features

Excel and SharePoint connection

Sharepoint and excel

Atlas can now connect to Excel and CSV files stored in OneDrive and SharePoint via Microsoft Graph. An in-app file picker lets you browse your drives, preview the data, detect geometry, and configure smart-sync merge settings — with full parity to the Google Sheets connection. Files sync on schedule just like any other connection.

Snowflake OAuth

Snowflake connections now support OAuth as an authentication method, alongside the existing password, private key, and programmatic access token options. OAuth is the recommended path when your Snowflake account enforces network policies that block programmatic access tokens.

Freeze columns in the datatable

Any column in the datatable can now be pinned to the left so it stays visible while scrolling horizontally. Right-click a column header and choose "Freeze column." The setting is saved per dataset.

XLSX multi-sheet import

When uploading a multi-tab .xlsx file, Atlas now lets you pick which sheets to import. Each selected sheet becomes its own dataset, matching the experience for Google Sheets and SharePoint imports. Single-sheet uploads and CSVs are unchanged.

Transfer projects when removing a workspace member

Removing a workspace member who owns projects no longer silently deletes those projects. Admins now see each owned project and can choose to transfer it to another member or explicitly delete it. The default is to transfer, so no data is lost accidentally.

Show/Hide all layers in a folder

Right-clicking a folder in the layer panel now shows "Show all layers" and "Hide all layers" options. This restores a fast bulk action for exploration workflows without changing how individual layer states are remembered.

"Copy link to feature" in interfaces now produces a URL that opens the correct interface, zooms to the feature, selects it, and opens its popup — all in one click. Previously the link only zoomed to the feature without selecting it.

Duplicate project forms

Forms can now be duplicated from the forms list via the context menu. The copy starts as a Draft with a unique name, ready to be edited independently from the original.

IP allowlist guidance for database connections

When connecting to Snowflake, Databricks, or other databases that restrict access by IP, Atlas now shows its four egress IP addresses with a copy button directly in the connection modal. Previously there was no in-app way to find these addresses, and network-policy errors surfaced as a generic "Connection test failed."

Raster datasets in the field app

Processed raster datasets now render correctly in the field app. Previously they failed silently and never appeared on the map.

Fixes and Improvements

  • External buttons open in a new tab — button widgets in interfaces that link to external URLs now open in a new browser tab instead of navigating away
  • Layer deselection after field app creation — layers can now be deselected in the layer panel immediately after creating a field app
  • Marker layers in interfaces — the interface data filter no longer gets incorrectly reapplied to marker layers after load
  • Column order on tabular import — the source column order from CSV and XLSX files is now preserved when importing
  • Map legend respects hidden folders — map exports no longer include legend entries for layers inside hidden parent folders
  • Datatable fills the full panel — the datatable now stretches to fill the entire bottom panel, removing the dead space that appeared below the grid
  • Paste widgets in interfaces — widgets paste correctly regardless of which input field is currently focused
  • Forms accept 0 and false — required fields in forms now correctly accept 0 and false as valid submitted values
  • Formula list literals — list literals used in formula columns now evaluate per row instead of being treated as a single broadcast value
  • Activity log zoom — zooming to edits from the activity log now fits all edited features, not only the first one
  • Workflow formula editor — the cursor no longer jumps to the end of the expression when typing a column name in a formula workflow node
  • Connection error messages — real backend error messages from failed connections are now shown in the connection modal instead of a generic fallback
  • Layer name tooltip — the overflow tooltip on long layer and folder names in the layer panel now appears immediately on hover
  • Social sign-in provisioning — new users signing in with Google, Apple, or Microsoft for the first time are now automatically provisioned with a workspace
  • Field app entry speed — opening a project in the field app is now near-instant when the project has been opened before; the sync continues in the background
  • UI consistency — typography scale, badge styles, button variants, alerts, and table styles have been standardised across the app