How To: Excel - Create Spreadsheet from Text file
1 - Select Data at top menu and Under the "Get External Data" category click "From Text". Then choose the text file that contains the data you want to import.
2 - Leave the option "Delimited". Review the data and take note of what is separating the data(what should be separated by columns) and click next.
3 - Choose the appropriate option under "Delimiters". If the data is separated by Tabs or Commas, choose one of those. In this case it is separated by a "Caret"(Shift+6). Notice I chose "Other" and typed the Caret symbol. Once I did that, the preview of the data shown at bottom auto changed showing the columns in place of the Caret symbols. Click next.
4 - Leave the format of "General". Click finish.
5 - This is why we selected the A1:1 cell at the beginning. It wants to know where to start placing the data. Click ok.
6 - Confirm the data looks good. There will not be "Headers" unless the text file contained them.
7 - Save the spreadsheet as a "CSV" file type, unless you know the program you are importing this data into takes a different file type. Then choose the appropriate file type to match what you need.
- Departments
- Nutrition Services
- Human Resources
- Technology
- Facilities
- Business Services
- Payroll
- Purchasing