- You need to import data quickly without setting up a full integration.
- You have CSV files from systems that don’t have direct integrations.
- You want to test data in Runway before committing to a full integration setup.
- You have one-time data imports that don’t require ongoing syncing.
File requirements
Before uploading your CSV file, ensure it meets these requirements:- File format: Only
.csvfiles are supported. - File size: Maximum file size is 50MB.
- Data structure: The first row should contain column headers.
- Data quality: Ensure at least one data row exists below the headers.
- Date format: Use MM/DD/YYYY format for date columns (e.g.,
01/15/2024).
Connecting the File Upload integration
- Open Runway and navigate to Integrations.
- Find and install the File Upload integration listed under the Data storage section.
- A new query called New File Upload will be automatically created.
- You can rename this query by clicking the three-dots button next to the query name in the sidebar and selecting Rename query.
Uploading a CSV file
Once you’ve connected the File Upload integration:- Click on your File Upload query in the sidebar.
- In the query editor, you’ll see a file upload interface.
- Click Choose File and select your CSV file (must be
.csvformat and under 50MB). - The file will upload automatically. You’ll see a confirmation message when the upload is complete.
- Click Run query to import the data into Runway.
Refreshing data
To update the data in your File Upload query:- Upload a new CSV file using the same steps above.
- Click Run query to refresh the data.
- The new data will replace the previous data in your linked database.
Each time you upload a new file and run the query, it completely replaces the previous data. Make sure your new file contains all the data you need.
Using uploaded data in databases
After running your File Upload query:- Configure a new database linked to your File Upload query.
- The database will display the data from your CSV file.
- You can now use this data in your models, pages, and formulas just like any other integration.
File upload FAQs
Can I schedule File Upload queries to sync automatically?
Can I schedule File Upload queries to sync automatically?
No. File Upload queries must be run manually. If you need automatic syncing, consider using Google Sheets or a data warehouse integration instead.
What happens if my CSV file is larger than 50MB?
What happens if my CSV file is larger than 50MB?
Files larger than 50MB cannot be uploaded. You’ll need to either:
- Split your file into smaller CSV files and create multiple File Upload queries.
- Aggregate your data before exporting to reduce the file size.
- Use a data warehouse integration for larger datasets.
Can I upload multiple CSV files to the same query?
Can I upload multiple CSV files to the same query?
No. Each File Upload query can only contain data from one CSV file at a time. When you upload a new file and run the query, it replaces the previous data. If you need to import multiple CSV files, create separate File Upload queries for each file.
What CSV formats are supported?
What CSV formats are supported?
Runway supports standard CSV files with:
- Comma-separated values (
,as delimiter) - Column headers in the first row
- At least one data row below the headers
- Date columns formatted as MM/DD/YYYY (e.g.,
01/15/2024)
Why isn't my uploaded file showing data?
Why isn't my uploaded file showing data?
If you don’t see data after uploading and running the query, check:
- Your CSV file has column headers in the first row.
- There is at least one data row below the headers.
- The file is properly formatted as a CSV (not Excel or other formats).
- You clicked Run query after uploading the file.
Can I edit the CSV data directly in Runway?
Can I edit the CSV data directly in Runway?
No. File Upload queries are read-only. To modify the data, you need to:
- Edit your CSV file outside of Runway.
- Upload the updated CSV file.
- Click Run query to refresh the data.