csv

I think this is a tricky one. I have a sheet where I paste different amounts of rows every time I use the sheet. I want the cells below C2 to show "TEXT" only if the cells below B2 contains value as I show on the image. If I paste 6 rows below B2, I want 6 rows below C2 to show "TEXT" in every...

Dear Experts I have a complicated issue for which I need your help. Attached is the csv file 01012020.csv Problem I need to import these csv files for each day of 2020 into an excel sheet and create an excel file filtered for each dept. So for example I have imported csv files from 01012020 to...

Hello, I have a .csv with more than 255 columns (395 exactly), I only need 3 columns but I cannot manipulate the source file manually, that is, I cannot divide it in two. The columns are: 131, 208 and 282 I have tried to do it by wizard but Access won't let me do it because it has more than...

Hola, tengo un .csv con más de 255 columnas (395 exactamente), únicamente necesito 3 columnas pero no puedo manipular el archivo de origen manualmente, es decir, no puedo dividirlo en dos. Las columnas son: 131, 208 y 282 He intentado hacerlo por el asistente pero Access no me permite hacerlo...

I have example data that is structured as the below with aggregated values on the end in one cell. I'm hoping to split this out into each record if it is split with a comma, space or pipe. The intended output of it would be to use vba to show it the column with the separated values and then have...

I want to Insert Data from a column (B2:B45) from csv file,directly via Dialog box (( to choose csv file )) , which opening from the standard excel file ( xlsm ) the CSV file called : StudentClass.CSV I've tried this : Private Sub importv_Click() Dim fd As Office.FileDialog Set fd...

I am struggling to add further functionality to my code. I would like for my code to run a loop through a range of dates, found in column "E:E", and thereby use this input into cell C2 and then perform the rest of my code - saving the file to CSV (SaveAsCSV()). The spreadsheet is such that it...

Hello, Does anyone know how I could create a button in my workbook to export certain cells into a new CSV file? For example, here is some data: Cell A1: John Cell A2: Doe Cell A3: Irrelevant Cell A4: Irrelevant Cell A5: Manager Name Cell A6: Job Title I would like to be able to pull cells...

I am seeing really, really strange behavior right now. Would appreciate any and all thoughts. I created an excel file with 2500 columns and 100,000 rows and saved it as a csv to practice loading large csv files into Python using Pandas. I was able to load the 100,000 row file with pandas...

I have a file produced by a proprietary third party application that is effectively a CSV with one specific exception: the first 3 rows do not follow a tradtional CSV format. I can open the file in Excel, and the file represents itself correctly. If I open, hit save (changing nothing) and then...

Good day, I have the below REALLY simple code to save a sheet in a workbook as CSV for upload to a database, however I keep getting the Run-time error "1004" Method "SaveAs" when I try and execute it. I can't figure out what I have got wrong - any advise? Thanks Sub SaveCSV()...

Hi guys, I would like to ask for a help related to saving the CSV file in the UTF 8 encoding with comma delimiter as so far I was not able to achieve this. I have tried to traditionally save the the excel sheet as CSV UTF-8, however when opening the file in Notepad++, I can see that the...

OK...I have some code that imports a csv into a sheet, but I don't want ALL of the data... I need to be able to skip certain "fields" in the line string from the CSV. How can I accomplish that with the below? Sub ImportCSV(customerfilename, unitnam, targetSheet) Dim rw As String With...

Hi! I really need your help. I got one file named - "TargetScan Data.csv" (source file). File contains 10 (static) columns and dynamic rows. Each day one row is added. File is on D:\OneDrive\TargetScan and What I want: I want to be able to import last row to my "File.xlsm' file (destination...

There is a CSV data source online that publishes the latest data on COVID-19 cases in Austria. COVID-19: Überblick - data.gv.at The CSV file consists of one row with the latest number (cases, recovered, hospitalized, deaths, etc). I connected the data to an Excel file as a data connection...

Hi all, I hope everyone is keeping well during these difficult times! I have an Excel Power Query question and I hope someone is able to help me! I created several connections in Power Query which are currently 'connections only' within Queries & Connections. All data is being imported from...

Hi all, I'm looking to have a button in a userform. Once pressed, allow the user to select a CSV file and open it. The code then needs to take an average of a specified range, for example B2:B14 and report the result in a textbox in the userform. The CSV can then close. Note, the file...

Hello guys, I'm new at the forum and i'm looking for some help solving my problem. I have a lot of different .csv files with data - 1 file per day named with the date, for example: 2020_03_23_data.csv. What I need to do is something like: give the input of the day, month and year I want to...

Hi, I have a folder of CSV files downloaded from yahoo finance and I have written code to get data from each of them. It took a long time and is a lengthy process if I want to add another 5-10 files. The code is below. The first block is some preliminary set up then the 2nd, 3rd and 4th are...

Hi All I have a macro in which I have to change the folder adress everytime I want to convert CSV to XLSX. how do I make it read the folder that I copy the excel file in it ? and how do I convert the tabulation of those CSV file that have semicolon ; to xlsx with separate columns ? this is my...