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
1answer
25 views

WMIC |more has extra rows when .csv opened in Excel

I am trying to output the name and version of each program installed on my system to a .csv file. I could do something more complicated with VBScript, but would prefer to keep this very simple to ...
2
votes
1answer
17 views

LibreOffice Calc/Spreadsheet – Delete unusual characters from cells so that I can export a valid CSV file

I received a spreadsheet for work and it has cells that are full of line breaks and excessive whitespace. Unfortunately, I need to export the spreadsheet to CSV format and these two are breaking the ...
0
votes
0answers
12 views

Anki fails to import from .csv file

I have created an custom note type containing 3 fields: Character, Pinyin and Definition. I have a .csv file containing a few entries. The fields are comma-delimited. Here's what I am presented when ...
1
vote
0answers
12 views

Undoing excel default / automatic delimiting [duplicate]

I have a large data export that is going through the end user for spot-checking. The data was formatted with tab delimiter, as it contains a lot of prices and measurements containing commas. The ...
0
votes
1answer
27 views

Have a very large fixed width .txt file, have column widths for the records to guide me, and need .CSV out of it [closed]

The text file is a tax roll off the tax assessor website, and it is 2.63 GB. Every program that I have tried, including UltraEdit, Convert XLS, didn't find anything helpful in excel because we're ...
1
vote
0answers
34 views

Properly extracting from an array

I have a CSV with one column, numbers formatted as 111-0000, that I'm reading in to process one at a time. I'm trying to import the column of information from the CSV, but I'm having trouble figuring ...
0
votes
1answer
42 views

Automate spreadsheet (Excel/CSV) workflow

I'm looking for a tool or process to help automate repetitive workflow tasks that require with an Excel or CSV file to be in a specific format. For example, we work with vendors that send us a list ...
2
votes
0answers
24 views

How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...
1
vote
1answer
52 views

Why doesn't my Python script save the file when I use Task Scheduler?

I have a Python script that uses csv.writer to create a csv file. This works fine when I run it from the command line, but no file is created when I run the script using Windows Task Scheduler. The ...
0
votes
0answers
26 views

Excel formula returning different results on different machines

For a piece of work I'm doing, I use a formula that calculates the difference between two dates for each row in the report that the system generates. Essentially, the software I'm using generates the ...
0
votes
1answer
17 views

Remove a specific string common in multiple lines in a CSV file using shell script

I have a CSV file which contains 65000 lines (size approximately 28 MB). On each of the lines they have a path in the beginning in the format of: c:\abc\bcd\def\123\456. Now let's say the path ...
1
vote
1answer
43 views

Windows Batch to read TXT and parse lines to CSV

I've made a good deal of headway by searching this site and learning the ridiculous language that is Windows batch scripting, but frankly I'm stuck. The sample below is from our lab's old radiometer ...
0
votes
0answers
27 views

Create Xbox Music Playlist from excel list (csv)

I created a few playlists in Excel (just the artist & song title) that I wanted to Import into Xbox Music. Unfortunately the only way I could find was to search for each song indivdually and then ...
0
votes
1answer
16 views

Mail Merge comparison between fields

I have a meeting merge document which is populated from a CSV file with data entered online from a facilitator. I am unable to work out how to do multiple conditions, there are a maximum of 10 clients ...
0
votes
1answer
34 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: ...
0
votes
0answers
12 views

Export specific results of Access 2010 query determined by checkbox

I am working on a planning tool which provides information about how long particular tasks should take. Everything was working as expected but I have just been informed that the user would like to ...
0
votes
0answers
14 views

phpmyadmin wordpress export only showing postmeta columns

Trying to export - and the import - a Wordpress MySQL DB using phpmyadmin. I've done this quit a bit in the past and I'm completely perplexed at this point! I have a fairly standard Wordpress DB with ...
0
votes
0answers
12 views

Styling multiple files on Libre Office Calc [duplicate]

Here's what I do now: Get CSV file from extrenal source Open it in Calc Apply style (set colors, fonts, etc.) Export as PDF Is it possible to get rid of step 3? Somehow loading data to already ...
0
votes
0answers
21 views

LibCurl: FTP, wildcard file inside wildcard directory

I am using LibCurl looking to download one file. The problem is that the server will regularly updating new directory, and inside that directory, I am looking to download SINGLE file end with *.CSV ...
0
votes
0answers
42 views

Convert CSV to an MP3 Playlist, then merge the MP3 into a single audio file based on playlist order

I have a Japanese language learning app, which contains several MP3s. I'd like to merge these MP3s into a single file, so I can take the course without using the app (as the App has a terrible ...
0
votes
1answer
32 views

PowerQuery to parse fixed width csv

I have fixed width csv.txt, e.g. Martin Junger 12 John Wing 124 To load it with PowerQuery this syntax is used: let Source = ...
2
votes
0answers
29 views

Convert UPPERCASE to PascalCase [closed]

I have 50+ CSV files (50 to 100 columns each) to load into the database using SSIS. Most of these CSV files have all uppercase headings (primarily because my Oracle exports only with all UPPERCASE ...
1
vote
0answers
45 views

Excel 2010 - Merge multiple connections into single worksheet

I have an Excel workbook containing several worksheets. Each worksheet has an external connection to a unique .csv file that is updated several times a day from different PCs. This is done so that ...
0
votes
0answers
21 views

Right click a csv file to read in RStudio?

I would like the ability to right click on a .csv file and read it in RStudio (an IDE for the statistical language R). When I say "read it in RStudio" I mean open up RStudio with the line ...
0
votes
2answers
183 views

Autoload CSV for batch printing labels (Brother P-touch Editor v5.1)

My goal is to automatically print shipping labels for an e-commerce website based on periodically created .csv-files. I have the .csv-files ready. I also have the shipping label template ready in ...
0
votes
2answers
42 views

How to remove rows that match?

I have a csv file with list of people (first name, last name, email) and then later on I will get a list of people in another csv file that unsubscribed ( only one column with email). Q: How can I ...
1
vote
1answer
32 views

Manually editing Excel worksheet, need my edits to save as written in .csv without reformatting back

Here is my issue: I have exported about 2000 records from a database to manually clean up the dates attached to them. (It appears that someone exported these records before, then re-imported them ...
2
votes
2answers
122 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
51 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
1k 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
300 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 ...
2
votes
1answer
61 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
133 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
95 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
68 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
115 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
68 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
1answer
618 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
71 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
39 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
138 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
104 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
36 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 ...
2
votes
2answers
2k 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
126 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
43 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 ...
14
votes
3answers
1k 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
39 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?
2
votes
4answers
212 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 ...