Import Data
Learn how to import your data into UCharts from various sources. Whether you have CSV files, Excel spreadsheets, Google Sheets, or want to enter data manually, we've got you covered.
10 min readBeginner friendly
Quick Start
The fastest way to get started is to copy and paste data from your existing spreadsheets:
- 1. Select your data in Excel or Google Sheets
- 2. Copy it (Ctrl+C or Cmd+C)
- 3. Paste into the UCharts data grid (Ctrl+V or Cmd+V)
- 4. Your chart will update automatically
Import Methods
CSV Files
Import data from CSV files exported from Excel, Google Sheets, or other spreadsheet applications.
Step-by-Step Instructions
- 1Prepare your data in a spreadsheet application
- 2Export or save as CSV format
- 3Click the "Import CSV" button in the data panel
- 4Select your CSV file from the file picker
- 5Review the imported data in the preview grid
- 6Make any necessary adjustments to column headers or data types
Pro Tips
- Ensure your CSV has headers in the first row
- Use commas as delimiters for best compatibility
- Avoid special characters in column names
- Keep data clean and consistent
Data Format Examples
Here are some common data formats that work well with UCharts. Use these as templates for your own data.
Time Series Data
Perfect for line charts and area charts showing trends over time.
Date,Revenue,Expenses 2024-01,50000,30000 2024-02,55000,32000 2024-03,60000,35000
Categorical Data
Ideal for bar charts, pie charts, and column charts.
Category,Value Product A,150 Product B,200 Product C,180 Product D,220
Comparison Data
Great for grouped bar charts and stacked charts.
Region,Q1,Q2,Q3,Q4 North,120,140,160,180 South,100,120,140,160 East,80,100,120,140 West,90,110,130,150
Best Practices
Do's
- • Use clear, descriptive column headers
- • Keep data consistent within columns
- • Include units in column names when relevant
- • Use appropriate data types (numbers, dates, text)
- • Clean your data before importing
- • Test with a small sample first
Don'ts
- • Don't use merged cells in your data
- • Avoid special characters in column names
- • Don't mix data types in the same column
- • Avoid empty rows in the middle of data
- • Don't use inconsistent date formats
- • Avoid very large datasets (>10,000 rows)
Troubleshooting
Data not importing correctly? Make sure your CSV file uses commas as delimiters and has consistent formatting. Try opening the file in a text editor to check the format.
Chart not updating? Ensure your data has headers in the first row and that all columns contain the expected data types. Check for any empty cells or formatting issues.
Large file import issues? For files larger than 1MB, consider breaking them into smaller chunks or using the CSV export option from your spreadsheet application.