csv export csv import

  1. D

    Import from CSV and create individual sheets based on field

    Hi Folks I have a large CSV, where each row/entry has a date in it, in the format dd-MM-yyyy. I would like to import it, but create a new sheet per date, and preferably (although not a requirement) order the sheets chronologically. The date is 7th of 14 columns and there are multiple entries...
  2. N

    Multi-Part Excel product

    So I'm trying to build an excel spreadsheet that I can distribute to other schools that will allow for the following functions, Essentially, they will use the first tab to add rows and create their schedule, which then will generate a CSV sheet on tab 3 that they can import into excel or Gmail...
  3. F

    Substitution script with CSV input&output

    Hello dear Excel users! I got hung up on my lacking knowledge regarding Excel. My aim is to get a CSV input, which has several coloums, but only 2 is of interest: one which determines the type of data and a number value, which is to be copied unchanged. The output would have a completely...
  4. S

    Exporting Excel file to CSV format with Quotes, dots & question marks.

    Hi, I’m trying to create a .CSV file separated by semicolon instead of a comma, like this exemplary file here, but some of the rows contain special characters and all the data must be wrapped by double quotes. I have changed the list separator under the Region in my windows control panel to be...
  5. B

    Importing multiple data files

    Hi all, I've got 170 csv files that I'm looking to compile into excel so as to analyse them, but am hoping to avoid having to do that one by one, adding each as a seperate tab. Does anyone have any ideas of how I could do this, e.g. a macro or script, or if there's an "add all as tabs" add-in...
  6. H

    AutoSave Excel in Different format

    Hi, This is my first post to this forum, although I am working on a potential project for my University and was curious if what I need to do is going to be possible. 1] Have Excel document save every second. * Found some people discussing this with code so I know that this is...
  7. O

    Help saving and importing CSV in VBA... with accuracy!

    Hi All. For my businesses CMS - I need for several excel workbooks to communicate with each other. I'm trying to save a sheet as a csv... then import it into another workbook. The problem I'm encountering is that no matter whether I comma or tab delimit, when I try to import the sheet, excel...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top