Upload Files
Get your data into DATIRA by uploading files, pasting from clipboard, or using sample datasets.
Upload Methods
File Upload
Drag & drop or browse
Paste from Clipboard
Copy from Excel/Sheets
Sample Data
Pre-loaded datasets
Upload a File
Steps:
- 1Open your workspace and click "New Data Source" or the + button
- 2Select "Upload File" from the options
- 3Either drag and drop your file onto the upload area, or click to browse your computer
- 4DATIRA will automatically detect the file type and parse the data
- 5Review the data preview to ensure columns are detected correctly
- 6Give your data source a name (optional) and click "Import"
Supported File Formats
Comma-separated values. Most common format.
Microsoft Excel files. First sheet is imported.
Array of objects or nested structures.
Paste from Clipboard
Quickly import data by copying cells from Excel, Google Sheets, or any spreadsheet application.
- 1In your spreadsheet (Excel, Google Sheets, Numbers), select the cells you want to import, including headers
- 2Press Ctrl+C (Windows) or ⌘+C (Mac) to copy
- 3In DATIRA, click "New Data Source" → "Paste from Clipboard"
- 4Press Ctrl+V or ⌘+V in the paste area
- 5Review the preview and click "Import"
Make sure to include the header row when you copy cells — DATIRA uses the first row as column names.
Use Sample Data
Don't have data handy? Use our pre-loaded sample datasets to explore DATIRA's features.
Available sample datasets:
- Sales Data — Regional sales by product and time period
- Employee Directory — HR data with departments and salaries
- Survey Responses — Customer satisfaction survey data
Click "New Data Source" → "Sample Data" and select a dataset to get started.
Import Settings
When importing, you can configure these options:
First row as headers
When enabled (default), the first row becomes column names. Disable if your data doesn't have headers.
Delimiter (CSV only)
Auto-detected by default. You can manually set comma, semicolon, tab, or pipe delimiter.
Encoding
UTF-8 by default. For files with special characters not displaying correctly, try ISO-8859-1 or Windows-1252.
Sheet selection (Excel)
If your Excel file has multiple sheets, you can select which one to import.
After Upload
Once your data is imported, you can:
- Clean and transform the dataPro
- Create a report from the data
- Update the data source to refresh linked reports
Troubleshooting
- "File too large" error
- Free accounts have a 10 MB limit. Upgrade to Pro (100 MB) or Business (500 MB) for larger files, or split your data into smaller chunks.
- Columns not detected correctly
- Check the delimiter setting. If columns are merged, try a different delimiter (comma, semicolon, tab).
- Special characters showing as garbled text
- The file may use a different encoding. Try changing the encoding setting to ISO-8859-1 or Windows-1252.
- Dates not recognized
- Dates may import as text if they're in an unusual format. Use the Date Parsing transformation to convert them.