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

learn more… | top users | synonyms (1)

1
vote
0answers
19 views

How to enable the 'Save and Open' option in Internet Explorer

I've recently upgrade to Internet Explorer 11 and now when I try to download/open a *.csv file from the internet I get the following options in IE. The Save and Open option is disabled/greyed out. ...
-1
votes
0answers
27 views

Keeping two decimal places when exporting to CSV using Javascript [closed]

I have this function in javascript to display a number with thousand separator and two decimal places format when exported to CSV file: function toCurrencyString(num, decimals ...
0
votes
0answers
13 views

Gzip Mutliple files using single command [migrated]

Want to Gzip my all the .csv files into a gzip file. I am using this command. gzip *.csv; Problem File contains '//' in its name that's why command is giving error. Error : - '//File.csv' is not ...
-2
votes
1answer
35 views

Automate alignment of columns in CSV

I often work with CSV files, that other people will work with in a text editor. I want to have nice alignment of columns, e.g.: Height, Age, Whatever 11, 12, 13 For large files, this is ...
0
votes
1answer
22 views

Does Acrobat XI Pro Win ESD support fillable form fields from a CSV?

At work I had an old version of Adobe Acrobat Pro, version 9, which I used combined with some Actionscript and batch actions to fill in form fields using a csv file and finally outputting to one pdf ...
0
votes
1answer
44 views

Create CSV file from Excel with delimiter other than comma?

Is there a way to create a CSV file from an Excel one, but with a delimiter other than comma? I tried changing Windows parameters. In Windows Control Panel -> Click, Language & Region -> formats ...
1
vote
2answers
42 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 ...
0
votes
0answers
22 views

How to swap two columns in specific rows in LibreOffice Calc?

I have a few hundred contacts stored in Google Contacts, and I would like to sort them. I exported them in CSV and opened them with LibreOffice Calc. Some of my contacts have first and last name ...
1
vote
2answers
60 views

How to convert Excel file with multiple sheets to a set of CSV files?

I have an Excel file with 20 sheets on it. Is there a way to quickly convert the file into 20 CSV files - one for each sheet? I can do it manually of course, but I'll have to be processing these ...
0
votes
1answer
12 views

How to export Outlook Express group

I need to export an Outlook Express group, but it doesn't seem to have an option for that? Is there any workaround? I've tried using the options to export but they export the whole address book.
1
vote
1answer
34 views

How to export full data from excel as a csv using macro?

I want to export an excel file as a csv using macro, but my code is only exporting the header only. How to export the full data? Here's my code: Sub CSVFile() Dim My_filenumber As Integer Dim ...
0
votes
2answers
31 views

Excel Formats Numbers as Dates

I have several very large .csv files that I need to work with, and Excel makes this very easy (obviously). One of the fields is in the format 10/3/2013 19:00, and Excel automatically converts this to ...
13
votes
3answers
720 views

Excel does not honor the delimiter setting for reading or writing CSV files

When saving/opening CSV files in Excel, the default separator is a semicolon (;), as I need it to be a comma (,) I tried to change it by changing the Language and Regional settings following several ...
1
vote
1answer
21 views

Why does Excel only invoke the Text Import Wizard for .txt files?

Excel ignores comma delimiters in .csv files, but invokes the Text Import Wizard for .txt files that "appear delimited". Surely it should behave the same way for .csv files?
1
vote
4answers
79 views

Grep to filter gigantic CSV file

I'm dealing with a CSV file that contains over 2 million lines. Quite a big one. I need to use grep (or any better way) to retrieve the entire row if the value of the second column matches 'jpn' or ...
1
vote
2answers
37 views

Can you save font choice in a CSV file?

I have an XLSX file where there are two different fonts. One cell contains English, while the other contains another language. I would like to save this XLSX file as a CSV file without losing the ...
1
vote
2answers
33 views

reverse print without trailing

I have a bash file calling a dns zone and have piped out the fqdn which I need to output in reverse. The snippet below does that fine except I get a trialing . at the end which I don't want creating ...
2
votes
3answers
195 views

Converting a .txt file with tab as separators into a excel spreadsheet

I have lines of data in a text file where each entry is separated by tab. I want them in different columns and each line to form a separate row in excel. I tried using Data > Import but it all comes ...
0
votes
0answers
76 views

Excel VBA Script How to Open a File and Insert character into Cell

I'm hoping this is an easy one. I am importing a directory of CSV files with long numbers (16 digits plus 4 leading zeroes). I need Excel to preserve the number data instead of applying scientific ...
0
votes
1answer
35 views

How to replicate an anchor tag in Excel

I have an Excel (csv) like this: column1 link yahoo <a href="www.yahoo.com">Yahoo</a> google <a href="www.google.com">Google</a> Is there any way to make link ...
0
votes
1answer
26 views

How to search for a certain keyword that match the variable in batch file

I have search and tried various question and solution that are posted in this site. But a beginner like me doesn't have the brain for it. The code below work well if I put 1 single string. how to ...
1
vote
0answers
102 views

Adding users from .csv file to AD security groups using powershell [closed]

I have about 300 users that needs to be added in about 40-45 security group, each user can be a member of multiple groups. I have all users with corresponding security groups in a .csv file. Is there ...
0
votes
1answer
33 views

Using Wildcard find and replace in a CSV CNC file using Notepad++

Hi I have a requirement to remove every occurrence of the "LIP_CUT,number.number," out of pages of code. I am newbie to this type of argument structure and cannot get any results so far. Any help ...
1
vote
0answers
39 views

How to fix botched Outlook CSV data export 2013

When I exported contacts from outlook into a CSV file (to later upload it to Insightly database), it placed company names as part of the email address, it looks like this: Column named "E-mail" ...
0
votes
0answers
64 views

Import multi-line CSV records into spreadsheet as column data

Any standard fixes to convert multi-line CSV records into column data (as CSV or LibreOffice)? I'm using ArchLinux and I have LibreOffice (and Python, for what that's worth). I have a CSV file with ...
0
votes
2answers
45 views

