Preparing Excel files for data import

To import data from Microsoft Excel or similar spreadsheet tools into Cloudera Data Visualization, you must first save the data in a character-delimited format, typically CSV.

  1. Open your data file in Microsoft Excel.
  2. Click File > Save as.
  3. Select Comma Separated Values (.csv).
  4. Enter a file name, such as MyCSVdata and click Save.