Get data into Mammoth: choose how to bring data in
Mammoth has seven ways to create a dataset: upload a file, paste from a spreadsheet, import from a URL, connect a database or app, receive data by webhook, generate data with AI, or load a built-in sample. Every method starts in the Data Library: click New dataset and pick a method in Where do you want to add data from?. To compare them side by side, see When to upload, and when to use something else.
Upload a file
- Upload files: CSV, Excel, JSON, XML and archives from your computer.
- Upload many files: several files or a whole folder at once.
- Prepare files: pick a format and avoid read errors.
- Fix file reading: reshape a messy or nested file.
- Excel sheets: import some sheets of a workbook.
Paste or link a file
- Paste data: copy cells from Excel or Google Sheets.
- Import from a URL: create a dataset from a file at a link.
- Linked URL datasets: fetch the latest file from its link.
PDFs
- Extract from PDFs: pull tables out of a PDF or an image.
- PDF instructions: say exactly what to take.
- PDF limits and keys: monthly pages and your own AI key.
- Repeat a PDF read: read next month's PDF the same way.
- PDF tool downloads: tables from the free PDF-to-CSV tool.
Connect a database or app
- Connectors: every source Mammoth connects to.
- Connect a source: connect a database, warehouse, app or drive.
- Find a connector: search the launcher or reopen a draft.
- Connector workspace: pick tables and columns.
- Query a database: write SQL against a database.
- Database refresh options: what each refresh does.
- Connections: see saved connections.
- Edit a connection: edit, repair or delete one.
- Network requirements: let Mammoth through your firewall.
Push or generate data
- Webhooks: let another system push rows in.
- Webhook security: require a secret and check deliveries.
- Generate test data: describe a dataset and let AI build it.
- Sample datasets: load a built-in sample.
Add to an existing dataset
- Add or replace data: add rows, or replace the data.
- Add from a dataset: add another dataset's rows.
- Column mapping rules: set how new columns are matched.
- Batches: see, suspend or delete what arrived.
- Fix a pending batch: a batch that says Pending.
- Batch columns: filter data by batch.
- Batch retention: delete or suspend old batches on a rule.
After you create a dataset, explore it, build a pipeline, download or share it, automate the refresh for connector and From URL datasets, and manage its Views.
Was this page helpful?
Something wrong? support@mammoth.io