All Questions
Tagged with microsoft-excel csv
495
questions
0
votes
0
answers
46
views
Can't save CSV file from Excel (Windows 11, MS Office Home and Business 2019) to WSL 2 folder
I have an Excel file (MS Office Home and Business 2019, running under Windows 11) that I want to save as CSV file in a WSL folder underneath my WSL home folder. WSL is running as version 2 with Ubuntu ...
0
votes
0
answers
46
views
How to append multiple .csv into one .csv (not multiple sheets .xlsx)?
Looking to do something like this:
Is there a script that can do that? I've tried searching and the scripts are either 404'ed or they merge them into a single .xlsx with multiple sheets.
0
votes
0
answers
70
views
Excel treats a date in format (dd-MMM-yy) differently if typed or pasted
This was discovered when opening a file in CSV format that has a column of dates in the format dd-MMM-yy (e.g 20-FEB-24). When opening this file in Excel (Excel 365 desktop) if the 2 year value is <...
0
votes
1
answer
99
views
Excel - how to handle custom timestamp format
I have some measurement data from a datalogging software, saved as CSV, and one column contains time stamps like this:
12.04.2024 15:11:32:684
12.04.2024 15:11:35:752
The format of this is:
dd.mm....
0
votes
1
answer
71
views
What gives Excel/csvs their formatting functionalities?
When I open a csv file by double-clicking it, it opens, and as one would expect, displays the data in a big array of cells with a ribbon of formatting options at the top (Clipboard, Font, Alignment, ...
0
votes
3
answers
41
views
Excel removes delimiters from first field of "foreign" CSVs
Here's a CSV (UTF-8 BOM encoding), with some values delimited with quote marks:
AAAAA,BBBBB,CCCCC,DDDDD
"a2",b2,c2,d2
a3,"b3",c3,d3
a4,b4,"c4","d4"
a5,"...
-1
votes
3
answers
922
views
PowerShell: Export Ping Results to CSV
I have a PowerShell loop that does effectively what I want it to. The problem is that the output is very messy. I work for an ISP and one of the most effective ways we have to diagnose network issues ...
0
votes
0
answers
24
views
Importing CSV into Excel via Data -> From Text/CSV: Can I automatically apply the Power Query column formats?
Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit
I have an external program that creates CSVs. Some of the columns have eg. $ or %. The import query is smart ...
0
votes
0
answers
479
views
How do I save the date formatting on a CSV file please
Hi I have several date fields created in an Excel file with the formatting of yyyy-dd-mm and yyyy-dd-mm hh:mm. I need to save as a CSV file but lose the formatting when re-opening the file. Any ...
0
votes
2
answers
2k
views
How to set MS-Excel as default program to a .csv file in Windows 11 pro?
I am not able to set MS-Excel as default program for a .csv file in Windows 11 pro. I have tried many ways, but not able to do it.
I have to either choose "open with" option or first open MS-...
-1
votes
1
answer
57
views
What is causing the xcopy file from having an error in it?
I am new to xcopy. I am trying to move a file that is in excel format to a new destination and as a csv file. I have to do this so that the DMExpress ETL job can move the file and then read it. This ...
4
votes
2
answers
1k
views
How do I keep values the same when converting from XLSX to CSV? Export to CSV with expanded numbers and not scientific notation?
I have an XLSX file which I am opening with Excel 2016.
This file includes a column "Code" which contains barcode values. The column has a number format of General.
Looking at this column, ...
0
votes
0
answers
29
views
Excel exporting to CSV. Can I use another character than " to enclose text? [duplicate]
(there is a similar question in How to avoid double quotes when saving Excel file as Unicode?, but the case described below has an issue with single doublequotes. Usually used for inch values like 3&...
0
votes
1
answer
368
views
Can I make an excel template that will save as CSV automatically?
I want to make an excel template xltx that will automatically save the resulting workbook as a .csv.
Open template -> blank workbook (and template data) -> Save ->
CSV format already set.
I ...
0
votes
0
answers
207
views
Managing utf8 CSV on Mac
I use Excel on macOS and when I try to combine CSV files downloaded from SaaS platforms, it messes things up on the first lines. I don't have this problem when using Excel with Windows.
For now, I ...
1
vote
1
answer
43
views
How do I use an API to extract to CSV? [closed]
Sorry, I've tried reading up on it but I just don't understand any of it.
There is an organisation, ALISS.org, which has a section with their API that lets you interact with their database of local ...
0
votes
0
answers
61
views
Concatenating of the strings of the each paragraph
Is there way concatenate the strings of the each paragraph in one line? For example, I have many the same paragraphs with the space between them, it looks like:
Is there way to put each such ...
0
votes
1
answer
92
views
Why do Ratios not carry over from Xlsx to CSV format
I have an XLSX file that we have output from SAS. The column in question are results from an assay that result in a titer ratio, "NEG" or "Not Assessed". In the XLSX file the ...
1
vote
1
answer
728
views
Change encoding to Unicode in .csv exported from Gmail
I'd like to copy the typed-in addresses from Gmail to Outlook 2021 (Windows 10).
To do this, I'm using the Google Contacts Export to Outlook CSV function and nk2edit.
The problem is that the special ...
0
votes
1
answer
901
views
Convert (part of) XML data back to tabular data or CSV/tab separated without using scripting
Is there an easy way to convert (part of) XML data back to tabular data, so comma separated values or tab separated or Excel? I sometimes get XML log files, and for clarity and comparing it more ...
1
vote
1
answer
660
views
How to tell Excel to change right encoding in opened file?
Can somebody tell me please how to tell Excel to set up right encoding for csv file? It seems it is not possible without any annoying steps. I would like to see something like Libre office or Open ...
1
vote
1
answer
950
views
Excel: How to search for values from a column within a cell that has comma seperated values
I have one column with text in seperate rows, and a cell that has comma seperated values within the singular cell, as below.
One
Two
AB
AB, EF
CD
...
I'd like a formula to return True if any text ...
0
votes
2
answers
72
views
Misleading data format Excel .csv
I am generating a .csv file with data like the example below:
TIME,LUX
18:00:00,30
18:00:01,30
18:00:02,30
18:00:03,30
18:00:04,30
18:00:05,30
18:00:06,30
18:00:07,30
18:00:08,30
18:00:09,30
18:00:10,...
0
votes
0
answers
907
views
How to import multiple csv-files in Excel at once with VBA
I am trying to import multiple csv-files within the same directory into my Excel sheet using VBA. The following code is working very well with just one csv-file. But I lack the knowledge to adapt my ...
0
votes
2
answers
203
views
I have two cells each with comma delimited values, I want to combine these into one cell
I have two excel cells(A1 and B1) each contains comma delimited values in, I want to combine these values into one cell (C1), so that the first value from cell A1 is "linked" to the first ...
1
vote
1
answer
1k
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
-1
votes
2
answers
242
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...
0
votes
2
answers
2k
views
i downloaded a csv file, but data is not separated by commas
I downloaded a dataset from kaggle.
kaggle data:
but all the data is in one column in excel.
data in excel:
I need this data for my project. how can I get this data separated?
7
votes
2
answers
2k
views
Bulk fix for Excel 97-2003 error "format does not match extension"
Context
I have received around 1700 97-2003 excel files with a ton of data including some text information. I am trying to read them all into Stata before I clean and run some statistical analysis. ...
0
votes
1
answer
263
views
running 2 excel versions at once, cant associate filetype to older version
I have excel 07 and the latest Excel 365 (I think thats Excel 16) both installed in windows 10. When I just had 07, I had no problem associating csv and xlsx files with that program. Now that I have ...
0
votes
1
answer
42
views
How to make comma elements in Excel sheet be in their own row, with identical data for other columns
What I mean is,
turn this:
| ID || Names |
| 1 ||A, B, C|
| 2 ||A, D, F|
into this:
| ID || Name |
| 1 ||A|
| 1 ||B|
| 1 ||C|
| 2 ||A|
| 2 ||D|
| 2 ||F|
The data I'm trying to transform has ...
0
votes
1
answer
2k
views
How to convert a CSV’s timestamp format?
I am trying to convert a CSV file that returns the time stamp as hh:mm:s.mmm into hhmmssmmm with the added s for second.
For example I pulled a CSV file in which the time came back as 10:15:7.123 but ...
0
votes
1
answer
43
views
Move lines based on ending of previous line
Looking to get some insight as I'm lost on this one. I'd like to move lines based on the ending of previous one. It's a large CSV file that has a comment column that exported in line breaks from the ...
0
votes
1
answer
1k
views
How to insert filename from cell into excel formula?
I have a bunch of .csv files that have IDs that I am trying to insert into a formula. The IDs are all listed in column F. Here is F in my sheet:
F
701
684
128
701
485
701
...
Each CSV file is in a ...
0
votes
2
answers
912
views
How to Convert 2 Columns of Data to Bullet List?
I have a csv of data that exists as a hierarchy.
ColumnA = Parent
ColumnB = Child
There may be multiple children per parent.
I would like to convert the excel data to a bullet list hierarchy. (if ...
0
votes
1
answer
226
views
Manual input column with restricted allowed values in power query imported table
I'm using the Power Query Editor in Excel in order to obtain a table composed of the content of all the CSV files that I put in a specific folder. This table contains a list of bank transaction. When ...
3
votes
2
answers
1k
views
How can we open CSV files that are using single quotation as string delimiter in Excel?
We are working with a set of data that contains all kind of characters (comma, semi-colon, double quotation, tab, etc.). To handle this situation, we are using single quotation to surround the strings ...
1
vote
2
answers
2k
views
Export Excel sheet as CSV, with regional settings
I want to export an excel sheet as CSV, with powershell. The issue I have is that the regional settings are not respected. They say to use semicolon as delimiter, but comma is used instead. If I ...
0
votes
2
answers
2k
views
How to turn column data into csv data?
I've got a bunch of names (around 300), they were filled out as standard text in Excel. However in order to process this data I need to turn it into a list of names separated by commas (a csv). I can ...
0
votes
0
answers
3k
views
Stop Excel from re-interpreting date format on re-opening CSV
I have many large datasets that I am saving in .csv format, the input date values are in Julian format, but the final date format I want is dd/mm/yyyy hh:mm:ss. This part is simple, I just apply a ...
0
votes
1
answer
23
views
Incrementing values when values changes in different column in excel
i want to change values when id values changes to different in excel
like this
ID
ChangedId
8
1
8
1
8
1
22
2
22
2
25
3
Any help will be thankfull.
0
votes
1
answer
65
views
Why is Permon data time format is reversing day and month when I open csv in excel?
I have exported perfmon logs into csv.
I open the csv in excel, and the 1st column has the datetime value, so I right click on it and format to select the following custom format: dd-mmmm-yyyy hh:mm:...
0
votes
0
answers
366
views
Excel not opening .csv files
I reorganised my folders in Windows Explorer and when I try to open some .csv files with excel I get an error "Sorry we couldn't find "xyz.csv". Is it possible it was moved, renamed or ...
0
votes
4
answers
26k
views
.csv did not save all tabs
I downloaded a database in .csv and made pivot tables in different tabs.
I saved the file without complications, but when I went to open it, only the tab with the database appeared, the other tabs did ...
0
votes
4
answers
2k
views
How do I batch delete entire rows that do not end with forward slash in CSV file?
I have a CSV file that is too large because it contains file paths as well as directory paths. I need to modify it so it only shows the directory paths but not the files themselves.
I'd like to know ...
1
vote
0
answers
658
views
Use Microsoft Excel to import and refresh data from only some columns of a CSV
I have a CSV that's 100+ MB, so it takes a long time to load.
In Microsoft Excel for Mac Version 16, I'd like to use the "Get data" or a similar functionality to load data from that CSV into ...
0
votes
2
answers
473
views
I have a text file that has 2 columns I need to merge all lines in column 2 before the next column 1 attribute id
Have only ever dealt with very simple text to csv data formatting. I am working with a text file with 14900 lines for a mapping project. I have tried delimiting using tab etc but cannot get a single ...
0
votes
1
answer
5k
views
Excel VBA save to CVS file
I have an excel file which has a macro which saves the file as a .CSV file. I have a program that calls on the CSV file but the program only recognizes the .CSV file if I open it manually and save it. ...
1
vote
2
answers
3k
views
How do you open/import a CSV file with Unicode characters encoded as numeric character references?
In Excel, I tried to import (using Data > Import) a CSV file with Chinese characters. The characters are represented as Unicode numeric character references (NCR); for example 香&#...
1
vote
2
answers
1k
views
How can I export data without "Save As..."?
I have some data in an xls file. I want to export it to csv. I don't want to save the file as csv, I just want to export it so I don't have to then go back and "Save As..." the original ...