CSV Files in Excel

Working with CSV files in Microsoft Excel

When using Microsoft® Excel® to handle CSV files for use with AquaCUE, do not simply open the file by double-clicking it. Instead, use the Data>From Text function (Windows) or the File>Import function (Mac OS) to bring the CSV file into Excel. This helps preserve the fidelity of your data.

When using this method, an Import Wizard lets you choose a delimiter and determine how to treat data such as numbers and dates in your file. Setting all data to Text prevents large numbers from being displayed as floating point values, leading and trailing zeros from being dropped and dates from being displayed in non-ISO-compliant formats.

For Windows users:

Follow these steps to import CSV files into Excel:

  1. Select File>New to create a new file.

    import

  2. Select Data>From Text.

    from-text

  3. Locate and select the file you want to import using your computer’s file system.
  4. In the Text Import Wizard popup menu, click the CSV radio button, set File Origin to Unicode (UTF-8) and click Next.

    import-8

  5. Set the Delimiter and click Next.

    import-4

  6. Shift-click all of the columns to select them and click the Text radio button to set the Data Format of the file and click Finish.

    import-9

  7. Set where you want to put the data with the appropriate radio button and click OK.

    import-6

When the import process is complete, dates will be properly formatted, any numbers that contain leading or trailing zeros will be preserved and long numbers will not turn into floating point values.

For Mac OS users:

Follow these steps to import CSV files into Excel:

  1. Select File>New Workbook to create a new file.
  2. Select File>Import.

    excel-file-import

  3. In the Import popup menu, select the CSV file radio button and click Import.

    csv-radio-button

  4. Locate the file you want to import using your computer’s file system and click Get Data.
  5. In the Text Import Wizard, make sure the Delimited radio button is selected and set File Origin to Unicode (UTF-8).

    screen-shot-2017-02-08-at-10-07-30-am

  6. Click Next.
  7. Set the Delimiters and click Next.

    screen-shot-2017-02-08-at-10-07-45-am

  8. Shift-click all of the columns to select them and click the Text radio button to set the Data Format of the file and click Finish.

    screen-shot-2017-02-08-at-10-08-12-am

  9. Set where you want to put the data with the appropriate radio button and click OK.

    location

 
When the import process is complete, dates will be properly formatted, any numbers that contain leading or trailing zeros will be preserved and long numbers will not turn into floating point values.

KNOWLEDGE BASE



User Guide