📊 Curso Google Sheets ✅ Importar y exportar CSV

How to Import and Export CCU Files in Google Sheets

Introduction to Importing CCU Files

• The video tutorial focuses on importing and exporting data from CCU files using Google Sheets, starting with the creation of a blank spreadsheet.

• To import data directly from a CCU file, it must first be saved in Google Drive. The user navigates through their Drive to locate the desired CCU file.

Steps for Importing Data

• After selecting the CCU file, a window appears where users can specify how they want to import the data (e.g., into a new sheet or replacing existing data).

• Users can choose the separator type for the CCU file; automatic detection is recommended unless specific characters are needed.

• The option exists to convert imported data into numbers, dates, or formulas; typically left as default unless plain text is required.

Importing Additional Data

• The process is repeated for importing another set of data (capitals corresponding to countries), specifying that it should replace data starting from a selected cell.

• This allows multiple sets of imported CCU files within one sheet, enhancing organization and accessibility of related datasets.

Utilizing Imported Data

• The imported country and population data will be used in subsequent videos for search functions within Google Sheets.

Using IMPORTHTML Function

• A new sheet is created to demonstrate how to use the IMPORTHTML function for fetching web-based data.

• Users need to copy the URL of the webpage containing relevant information and format it correctly within Google Sheets.

Parameters for IMPORTHTML Function

• The second parameter specifies whether the desired information is in a list or table format; "table" is used here since it's applicable.

• An index number indicates which table or list should be imported if there are multiple options available on the page.

Handling Imported Data Issues

• If users attempt to delete cells containing dynamic formulas like those from IMPORTHTML, they may find that values reappear due to ongoing updates from linked sources.

Finalizing Data Presentation

• To create a static dataset without formulas, users can copy values only using "Paste Special" options. This allows editing without interference from original formulas.

Saving as CCU File

Data Downloading and File Structure

Understanding Data Separation and Downloading Process

• The data is separated by tabs or spaces, emphasizing the importance of knowing that only the current sheet's data will be downloaded when using CCU. In this instance, only data from Sheet 2 will be retrieved.

• It is clarified that no data from other sheets (e.g., a list of countries by population) will be included in the download. Users can initiate the download by clicking on CCU, which saves the file to their device.

• After downloading, users can right-click to open the file with applications like Notepad to inspect its structure. The file contains country and population data separated by commas, with some blank spaces indicating rows without data.