csv

I have 59 csvs in the same folder that contain field names in column B. A1 contains just the filename. The csvs need to be set up in a certain way to facilitate data migration to a state database. I would like to transpose the data in column B as rows (for example, instead of field names in...

Every morning I need to open a csv file from a web based server, sort and filter the data, then copy the relevant data over to an Excel sheet. To make things even more interesting, only part of the file name stays the same. I prefer to not have to save the file as I am trying to make sure that...

Hello all, I have the following code, but when this exports to a separate csv file, it comes up with an error message "File format and extension of xxx don't match. The filecould be corrupted or unsafe." Is there a way to stop this error message coming up, without going in and resaving it as...

Hello! I am trying to have a column of numbers include leading zeros so they all contain six digits. Scenario 1. I want all numbers in the first column to have six digits (if they already have 5 digits, add 1 leading zero, 4 digits = 2 leading zeroes, and so on). 2. When I follow a website I...

Hello, I am trying to come up with a macro that imports multiple csv files to different sheets and using the name of the file as the sheet name. I also need to be able to select the delimiter and also Consecutive delimiters. I have found 2 variants, one that imports multiple files but does not...

I'm not sure how to word it, but here goes... I have two spreadsheets (1 old & 1 new) I need to compare specific criteria. I need to search the old CSV of parts and compare to the new CSV of parts and tell me if we have old parts that match the dimensions of the new parts. The CSV headers in...

Currently exporting date into Excel in this format: Jun 22, 2019, 09:38 AM Update: the dates appear in each cell within the column (1 date per cell in a column needs to be converted into another column of short dates) Want to convert to: 22/06/2019 Have tried long way of Text to Columns and...

I borrowed some code that was in a worksheet that the people that came before me created... I have adapted it to work for me in another situation but I am wanting to modify it. Basically I have a data collection machine that creates csv files with information. I am wanting to extract...

Hello, I am wondering if anyone can help. I am looking to do a data import from an excel csv. I want to use this for a table seating plan. On the plan, there will be upto 50 tables. Each table will have a title (table 1, table 2, table 3 etc). Under each table there will be upto 15 guests...

What I have: A bunch of CSV files with data. Say 300k rows each one. CSV files: if opened directly, they're in the wrong encoding and characters don't show up as they should. There's no option to select which encoding to use or which should be the default for all files? What also doesn't...

Hi, I have a CSV and have formatted the date as DD/MM/YYYY but when I save the file and come to reopen, the formatting has gone, any idea why please?

Good Morning All, I have searched Google long and hard for an answer to this question to no avail!! I need to copy a CSV file from a specific directory, and make it available to the clipbaord, so I can paste it later using ctrl + v. I have developed a Macro that manipulates an XLSM file then...

I have an file in csv format that has a field with page ranges in it such "3-4" or "6-10". When you open this into Excel, it converts it to a date. Once converted, I can't get it back to text. Any workaround?

I am trying to determine the number of rows of data in a Pivot field. My code looks like this: Sub LookupCommon() 'A sub to populate the CSV file with common data Set WS1 = Sheets("5. Final CSV") Set WS2 = Sheets("4. PivotTable") Set MyPivot = WS2.PivotTables(1) Counter =...

Hi guys, I have a CSV exporter which converts a PDF into excel where the PDF file has customer details like Name, Guardian name, House no, Gender etc., Now the problem is whenever i use the CSV exporter the zero in house no removes automatically For example: Actual data of House no in PDF...

Hi guys, Hopefully you can help me out, i want to import an CSV file into an table. Normally i setup a connection and i use that connection to import the csv file. But more people are using this excel file and a person is using office 365 and the connection is not working in the new excel...

Hi, I have poorly designed a VBA macro that opens/exports .csv data to an excel... works fine but when I export - say 10 csv, I'm left with 10 csv opened... I am trying to extend the coding so that the VBA macro also closes the csv files - thank you Sub Macro1() ' ' Macro1 Macro ' ' Set...

Hello, I have a problem when I am copying a csv text from a .txt file into Column A - on some rows the data is split between col A and C. I don't want to use the import csv. function because this is part of an RPA process and I want to keep it as simple as possible. Basically, what I am doing...

Hello, We have a number of CSV files which are created daily by our modelling software. I would like to import the most recent csv data into their respective excel sheets. Each csv file is saved in a single folder generated by the model. An example of the saved csv file are saved like this...

First, I should point out I'm using Excel for Mac. So I've gone to File, Import, CSV file, selected the file and it has imported successfully on my spreadsheet. I've also got a Macro set up so every few seconds it checks for updates and refreshes the imported data. I'm trying to make it so if...