Ir al contenido
Documentación

File Uploads

Esta página aún no está disponible en español. Se muestra la versión en inglés.

Upload files from your computer to put data into your Library without setting up a connector. Spreadsheet-like files become data you can ask about as soon as they arrive.

Ways to upload

Section titled “Ways to upload”
  • Drop files anywhere in the app. While you drag, the page dims and shows Drop files to upload, with “They’ll be added to this workspace”.
  • Add data. Click Connect in the app rail, then Browse… under Upload from your computer.
  • The Library’s + button. On the Files tab, click + and choose Upload files….
  • An empty workspace. Drop files on the drop zone, or click to browse your computer.

Uploading needs permission to add files to the workspace. Without it, Add data shows only connectors, and the drop target doesn’t appear.

Where your files go

Section titled “Where your files go”
  • In the Library, files go to the workspace you’re viewing, into the folder, collection or tag you’re browsing.
  • Anywhere else in the app (Home, Projects, Dashboards, the Inbox or Settings), files go to your organization’s default workspace.
  • If you can’t add to that workspace, the file is saved to your private workspace, and a message tells you.

Supported files

Section titled “Supported files”
FileWhat it becomes
CSV, TSVA source you can ask about, typed Dataset
Excel (XLS, XLSX)A source typed Dataset. A workbook lists its sheets; ask the Librarian to build a view from a sheet to work with it as a table
JSON, ParquetA source you can ask about
PDFs, images and documentsA file in the Library

Querri accepts other file types too, and keeps them as files. It refuses executable content with “File content type is not allowed”.

Limits

Section titled “Limits”
  • Size: up to 2 GB per file.
  • Storage: before sending, Querri checks the batch against your plan’s remaining storage, and blocks the upload if it won’t fit.

Tracking uploads

Section titled “Tracking uploads”

After your first upload in a session, an Uploads item appears in the app rail. It opens the Uploads panel:

  • Each row shows the file name, where it’s going (workspace and folder), and its progress, such as “Uploading · 12 MB of 40 MB”.
  • A row’s ⋯ menu has Cancel while uploading, Retry when it failed, and Remove.
  • Clear finished tidies the list.

The panel opens by itself shortly after you drop files, if something is still uploading or has failed. The list lasts for your browser session.

What happens when a file arrives

Section titled “What happens when a file arrives”
  1. Querri measures each new source: its columns, their data types, some example values, and a summary.
  2. It learns how the new table links to the tables you already have.
  3. Once new data has stopped arriving for a few minutes, Querri refreshes those links and may suggest views to build in your Inbox, for you to approve.

Uploading doesn’t build views on its own, and uploads don’t use credits.

To check a file came in right, open it from the Files tab. The Columns list shows how much of each column is filled (red below 90%), how many distinct values it has, and a small chart of how the values are spread.

Preparing your file

Section titled “Preparing your file”

A tidy file gives better answers. Before you upload:

  • Header row: the first row holds column names, not data.
  • One type per column: numbers are numbers, dates are dates. A total column shouldn’t mix 125.50 with pending or N/A.
  • One row, one record: no merged cells, no summary or subtotal rows mixed into the data.
  • No blank rows in the middle of the data.
  • One table per sheet. Split several tables into separate sheets or files.
  • Clear column names, such as order_total rather than Order Total ($).
  • UTF-8 text encoding for CSV and other text files, so special characters survive.
ProblemFix
Headers start in row 3Delete the rows above the headers
”N/A” or “null” in a number columnLeave those cells empty
Dates stored as textFormat the column as a date
Currency symbols in numbersRemove $ and , from the values
Several tables in one sheetSplit them into separate sheets or files
FormulasQuerri reads the saved values, so recalculate and save before uploading

Managing uploaded files

Section titled “Managing uploaded files”

Uploaded files are listed on the Library’s Files tab.

  • Rename, move or replace: click ⋯ at the end of a row, or right-click it, for Rename, Move to folder…, Replace file… and Download. A table’s detail panel also has a Versions & replace section.
  • Delete: Move to Trash deletes a file, with a chance to undo right away. Later, Trash in the browse panel lets you Restore it, or Delete permanently.

See Browsing the Library.

Common issues

Section titled “Common issues”

The upload was blocked for storage. The batch is bigger than your plan’s remaining storage. Remove files you don’t need, or upload fewer at once.

My file ended up in my private workspace. You weren’t able to add files to the workspace you were in. Ask a workspace admin for a Creator role, or upload from a workspace where you have one.

Retry doesn’t work. If the browser no longer has the file, Querri asks you to add it again. Drop or browse for the file once more.

The file was refused. Executable files can’t be uploaded.

The data looks wrong. Check the file against the checklist above, especially the header row and text encoding, then use Replace file… to upload a corrected version.

Next Steps

Section titled “Next Steps”