csv files

  1. R

    Line break causing issues combining .csv file with comma delimiter

    Hey All, Ran into a problem this week and I'm curious if anyone knows why it occurs, plus if there's a simpler way to fix it than what I had in mind. I work in marketing and use excel power query and power pivots to summarise our data (they're amazing for this). I'll frequently use power...
    • Rosie_222
    • Thread
    • #excel powerquery combinefiles csv files getandtransform
    • Replies: 1
    • Forum: Power Tools
  2. S

    Merging contact info from different exports (sticking point: phone/address/email type column + 1 data column vs. multiple data columns)

    I'm working with some seasoned realtors that are looking to combine their client data for an import into their CRM, one realtor has data that is stored in iCloud, Yahoo, and Gmail, which are exported to separate CSV files. The trouble is that the exported phone numbers, email addresses, and...
    • sebby_joe
    • Thread
    • csv files get & transform merge modifying data format transpose
    • Replies: 1
    • Forum: Excel Questions
  3. M

    merge CSV files and add original file name to a column

    Hi I have cribbed the code below in order to merge several weeks of data sent in a csv format into a single worksheet. However as there is no date contained in each csv file I have no way of analysing the data. Each csv file is named according to the date ie Sales Report 20.03.16-...
  4. M

    Import CSV files automatically into existing Excel workbook with different sheets

    Hi I want to Import 4 CSV files automatically into Excel workbook with different sheets Exemple: I have 4 CSV files (data1.csv , Data2.csv, Data3.csv and Data4.csv) I want to overwrite each CSV file in one existing CSV file with different sheets name Data1.csv to final_csv_file.csv sheet name...
  5. A

    opening csv files in separate worksheets

    hello experts, i have this macro to open a number of csv files. Problem is that it opens all the files in one worksheet. Could you add a few lines to the macro to open them in separate worksheets of the excel file. i would be grateful for the help. Thanks :) Sub BulkImport()'' BulkImport...
    • algae
    • Thread
    • csv files opening multiple file separate worksheets
    • Replies: 5
    • Forum: Excel Questions
  6. P

    dates and csv files

    Hope you can help me get started. Here's the question... I have created a spreadsheet called Matrix Test. I have it set so that when a user opens it they are to input a date in cell C1 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$1" Then If...

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
Back
Top