How to Open CSV Files
All downloadable reports and data within PracticeHub will be in a .CSV file type. A .CSV file is a file that lists data as plain text and separates the values with commas (CSV stands for comma separated value). These reports or data can only be easily readable if opened in a spreadsheet programme such as Microsoft Excel, Apple iWork Numbers, Libre Office Calc, Google Sheets or something similar.
There are two methods for opening these file; automatically using your spreadsheet processors import wizard, or manually pulling the data into a blank spreadsheet. Your spreadsheet processor will hopefully automatically open the import wizard, however if not, you will need to add the data to a sheet manually.
The spreadsheet programme you use will most likely prompt you upon initially opening the file how you wish to separate the values in the file. You will need to ensure "separated by" is selected and then make sure to select "comma" as the separator. Make sure that no other separator is selected as multiple separators can be used.
In the above screenshot you will see a sample of data appear at the bottom of the window which will help you better see how the data will appear. You can then click OK through any next steps. Upon clicking OK, the data will then open up in your spreadsheet.
Please note: The text import window may differ in appearance between spreadsheet processors.
Manually Importing Data
If you are not automatically prompted, you will need to manually import the file. The first step will be to open a blank spreadsheet. Select the "Data" Tab, followed by "From Text" (options may vary depending on the spreadsheet processor you are using). You'll then be prompted to import the file. Find the CSV file downloaded from PracticeHub and click "Get Data".
You'll then see the Text Import Wizard Appear. There are a few steps to work through... The first step is to select "Delimited", followed by "Next". The next step is to remove the delimiter of "Semi-colon" and adding the delimiter of "Comma" and then clicking "Next". The next step can be bypassed by clicking "Finish". Before finally placing the data on to the sheet, you'll need to specify which cell you wish to enter the start of the sheet in to. By default this will be the first cell. Simply click "Ok".
The moving image below will show the steps to take...