Once you have purchased and downloaded your AggData, opening it and using it in Open Office Calc is a straightforward and simple process. Open Office Calc is shareware, and is easy to find and download for use with CSV files, such as AggData.
First open the Calc program, in order to import AggData into a spreadsheet.
Click on “File”, and double click on “Open.” Now find the location of the AggData file on your computer. Usually, unless you have specified a different location, it will be in your Downloads folder.
Locate the AggData document you would like to access, then click to highlight the desired file. Finally, click “OK.”
The “Text Import” window will open. Make sure that “Comma” is checked on “Separator Options”. Check the fields section to see if the data looks formatted correctly, then click “OK.”
In order to make the spreadsheet easy to read, you can double click the right edge of each column to open the column to its full width. This process will also narrow the columns that may be too wide. In this way you are better able to see all the contents within each column.
Adding AggData Sheets to Other Open Office Calc Worksheets
Once in a while, you may have a document to which you would like to add AggData. When this is the case, first open the original document, then use the following steps to add the sheet of AggData to your existing document.
Click on the “Insert” tab at the top of the Open Office Calc worksheet.
Once the “Insert” tab is open, locate and click on the “Sheet From File” option.
Highlight the AggData you would like to use, and then click “Open.”
A couple of windows will pop up. The one on top will be the “Text Import” window. Check “Comma” and then click “Open.”
When the “Text Import” page closes, you will be able to access the “Insert Sheet” window. Decide the location you would prefer for the AggData to be placed. Click on the appropriate choice, then click “OK.”
Now you have successfully opened and placed the AggData into your existing file.