Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

learn more… | top users | synonyms (1)

0
votes
1answer
23 views

UNIX - Surround all Column values of CSV with double quotes

I have data in following format : productType , Description Oven , Accurate Preheat, good start for the day hairDryers , Comes with extended warranty , 50% off Desired Output: "productType" , "...
-2
votes
0answers
18 views

Difference between two rows of one column, add new row in between if different. (CSV)

I have multiple CSV files with similar data. which is retrieved from an automation module, I want to compare two adjacent Time Stamps and if they are less than 15 min apart add a new time stamp (row) ...
0
votes
1answer
26 views

cannot find any saved .csv files

I did search through many of the .csv realated topics that the search returned so I hope this is an appropriate new question... I am trying to setup an excel spreadsheet using a .csv file as the data ...
0
votes
0answers
27 views

Delete column from csv file with only cmd [duplicate]

Looking for some way to delete specified columns from csv file using only batch command file
1
vote
0answers
37 views

Excel Text Import Wizard Default Delimiter

Within the Text import Wizard, the default delimiter is TAB. Is it possible to permanently modify this default to be a comma? Don't be tempted to think that this is a duplicate question. Neither this ...
-1
votes
0answers
24 views

How to import data (csv) into s health?

I'm trying to migrate from iOS to Android and looking for a way to transfer Apple Health data to Samsung S Health. I've found the way to export data from Apple Health into comma separated value (.csv)...
0
votes
1answer
22 views

excell & csv is converting my tell no to not have +

I have tried several tricks and none of them are working i have tellephone numbers '+4 55 555 555 555 and in excell the cells that have the little green triangle warining sign, they loose the +4 and ...
0
votes
2answers
27 views

How to deal with lines starting with '=' in Excel?

I want to obtain a simple CSV file that looks like this: Filename,Value1,Value2 filename1.ext,0.38,0.44 filename2.ext,0.60,0.50 ... However, -unfortunately- some of my filenames start with = and ...
0
votes
2answers
19 views

Libreoffice Calc Saving TSV as CSV without asking

Create a tab-separated file saved as test.txt. Open in text editor and save: 1 2 3 4 This is a test (Those are tabs) Open it with Libreoffice Calc Click "Save" Libreoffice asks "Are ...
0
votes
1answer
45 views

