![]() A text box will appear where you can define the specific separator. VBA Code: Set wbCSV Workbooks.Open(fPath & fCSV) open a CSV file. Loading a CSV into PostgreSQL or MySQL requires 3 (not-so-easy) steps. Once closed, you would need to open the workbook and reassign the variable as you did before. But that only lasts until the macro completes. If the CSV file you want to import is on your Google Drive, click My Drive at the top of the Import file window. In the menu bar, click File and select Import. Custom - if you use an uncommon character as a separator, you need to specify it by selecting this option. Variable wbCSV ( Dim wbCSV As Workbook ) is the variable that references the workbook. Import CSV file in Google Sheets Open a new Google Sheets spreadsheet.Tab - best for files that use tabs to separate columns (TSV files).Detect automatically - Google Sheets will analyze the file and determine what the separator is (Usually the easiest option).It will replace all data within the range that the data from the CSV file will cover.įor our example, we will select Replace data at selected cell.įor the separator type, you can choose from the following options: Replace data at selected cell - the data from CSV file will be inserted to the active sheet starting from the selected cell. ![]() ![]()
0 Comments
Leave a Reply. |