← Support & documentation

Plotting SALSA spectra with Google Sheets

A quick guide to inspecting an exported SALSA spectrum in a Google Sheets spreadsheet. No software install required — just a Google account and a CSV downloaded from the observation archive.

  1. Download the data. Open the observation in the observation archive and click Save CSV. The file is named like SALSA-vale-20260507T201234.csv.

    For galactic targets the CSV also includes a velocity column (LSR-corrected, in m/s). If you toggled the chart axis to velocity before saving, the file is named with a _vlsr suffix and column A is velocity in km/s instead of frequency in Hz.

  2. Create a new Google spreadsheet. In the new sheet, open File → Settings (or File → Spreadsheet settings in the older menu). Set Locale to United States and click Save settings. This makes Sheets use a decimal point (.) rather than a decimal comma (,), which matches the SALSA CSV.
  3. Import the data. Choose File → Import → Upload and select the CSV you saved. In the import dialog set Separator type to Comma and Convert text to numbers, dates, and formulas to Yes. Click Import data.
  4. Skip the metadata header. The first several rows of the file start with # — these are comments describing the observation (telescope, date, target, integration time, VLSR correction). Sheets imports them as plain text in column A; they're harmless. The actual numeric data begins on the row whose column A reads frequency_hz (or vlsr_km_s) — the column-name row, immediately followed by the numbers.
  5. Select the data and insert a chart. Click the column-A letter to select the whole column, then Ctrl/Cmd-click the column-B letter so both columns are highlighted. Choose Insert → Chart. Sheets ignores the non-numeric header rows and plots the spectrum: column A on the x-axis (frequency in Hz, or velocity in km/s), column B on the y-axis (amplitude).
  6. Read values from the chart. Click anywhere outside the chart once, then click back on the chart to activate it. Hovering the pointer over a point now shows the x (frequency or velocity) and y (amplitude) values from your spectrum.

For richer analysis (baseline subtraction, Gaussian peak fitting), use the tools built into the observation archive page directly. This Google Sheets path is most useful for quick visual inspection or when you want the raw numbers in a spreadsheet for further processing.