Uploading Your Data

Gradiance accepts CSV and Excel files with your experimental data. This guide explains how to format your data for optimal results.

Supported File Formats

• CSV (.csv) - Comma-separated values
• Excel (.xlsx) - Microsoft Excel spreadsheets

Data Structure Requirements

Basic Format

Your file should contain at least two columns:

1. Concentration/Dose column: The independent variable (X-axis)
2. Response column: The measured response (Y-axis)

Concentration_uM,Viability_Percent
0.001,98.5
0.01,97.2
0.1,89.3
1,56.7
10,15.2
100,3.8

Multiple Replicates

For replicate measurements, you can structure your data in two ways:

Option 1: Long Format (Recommended)

Each row is a single measurement:

Concentration,Response,Replicate
1,45.2,1
1,47.1,2
1,46.8,3
10,12.3,1
10,11.9,2
10,12.8,3

Option 2: Wide Format

Each replicate in a separate column:

Concentration,Rep1,Rep2,Rep3
1,45.2,47.1,46.8
10,12.3,11.9,12.8

Data Preparation Guidelines

Concentrations

• Use actual values, not log-transformed. Gradiance will apply log transformation automatically for dose-response analysis.
• Include units in the column header (e.g., "Concentration_uM") to help the AI understand your data.
• Use numeric values only. Remove any text or special characters.

Response Values

• Use numeric values. Remove units from the data cells.
• For percentage data, use actual percentages (0-100), not decimals (0-1).
• Missing values can be left blank or use "NA" (will be excluded from analysis).

Column Headers

• Use descriptive names that clearly indicate what the column contains
• Avoid special characters except underscore (_) and hyphen (-)
• Keep headers in the first row

Common Data Issues

Non-numeric Values

Problem: Response column contains text like "OVER" or "<LOD"

Solution: Replace with numeric values or leave blank. The AI will skip non-numeric entries.

Incorrect Decimal Separator

Problem: Using comma as decimal separator (e.g., "3,14" instead of "3.14")

Solution: Use period (.) as decimal separator for CSV files. Excel files will use your system's regional settings.

Log-Transformed Concentrations

Problem: Concentrations are already log10-transformed

Solution: Convert back to actual values, or tell the AI: "My concentrations are already log-transformed"

Excel-Specific Considerations

Multiple Sheets

If your Excel file contains multiple sheets, Gradiance will ask you which sheet to use. Alternatively, you can specify: "Use the 'Results' sheet"

Formatting

• Remove merged cells - they can interfere with data reading
• Clear unnecessary formatting (colors, borders) - only data matters
• Avoid formulas in data cells - export calculated values as numbers

Best Practices Summary

Example Files

Need a template? Here are some example data files you can use as a reference:

• IC₅₀ dose-response template (CSV)
• ELISA standard curve template (CSV)
• Multi-replicate format example (Excel)

Note: Download links coming soon!