How to Use AggData with Open Office Calc

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.   

Step One: 

First open the Calc program, in order to import AggData into a spreadsheet.

Step Two:

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. 

Step Three:

Locate the AggData document you would like to access, then click to highlight the desired file.  Finally, click “OK.”

Step Four:

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.”

Step Five:

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.

STEP ONE:

Click on the “Insert” tab at the top of the Open Office Calc worksheet.  

Step Two:

Once the “Insert” tab is open, locate and click on the “Sheet From File” option.

   

Step Three:

Highlight the AggData you would like to use, and then click “Open.”

Step Four:

A couple of windows will pop up.  The one on top will be the “Text Import” window.  Check “Comma” and then click “Open.”

Step Five:

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.