Once you have purchased and downloaded your AggData, opening it and using it in Libre Calc is a straightforward and simple process. Libre Calc is shareware, and is easy to find and download for use with CSV files, such as AggData.
Open Calc in order to import AggData into the program.
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 Libre 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 to which you would like to add the AggData , 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 Libre 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 window 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.