Importing multiple CSV files

I have to run a daily stock analysis where I pull multiple .csv files, and then have to go through an annoying task of deleting unnecessary fields from the .csv's. Only then can I start compiling the ...
0
votes
1answer
52 views

Excel - Find a specific column in a CSV file, and copy to the current sheet

I get a regular data export in a CSV format, which I like to pull into excel and report on via helper columns and pivot tables. I do this by linking to the csv file, and copying the cell contents ...
0
votes
1answer
69 views

CSV File saving as Creo Pro Versioned File

This is an odd one, I'm saving an Excel file as a CSV file, which is the required format I have to send this data in as. However when I save the file, it shows in the Directory as a Creo Pro Versioned ...
2
votes
0answers
38 views

Newlines in description of imported csv in Outlook Calander

I have exported a list of birthdays from excel to csv. Now I want to import them in Outlook as calander items. Everything works fine exept I can't do newlines in the desciption. I've already tried to ...
0
votes
0answers
16 views

xls2csv skipping bool values when converting

I'm attempting to use catdoc -> xls2csv on an Ubuntu 14.04.1 OS to convert and .xls file to a .csv file. All of the values are converting correctly except in the last column which contain TRUE/FALSE ...
1
vote
3answers
98 views

Excel: How to skip specific rows when importing a CSV

I want to skip the header and last rows when importing a CSV into Excel, just like I can skip specific columns. Is there a way to do this?
0
votes
1answer
127 views

Postbox/Outlook 2013: Strange Contact Import Behaviour

I'm experiencing a very strange error with regards to importing contacts that were exported from the Postbox 3 address book. The CSV file itself is fine - everything maps out nicely in Excel, but ...
0
votes
0answers
70 views

Birt report export to csv

I am trying to export a CSV report by running a simple classic cars example in BIRT 4.4.0. I gave the column Names as Name, Phone, City, Country in the report where as the exported report has the ...
1
vote
2answers
219 views

Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure: text, text, 01/27/2001 01:00:00 PM I need to update ALL csv files with this datetime format: text, text, 27-Jan-2001 13:00:00 Is there a known ...
2
votes
2answers
59 views

