You can import any CSV file into a data grid. This is useful for importing data, such as a country or state list.
To import a CSV file, either click the Import icon or drag a CSV file into the data grid area. When you drag the file into the data grid area, a blue box will appear with a dashed outline. Release the file into that area, and the CSV import will begin.
Note that when you import a file, all data in that data grid will be replaced with the CSV you import.
Below are some sample CSV files for some common data grid uses.
Business
| File | Description |
|---|---|
| industry.csv | A list containing industry names. |
| industry_sic.csv | A list of condensed SIC industry codes and industry names. |
Color
| File | Description |
|---|---|
| color_srgb.csv | A list containing sRGB color names including HEX and RGB formats. |
| color_web_safe.csv | A list of all 216 Web Safe colors in both HEX and RGB formats. |
| color_x11.csv | A list containing X11 color names including HEX and RGB formats. |
Date / Time
| File | Description |
|---|---|
| day.csv | A list containing the days of the week. |
| month.csv | A list of months including the name as well as its abbreviation. |
| time.csv | A list containing times in 15 minute intervals. |
| year.csv | A list of years starting with 2020 and ending with 1920. |
E-Commerce
| File | Description |
|---|---|
| size.csv | A list containing a range of sizes from extra small to extra large. |
Geographic
| File | Description |
|---|---|
| continent.csv | A list of continents. |
| county_uk.csv | A list of UK counties with corresponding countries. |
| country.csv | A two-column CSV file containing country names and two character codes. |
| country_full.csv | A multi-column CSV file containing country names, codes, and regions. |
| province_ca.csv | A list of Canadian provinces including the full province name as well as its two-letter abbreviation. |
| state_au.csv | A list of Australian states including the full state name as well as its abbreviation. |
| state_us.csv | A list of US states including the full state name as well as its two-letter abbreviation. |
Personal
| File | Description |
|---|---|
| age.csv | A list containing suggest age brackets from under 18 to 65 or above. |
| education.csv | A list containing different levels of education from high school to degree. |
| employment_status.csv | A list of employment statuses from student to full-time employee. |
| job_status.csv | A list of different job statuses from seasonal to full-time. |
| marital_status.csv | A list of different marital statuses. |
Survey
| File | Description |
|---|---|
| agreement.csv | A list containing levels of agreement, from strongly disagree to strongly agree. |
| comparison.csv | A list of comparisons from much worse to much better. |
| duration.csv | A list containing a range of durations from less than a month to over three years and never. |
| frequency.csv | A list containing frequencies from less than once a month to daily. |
| importance.csv | A list containing levels of importance, from not at all important to very important. |
| probability.csv | A list of probabilities from definitely not to definitely. |
| satisfaction.csv | A list of different satisfaction levels from very unsatisfied to very satisfied. |