Software FAQs
How do I import a CSV file into Excel that was exported with symbols from PHAWorks RA Edition and PHAWorks Lite?
If you had inserted symbols as data entry in the file, to open the exported data in Microsoft® Excel® please follow the steps below. Please note these instructions are using latest version of Excel 365 as of May 4, 2021 so your steps may differ.
- Run Excel
- Create a new file
- Click on "Data"
- Click on "From Text/CSV"
- Select the CSV file and click "Import"
- Click "Transform Data" button
- Click "Close & Load" button in the ribbon
If you are not inserting symbols as data entry in the file, it should be OK to open the file directly into Excel.
Related Topics
- How do I import a CSV file into Excel that was exported with symbols from PHAWorks RA Edition and PHAWorks Lite?
- How do I show Nodes as a column in reports in PHAWorks RA Edition and PHAWorks Lite?
- How do I backup my files in PHAWorks RA Edition and PHAWorks Lite?
- What is the difference in using an asterisk or colon in PHAWorks RA Edition and PHAWorks Lite?
- How do I select worksheet entries in PHAWorks RA Edition and PHAWorks Lite?
- Can I import data from other programs into PHAWorks RA Edition and PHAWorks Lite?
- What file types can PHAWorks RA Edition and PHAWorks Lite open?
- How do I number items within PHAWorks RA Edition and PHAWorks Lite?
- How do I configure how drop-down lists in PHAWorks RA Edition and PHAWorks Lite?
- Where are my settings saved - in the project or on the computer in PHAWorks RA Edition and PHAWorks Lite?
- Can I copy data from other software into PHAWorks RA Edition and PHAWorks Lite?
- What is the difference between basic and advanced search in Find / Replace in PHAWorks RA Edition and PHAWorks Lite?
- Can I generate multiple reports at once in PHAWorks RA Edition and PHAWorks Lite?
- Can I zoom the display in PHAWorks RA Edition and PHAWorks Lite?
- Can I change the language used in the software in PHAWorks RA Edition and PHAWorks Lite?
- Is Dark mode an option in PHAWorks RA Edition and PHAWorks Lite?
- What is the file compatibility between PHAWorks RA Edition and PHAWorks Lite?
