All Questions
10
questions
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....
-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
749
views
What is going wrong with importing and formatting the following .csv data set into Excel?
I'm trying to import the following CSV data set into Excel. I'm using the Text Import Wizard to set the right delimiters. So far, I used the ";" and "," delimiters.
Here is the ...
- 139
0
votes
2
answers
302
views
Changing the structure of csv data
I'm trying to change data looking like this:
original csv
into this format:
name = "The V Girl";
author = "Mya Robarts";
pages = 341;
imageURL = "https://i.gr-assets.com/images/S/compressed.photo....
- 3
-1
votes
1
answer
49
views
How to format a CSV with blank data in some places
I have a CSV with the following headings (and example data):
Serial Number, Photocopier Model, Copy Volume, MeterType
432322,Canon,Copy Volume, MeterType
,,23423,BW
,,983,Colour
,,4405,A3 BW
,,34,A3 ...
- 116
1
vote
1
answer
250
views
csv file formatting issue in excel
I have a csv file when opened in notepad looks like this:
sep=,
ProgramXX, PXXXXX, ....
IDXXXXX, XYZXXXXX, ....
This should open well formatted as csv file in excel program but what I see is this:
...
1
vote
2
answers
643
views
Formatting of output .csv file generated by a software
I've been using a software which gives the output in .csv format automatically. In my .csv output file "." is used as a decimal separator. In my colleague's computer, the same software outputs the ....
- 1,725
2
votes
1
answer
2k
views
Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string
I had a followup question to this related post -
Formatting a CSV to force Excel to interpret value as a string (not date or number)
I was wondering how does one escape text starting with " using "...
- 171
135
votes
6
answers
326k
views
Formatting a comma-delimited CSV to force Excel to interpret value as a string
I've been searching around for a while trying to figure out how to output a CSV file in such a way to force Excel to interpret the values as a string and not try to convert them to numbers or dates.
...
- 4,174
5
votes
5
answers
168k
views
How to set a character limit and remove characters over that limit excel 2007
I have to provide a CSV file for a telephone system with names and numbers on for a directory. The numbers cannot contain any spaces, and the names must be 20 characters max.
I have a list of names/...
- 2,099