Chronicall/ACR's CSV reports are created as tab-delimited and Microsoft Excel automatically tries to open them as comma-delimited. What can I do to open them properly?
Answer
When opening the CSV file select "Delimited" and then "Tab" with column headers
Steps
- Open Microsoft Excel
- Click on the "File" tab in the top menu and select the "Open" option
- Click the "Browse" option to bring up the Open or Browse window
- Next to the "File Name" field, click on the "File Type" drop-down menu and select the "Text Files" option
- Navigate to the location of the text file, select it, and click the "Open" button
- In the Text Import Wizard, the Delimited option should already be selected (shown below)
- Also, make sure that the "My data has headers" box is checked
- Also, make sure that the "My data has headers" box is checked
- Click the "Next" button to go to Step 2 of the wizard
- Make sure the "Tab" option is checked and validate the data is separated correctly in the "Data preview" section
- Click the "Finish" button.
- The text file data will be converted into spreadsheet format. Again, click on the "File" tab in the top Ribbon menu and select the "Save As" option.
- In the Save As window, select the CSV (Comma delimited) (*.csv) option in the "Save as type" drop-down menu.
- Type in a name for the CSV file in the "File name" field, navigate to where you want to save the file, then click the "Save" button.
Note: Screenshots and steps taken from ComputerHope.com