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
30 views

How to export a spreadsheet to a UTF-8 .csv from Excel 2016 on mac?

Hoping you can help me out with this one... For my work, I've been assisting a DBA for the last few weeks and we've now been given the task of uploading a very large spreadsheet which has several ...
0
votes
1answer
12 views

Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...
3
votes
2answers
59 views

Which delimiter allows major spreadsheet programs to open CSV files by double-clicking?

I'm writing an iOS 8 app that allows you to export data to be sent as an email attachment. Currently, I'm exporting the data to a CSV file with 7 columns and x number of rows. When I first created it, ...
0
votes
2answers
59 views

UTF-8 File is not showing Chinese characters in Excel

I am creating a CSV file with UTF-8 encoding. It displays the Chinese characters properly if I open it using Notepad++. It displays the Chinese characters properly if I open it using Notepad. But, ...
1
vote
1answer
29 views

How can I automatically segment a mp4 video based on a list of frames

I have a 7 hour long h.264 video made up of 1600 shorter videos and I have a csv file with a list of frames at which I need the longer video to be cut at. Is there any way that I can automatically ...
1
vote
1answer
33 views

How can I write only certain rows of an Excel worksheet to CSV?

I have created an Excel (2010) workbook that takes information from various CSV files and puts them into a format that can be understood by my office's scheduling program. Using a macro I found ...
0
votes
0answers
30 views

Losing decimal places when exporting to csv

I am exporting data from oracle table into a csv file. I have a column of varchar2 datatype and it has values like 1.1 and 1.10. When I export these to a csv file the value 1.10 becomes 1.1 and thus ...
2
votes
2answers
27 views

Delete everything in second column not in parentheses

I have a file that looks like this: gene ID protein Solyc06g062540 (Z) PYROPHOSPHATASE 3 (PTHR20889:SF0) Solyc10g075050 ALBUMIN SUPERFAMILY (PTHR33076:SF11) Solyc07g061760 ...
1
vote
1answer
20 views

Import Network Settings (wi-fi) from Windows to Mac; Bulk Import of Wifi Keychain Passwords

I have a CSV/TXT file with a list of network names and passwords (together with network/password/encryption types) that looks like this: ***Networkname1*** ESS WPAPSK TKIP passPhrase ...
6
votes
3answers
99 views

How to split a CSV file into multiple files based on a text string?

I have multiple text files (CSV) with a structure similar to this: funkiana,23.55,-99.866 funkiana,24.634,-98.701 funkiana,24.717,-98.901 geminiflora,22.25,-104.6166667 ...
0
votes
3answers
56 views

What is the delimiter for the CSV file below?

I'm having trouble importing the CSV file, below, into Excel 2007. I can't figure out what the delimiter is. ...
1
vote
2answers
54 views

Concatenate csv-files with the same name from subdirectories

I found some scripts concatenating text files from different subdirectories, but all of them produced output files like "output.txt", but didn't keep the original file name. Structure Folder_A ...
1
vote
1answer
20 views

How can I disable dates in the Calc?

I see that all spreadsheets are urgent to recognize your 13.12 as a date. Particularly, I am struggling with Calc, who is said to use English language to import dots as decimal separators. But, ...
1
vote
1answer
40 views

What has caused my csv load time to dramatically increase?

I have a monthly report formatted as a .csv file. It's file size is 90 MB. It used to take around 10 seconds to open. Now it takes 4-5 minutes. When I convert it to an .xlsb, it takes 10 seconds. ...
1
vote
1answer
36 views

Invalid field count in CSV input on line XX in phpmyadmin?

I have a 16MB CSV file with 50,000 lines that I want to import into my database. I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options. The import fails with the error Invalid ...
1
vote
0answers
28 views

feed XML to google calendar [closed]

I have an XML file with seminars that I would like to feed to google-calendar. The XML file is maintained by someone else and is updated regularly, so I would like to do this in a way that google ...
0
votes
1answer
38 views

CSV Input for Merged Columns in Microsoft Excel

I am using Excel 2010 (v14.0) on Windows 7. I would like to have a header, and subheader, where columns are merged in the header but separated in the subheader and data. I know how to merge columns ...
1
vote
3answers
106 views

Need a batch script to copy data from A.csv to B.xls

I'm a newbie to batch scripting and need help. I want to copy the contents of a csv file A.csv to the first worksheet named "GenData" in a existing XLS file B.xls. B.xls contains some macros in it's ...
-1
votes
1answer
119 views

Visual Basic and Excel data streaming in real time [closed]

I'm currently working on a program that runs in visual basic (not VBA). The program collects data from sensors and produces a data file (*.csv) of the information it collected after a certain stretch ...
0
votes
1answer
87 views

Automatically format cells as currency from .CSV when importing into Excel

When I import a .CSV file into Excel, how do I get all cells which contain a number to be formatted as currency? Currently, if the value for the cell contains the dollar sign ($), it becomes formatted ...
0
votes
1answer
37 views

Is there a way to update automatically a worksheet based on a link which provided a file for download

I have created a web app which allows the user to download a csv file just by copying the link into a browser. Afterwards the user can open this file with excel. Because the csv file might change ...
0
votes
2answers
329 views

Removing Line Breaks From CSV for Proper Excel Import

So I've created a batch script that outputs some text to a CSV. When I open the CSV in Notepad, it looks like this, which is how I want it. 173030,8,2793,2821244 173032,1,2793,2820692 ...
1
vote
2answers
69 views

How to prevent Excel to round a number at opening? [duplicate]

I have a question regarding Excel. We generate automatically a CSV file everyday, containing stuff looking like : column1;column2;...;columnx text;date;text;249316479917397279 The issue is that the ...
0
votes
2answers
18 views

How does libreoffice express a linebreak when saving a csv?

I’m attempting to save a CSV using LibreOffice Calc to be imported to a MySQL database. Saving it as a CSV is pretty straightforward in LibreOffice but I don’t know how the resulting document ...
0
votes
1answer
32 views

Parse csv file and for each object set as a variable

What I'm trying to do is parse a csv file that has server names and ipaddresses and assign these to variables I then run commands using each set of variables. So if the cvs file, test.csv, looks like ...
0
votes
1answer
22 views

How to add double quotes around data in tables using Calc

I am trying to load my data into a CRM, but am having a lot of trouble. The data simply wont load at the same time, but all the files work fine individually. Support advised that I make sure I'm using ...
1
vote
0answers
320 views

How do I suppress the “file format and extension of MyFile.csv” do not match."?

I'm opening a lot of csv files using Excel recently and am repeatedly receiving the warning:- The file format and extension of MyFile.csv do not match. The file could be corrupted or unsafe. ...
0
votes
2answers
36 views

need help in editing data in csv file

I am in need of editing the date data in csv. I will explain with an example. I am using WPS presentation software for reading and editing csv files. If the above is not possible in that, i can ...
0
votes
0answers
102 views

MySQL csv excel greek characters

I developed an application using Bottle web framework and Python, to import some data into MySQL database. Most of the data where in Greek characters. On my application side, i didn't any further ...
1
vote
1answer
135 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
33 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
39 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
33 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
64 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
171 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
68 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
130 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
47 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
47 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
64 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
52 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
38 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 ...
1
vote
1answer
50 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
26 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
46 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
31 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
103 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
57 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 = ...