Best way to search for a string (text) in >10 large CSV files (250mb each)

I am wondering what's the best way or tool to search for a specific text or string in more than 10 large .csv files. Each file is 250mb in size. My idea was to write a powershell script, since I ...
0
votes
1answer
27 views

Open .csv file with template from XLSTART

I'm testing the program which would create a large .csv file and need to open it with minimum clicks (saving my hands) during testing. The file contains 20+ columns of counters, no formatting ...
0
votes
1answer
83 views

Comma delimited import issues in SQL Server

I am having a problem with SQL Server. I have a table with 42 columns to which there is frequent monthly imports. These imports are from a flat file using the import and export wizard. My problem is ...
0
votes
1answer
68 views

How can i make changes to this file Encoding?

I have these 3 files 21/08/2014 07:15 PM 122 Tw2AWK.csv 21/08/2014 07:15 PM 125 Tw2Notepad.csv 21/08/2014 07:15 PM 119 Tw2REPL.csv C:\myfiles>file ...
2
votes
0answers
59 views

How to customize default CSV format in LibreOffice?

Every time I export my data to CSV (and I do it often) I have tick the "Edit filter settings" checkbox, choose UTF-8 for the encoding, and semicolon for the fields separator manually. I do this ...
0
votes
1answer
1k views

Convert a JSON file to CSV or XLS (Excel) format

I have a number of JSON files which my old charting system will not accept as a data format for import. Is there an easy way to convert these to CSV or XLS?
1
vote
1answer
35 views

excel grid to columns

I have data in an array/grid like this: Name | Group | A1 | A2 | A3 name1 | Group1 | 14.95 | 19.95 | 0.00 name2 | Group2 | 4.95 | 9.95 | 12.95 name3 | Group2 | 49.95 | 0.00 | 0.00 And I need a way ...
0
votes
0answers
86 views

Images in CSV file don't show up in Anki

I'm trying to import a CSV set of notes that include image references into Anki. I have a file with Cloze substitutions and in one note I am using an image in the text: <img src=”duck.jpg”> ...
0
votes
0answers
116 views

How to make my loop omit empty Excel cells while converting to .csv - Powershell

I have some empty cells in my Excel worksheets.How to make a proper statement to make my loop omit them? I tried to do a if(){}else{} loop but it doesnt work properly.I have a powershell v2 so I ...
0
votes
1answer
45 views

CSV compabtility issue in excel

I download a .csv from database and use the file to generate a PDF using a PDF conversion service. However, for specific files, the conversion fails and the request times out. I checked the file type ...
0
votes
1answer
46 views

Excel 2010- long number corruption

I have a set of data, received in .csv format, in which I have a set of long UPRN numbers. I am involved in data matching processes related to new IER voting regulations. When I open the .csv file the ...
0
votes
1answer
25 views

excel 2010 is appending a space to the end of currency field when saving a csv file

Create an Excel spreadsheet with one cell. Put "$1,234.56" (WITHOUT the quotes) in the first cell. Save it as test.csv. Open test.csv file in a text editor, Notepad.exe will work. The file contains ...
1
vote
2answers
585 views

Excel save-as CSV options — possible to change comma to pipe or tab instead?

Is there a way to tell Excel which delimiter to use when producing a CSV, e.g. tab or pipe?
0
votes
3answers
68 views

Excel - take two csv files and map them

I have two csv files. 1 has a list of emails, another has a longer list of emails with first names, last names, address, etc. What I am looking to do is take both of these files and map the emails ...
0
votes
0answers
32 views

How do I change the EOL character when importing a CSV file into Open Office Calc?

I've got a CSV file that has enclosed newline (\n and \r, mixed) characters in its data. Because the consumer of that file is not able to handle that correctly (out of my control) we decided to use ...
0
votes
1answer
181 views

Using multiple data sources in a scatter graph

I have a script that runs something in a loop and writes its duration into a .csv file on a share. The file looks like this: "timestamp","duration","ComputerName" "7/8/2014 2:56:03 ...