How to `cut` (extract a subset of columns) a CSV file that contains quoted strings`

I have a CSV file and want to discard a couple of columns. So let's say this is a sample file: column a, column b, column c value a, value b, value c value a, "quoted, b", value c And now let's ...
0
votes
0answers
24 views

ping results exported to .csv to multiple rows and columns

I have a script that I run to ping multiple Ip addresses. It works just fine with everything that I have in it the way I want it. The problem is the export. I need "Router" to Start in Column "A" ...
0
votes
1answer
31 views

Excel: format first/last name to “lastname.firstinitial” format

I have exported a CSV of a list of employees. In cell A1 (the name format is the complete first name, space and then the complete last name). How do I make a cell with complete last, underscore then ...
1
vote
1answer
70 views

Merging Multiple Text File Data, but Specific Lines to Another

I have several Textfiles with a header of no interest and some relevant data. I want a new file with all the important data: Example: File1 has text: Created on 02.02.2016 Country: Chile Figure of ...
0
votes
1answer
42 views

Editing CSV file in Excel always converts number column to scientific notation [duplicate]

I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific ...
0
votes
1answer
17 views

getting only the names of the contacts when importing .csv file to my yahoo contacts?

i have been trying to import my contacts from my personal computer by converting them the .xlsx to .csv format and only the contact names are imported instead of the whole contact.my excel file is ...
2
votes
2answers
47 views

Why does Excel display these CSV files differently? One with Quotes One Without

I have two csv files and they appear the same when I look at them in a text editor like notepad++. However, when I open them both in Excel (2003 at this moment) one of them shows double quotes in ...
0
votes
0answers
19 views

Matching 3 or more words from fields in seperate csv files.

I have two csv files: This is csv1: 11, The Sun Still Shines in Reading, 64312, 464566 13, You and Me Together Again London, 564564, 131355 12, What's the Story Now Your Gone, 4545646, 1124545 17, ...
0
votes
0answers
42 views

Default character encoding for Excel Text Wizard?

A large part of my job is to run an SQL query, save the results as a UFT-8 encoded csv file then import it into Excel for further manipulation and distribution. When I import the csv file into Excel ...
0
votes
1answer
26 views

How to link csv file in Libreoffice 5

In previous versions of Libreoffice Calc, it was straightforward to import and link csv files through [Import] -> [Sheet from file...], as per the instructions on this page. This allowed me to refresh ...
0
votes
0answers
31 views

How to sanely export CSV in Microsoft Excel 2010

I need to export a sheet that has data in columns A:N but if I open it in Excel it has columns O:XFD that are just blank. When exporting to CSV Excel exports everything in those columns, thus the ...
0
votes
2answers
22 views

Viewing Tab Separated Values on the Terminal (it doesn't show the tabs)

If I have a tab separated values file, and I say cat it, it nicely renders the file for me all lined up properly. Now if I try to copy paste (using my mouse), to another text editor. The tabs become ...
0
votes
2answers
52 views

commas as text in CSV

How can i get this entire string to be imported into excel from CSV as one column (read the comma as text in the string, not a separator)? =HYPERLINK("https://elicense.ct.gov/Lookup/...
0
votes
0answers
13 views

How to migrate artifacts fom a project to another

I am the scrum master of a project. As a newbie to Tuleap, I created a sandbox project. After experimenting in my sandbox, I want to feed my true project with artifacts like user stories or epics. I ...
0
votes
0answers
31 views

Excel converts comma delimited to tab delimited when saving [duplicate]

I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This ...
1
vote
0answers
13 views

text qualifier of csv missing in excel

I have created a csv file with semicolon as delimiter and double quote ad text qualifier. But when I open in excel, the first double quote of the rows disappear. When I use text to column wizard ...
0
votes
1answer
71 views

add space after nth commas in Excel, Notepad++, or emEditor?

Notepad++ 6.8.8 I want to be able to turn several lines that start like this: 0,2,3,45,67,89,01,234,567,890,123,4567,8901 0,7,8,9,0,11,12,13,14,151,162,173,184 x,z,q,r,n,f,t,a,e,f,z,n,a into 0, 2,...
0
votes
2answers
28 views

Taking part of CSV file

I have a very large CSV file which I should analyze. It's too big so I can't even open it in Excel or Stata. So I want to take first few rows of it and explore the data, and then select necessary ...
0
votes
1answer
2k views

Weird glitch after copying from a CSV file?

I was doing a programming job that involved writing data to a large CSV file (700 MB). I occasionally opened the file using libre office to check the data coming in. This morning I opened the file (...
0
votes
2answers
25 views

How can i change the directory in this VBA code? VBA “Excel to TXT or CSV”

I really want to change the directory of this code in Application.ActiveWorkbook.Path but i don't know where to put it. Public Sub CharacterSV() Const DELIMITER As String = "|" Dim myRecord ...
0
votes
0answers
155 views

Exporting Outlook contacts to Unicode CSV

Background So I've been looking for this to work for some time now. I'm sure there must be a solution as I can't believe that no one in China or Japan have ever tried exporting contacts. What I've ...
1
vote
1answer
88 views

Export a csv file to multiple csv files with batch command

I have a 100 line csv file, with 5 values per line. I am looking for a way to export each line to its own csv file adding a 2 line header to each. I have used the split command seen elsewhere to ...
-1
votes
1answer
47 views

Removing duplicates from txt file

I have a txt file that can contain up to 13.000.000 randomly generated codes seperated with "\n" by the fputcsv function in php. What is the most effective way of removing duplicates from this file? ...
-2
votes
1answer
73 views

Separate fields in comma delimited fields

I am importing a comma delimited file into a ms access database that has statistical information for horse racing. The file has individual horses, dates of their races, finish position, etc. I am ...
1
vote
0answers
25 views

Notepad++ multi line copy paste in different lines

I have a csv file with: David,33,Virginia John,45,Alabama Tina,33, Texas Another file which contains: <Person> <Name>name1</Name> <Age>xx</Age> ...
0
votes
0answers
43 views

Importing Variable data sets with UTF 8 BOM japanese characters

I have an image template and have a xlsx file with Japanese characters wit two columns(PFA). I need to create images with this information by importing the CSV into variable data sets. When I convert ...
1
vote
0answers
35 views

Excel 2010 - Get CSV wizard to open by default

I'd like to set Excel 2010 to open the import wizard each time I double click on a CSV file rather than have Excel open the file without the wizard. Previous versions of Excel did this but 2010 ...
2
votes
1answer
49 views

How to specify semi colon character ';' as a line ending character when importing CSV to Excel on Mac

(Using Microsoft Excel form Mac version 15.18) Can see delimiters for the columns in the import steps, but no-where is there an option for defining what the line ending character is. I need this so ...
1
vote
1answer
37 views

Applying settings by default to CSV documents opened in MS Excel

End-users of a system we are developing are given a plain-old CSV file that end users will be opening in MS Excel. One of the columns will contain entries which consist of strings of numeric digits. ...
1
vote
1answer
81 views

Import from csv to Libreoffice Calc using 'two blank spaces' as delimiter

I want to import some data from a csv/text file to Calc. In the first column I'd like to have the 'Dummy text # i', and in the second column the numerical value. In the text file, 'Dummy text # i' ...
0
votes
1answer
31 views

Linux:AWK gsub command not processing correct output

On the below csv file I would like to change the scope from ENG to PROD; I have used the following awk command but there is no change to the file, could anyone please tell me what is wrong? test.csv ...
0
votes
1answer
24 views

How can I count unique comma-separated values - Early Bound vs. Late Bound

I am trying to display unique values from a string of values in a single cell.(separated by a comma). I've come across this solution: How can I count unique comma-separated values in Excel 2010 ...
0
votes
1answer
44 views

Is There an .xml Format File that Excel Can Read

I'd like to use C++ to generate an Excel file. I know that Excel can read .csv files, but I was looking for something with more power. For example, the ability to create separate sheets and insert ...
0
votes
2answers
114 views

Data validation in Excel- all values in comma-delimited list within cell range

I have a reference table of memos and some information about them, including what other memos they reference and are referenced by. I want to make a data validation rule that will appear red if any of ...
1
vote
0answers
43 views

Information lost during format conversion from .csv to .cap [closed]

I have my data from an experiment in .cap form (created using Pasco Scientific Capstone software), which I exported to comma-delimited form. When I tried to convert the comma-delimited form back to ....
1
vote
1answer
42 views

Replace returns wrong capturing group

I have a text file that looks something like this: ,'','a','bc','def','ghi','lmn','op','qr','stu' I'm trying to replace groups of 5 with the match and a line break for easy readability. So, I'm ...
0
votes
0answers
53 views

Excel Data Connection Always Has 1 Extra Row

I have an Excel file with a data connection to another Excel workbook. Every time that I refresh the connection, there seems to be one extra blank row in the table (with formulas, but there is no ...
0
votes
2answers
185 views

Rename CSV header using command line tools

Given a CSV file, h1 h2 h3 a b c z x b how to rename the first header to One and the third header to Three using command line tools, namely One h2 Three a b c z x b
0
votes
1answer
183 views

Batch file to get the domain name of hundreds of servers in a multi domain environment

In a multi-domain environment, I need to get the "Domain Name" the servers are joined to. I have a list of hundreds of Windows servers with the hostname only (not FQDN). I was wondering if there is ...
0
votes
1answer
74 views

Add custom category type column to an Excel 2016 Power Query

Used the power query feature of Excel 2016 to import several CSV files containing personal financial history and trying to use the power pivot thing. Problem is I really need to group the ...
0
votes
1answer
44 views

Macro exports date column to csv as numeric value rather than dd/mm/yyyy

The following code has achieved what I require except that the date [cell B2] is exported as as five digit numeric value rather than dd/mm/yyyy. How to I amend the code to force B2 to export as dd/mm/...