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

learn more… | top users | synonyms (1)

2
votes
2answers
21 views

excel: export csv file with japanese character

In my excel file, the Japanese character is shown correctly, while when I export it as csv, the character become question marks How should I output so that the character can be shown correctly?
0
votes
0answers
26 views

Excel 2013 keeps removing commas from CSV at save

I'm working with data exports in CSV format. Excel originally opens the files correctly. However, I've been merging in some missing data that my original queries missed (adding four rows of additional ...
2
votes
3answers
318 views

Excel adds double quotes on csv export [duplicate]

I am experiencing a weird unknown behavior in excel. The sheet I want to export to a csv file consists of 4 columns with data like this: site.aspx|de|lblChanges.Text|some text that will be used ...
0
votes
2answers
48 views

Removing commas from CSV file

I created an Excel .XLXS file, reformatted the columns from currency to numbers with 2 decimals and no thousands separator, then exported to a .CSV file, then to a .TXT file. Once I did that, the ...
1
vote
1answer
25 views

Create an animated plot of data points from csv

I have a large CSV File containing some data points [~3MB, example data] as a series of coordinates. I want to create an animated plot of point where the point is moving acoording to the given ...
1
vote
1answer
62 views

Using the with cURL command-line tool on Mac, What can I do to this script to ask it to fetch stock data which comes back WITHOUT commas?

cd documents/quoteUpdate while true do curl -o quotes.txt -s "http://download.finance.yahoo.com/d/quotes.csv?s=goog,aapl&f=sl1c1p2pt1" echo UPDATED: date sleep 10 done
0
votes
1answer
27 views

How to display US format date time in csv file in UK format in Excel 2010?

I have a Windows Performance Monitor csv file that I want to view in Excel and produce charts from. The first column in the csv file is in US datetime format. e.g. "01/12/2015 10:54:44.043" which ...
0
votes
2answers
41 views

Unable to get accurate record count of a csv file

I have a .csv file that has some values formatted as paragraphs with line breaks or sometimes bullet points. "STAT","ID","DESC" "UPD", "1", "Updated" "CHG", "2", "Changed" "UPD", "3", "Updated. ...
1
vote
4answers
50 views

How do I stop Excel from converting value 0503E000 to 5.03E+02 automatically?

Excel converting value 0503E000 to 5.03E+02 in any cell automatically in CSV I tried to convert it to text number and general but after i save it and reopen it again it goes back to 5.03E+02 How do I ...
0
votes
1answer
40 views

How do you export an Excel file to CSV with rows have differing number of columns?

I have text file with a header, master, detail, footer record. The types of rows all have a different amount of columns. When I export to CSV, it exports all data and puts in fillers to the longest ...
1
vote
0answers
57 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. ...
-2
votes
1answer
39 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
26 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
59 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
57 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
29 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
178 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
46 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
35 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
842 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
23 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
115 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
45 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
35 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
221 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
116 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
38 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
31 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
111 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
41 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
47 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
89 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
54 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
65 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
85 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
41 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
22 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
142 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
181 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
88 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
302 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
67 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
28 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
109 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
75 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
65 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
2k 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
39 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
107 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”> ...