Overview
It is possible to use many of the Geochemical Diagrams on this website to plot or map data that you provide. "Upload your own" is one of the choices given for DataSet Source. To use this option, you will need to place your geochemical data in a Comma Separated Value (.csv) file. For this to work, some attention to the format of the .csv file is required. This page explains what is necessary. Most people will prepare the .csv file using spreadsheet software using "Comma Separated Values" as the File Type when saving, so these instructions refer to spreadsheet formatting and actions.

Format Instructions

1. Data for each sample must be located on a single row of the spreadsheet.
2. All the data for any oxide (e.g. SiO2) or element (e.g. Ni) must be located in the same column.
3. The columns of data can be in any order, but the first row of the spreadsheet must contain the oxide or element name for it's column of data. Columns with other headers may be present, but will be ignored (except for the metadata columns with specific headers mentioned below). For example, FeOT will be ignored. Put the iron oxide data in FeO and or Fe2O3 columns.
4. Do not have any space characters in the cells that have oxide or element names.
5. Standard oxide names should be used (no subscripts or spaces).
6. Data for the 12 oxides SiO2, TiO2, Al2O3, Fe2O3, FeO, MnO, MgO, CaO, Na2O, K2O, P2O5, H2O+ should be given in weight percent (wt.% = grams per hundred grams of rock).
7. Element names must be identical to those in a periodic table of the elements, using upper and lower case as appropriate.
8. Data for the elements should be given in parts per million (ppm = grams per million grams of rock).
9. Data cells can be empty, but should not have space characters in them.
10. The geochemical diagram pages will use sample information in columns with the following first row key words: "Sample Id", "Rock Name", and "ColorValue". Data in these columns is treated as text and will be used, if available, for mouseover information ("Sample Id", "Rock Name"), or for the fill color of sample data points or connecting lines ("ColorValue" -- no space).
11. "ColorValue" may be any of the 140 Color Names used by browsers.
12. If the .csv file includes columns with the first line key words "Latitude" and "Longitude", the Sample Map page will be able to plot the data on a world map. Latitude and longitude values should be given as decimal values, using the standard convention of negative latitude for western hemisphere locations and negative longitude for southern hemisphere locations. Use the WGS84 reference frame for locations.
13. A sample .csv file is shown below with fictious values to help you in formatting. To download a sample .csv file click this link: Mauna Loa Data.

Sample File

Sample ID	ColorValue	Rock Name	Latitude	Longitude	SiO2	TiO2	Al2O3	Fe2O3	FeO	Cs	Ba	La	Ce	Nd	Sm
W-233	Blue	Troctolite	-60	-79	46.63	0.92	14.9	15.26		3.26	415	29.2	60	27.3	4.49
453137	Blue	troctolite	-64.23	-98.44	47.6	0.82	18.07	11.14		3.55	456	30.6	62.7	28.2	3.97
A-408z	HotPink	basalt	49	-131	48.16	0.8	18.81	0.27	9.33	2.12	309	21.6	45.3	22.2	6.16
KI 3323	Green	gabbro	16.123	141.456	50.43	2.73	15.36	5.21	11.46	0	220	12	13		6.4
#365_Q	#FF0000	syenite	-13	-111	50.4	1.87	11.73	3.02	17.41	2.9	370	30	46		5.3