All Questions
Tagged with microsoft-excel csv
495
questions
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 ...
- 3
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 香&#...
- 113
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 ...
- 5,183
1
vote
2
answers
3k
views
Excel drops off values after saving the file
I have an MS Excel file that if I open and "save as" or "Save" it truncates (or I guess you can say cuts off) decimal values that are not being displayed in the cells.
For example, ...
- 11
0
votes
2
answers
2k
views
Converting TXT to CSV with a complex custom delimiter
I am trying to convert following text file into csv by using Text Import Wizard of Data Excel 365. File seems to have come from a source that is using 1252: Western European (Windows) encoding.
By ...
- 165
0
votes
1
answer
276
views
Characters not loading properly in excel when I open a CSV, how to fix that?
Let's say, I save a csv file from notepad/notepad++ with below text
Ákos Illés
Then, after opening the same in excel sheet, it is showing as below.
Ãkos Illés
Can anyone please suggest how to load ...
- 111
1
vote
0
answers
252
views
Concatenate dynamic date time with text in CSV file
Requirement: I have an excel file (a CSV) having a column - "Error -today's date & Time" (now()) to be picked every time Windows Task Scheduler batch file is picking this file. The ...
- 111
1
vote
1
answer
372
views
Why MS Excel doesnt render CSV file correctly
I have a CSV file with following contents:
timestamp, post_header, post_content
2021-12-05 16:11:31.138993,Pista Software | Test,"...<long multiline text>..."
2021-12-05 16:11:31....
- 123
0
votes
1
answer
177
views
How do I create a side-by-side file diff importable as a *table* by Excel, Word, or Google Docs?
diff -y file1 file2 creates output like this:
I want to take this output and convert it to a CSV format where
the text at left is in one column,
the < or | or >, if any, is in the second ...
- 101
1
vote
1
answer
1k
views
When importing a csv into Excel(2016) is there a way to specify which data should be column headers?
I have a csv file
user1,Donated,460
user1,GiftedT1,137
user1,GiftedT2,205
user1,GiftedT3,144
user1,Cards,123
user2,GiftedT2,123
user2,Donated,123
user2,Cards,123
Is there a way when importing the csv ...
0
votes
1
answer
3k
views
Convert a columns in Row into a comma separated list
I have this example :
And want to convert it to this comma separated as CSV like
this:
- 1
2
votes
2
answers
3k
views
How to import CSV using single quotes in Excel for Microsoft 365
My company recently upgraded from Excel 2016 to Microsoft 365. Before the change, when importing from Text/CSV the wizard would have an option for the delimiter and the quote character. Now, there is ...
- 125
1
vote
1
answer
2k
views
Make a copy of an Excel file as a CSV without having Excel "re-open" the file as a CSV
I have several dozen Microsoft Excel files in xlsx format. These files are the "master" copy for editing and include various formatting to make them easier to edit.
However, the data from ...
- 205