University of Minnesota Extension
www.extension.umn.edu
612-624-1222
Menu Menu

Extension > Plant Selection: Plant Elements of Design > How to: Text-to-Columns - Converting a comma delimited file (.csv) to columns

Tuesday, January 5, 2016

How to: Text-to-Columns - Converting a comma delimited file (.csv) to columns

A .csv file exported from the Plant Elements of Design.
Commas separate the plant data information.
Plant Elements of Design exports plant lists as comma delimited files (.csv). This file format accommodates various spreadsheet programs. This is important as we have users literally from all over the world on different platforms. Using the .csv file format provides flexibility.

 If you are using Microsoft Excel on your computer and want your exported plant data to organize in
The file after "Text-to-Columns" was applied.
columns, follow these steps:
  1. Save your .csv file. 
  2.  Highlight the first column on your .csv file. 
  3. Click on DATA on the toolbar.
  4. Click on "Text to Columns”. 
  5.  Click on “Delimited” and “Next”.
  6.  Click on “Comma” and “Next”.
  7. Click on “General” and “Finish” 
Be sure to save your converted file!

No comments:

Post a Comment

  • Copyright 2015 Regents of the University of Minnesota. All rights reserved.
  • The University of Minnesota is an equal opportunity educator and employer. Privacy