Questions tagged [csv]
Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.
297
questions with no upvoted or accepted answers
7
votes
0
answers
1k
views
Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc
Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
4
votes
0
answers
979
views
I'm exporting contacts from Outlook 2007 to CSV file and getting question marks instead of characters
I need to create a CSV file that includes my Outlook 2007 contacts.
The contacts include English and Hebrew (UTF-8) characters as well.
When I export the contacts into a CSV file (Windows - with ...
3
votes
0
answers
945
views
When importing CSVs, does Excel have a limit of 32,767 characters or 32,758 characters?
According to the documentation, Excel has a limit of 32,767 characters per cell.
However, when I save a CSV file that looks like this:
"Cell with exactly 32,767 characters........","...
3
votes
0
answers
111
views
Excel csv-import into table referenced by name
I have a worksheet called raw_data where I import some data via the Data-Import Wizard. This created a new name-referenced range called abc.csv.
However if I try to create a table on another ...
3
votes
2
answers
2k
views
Finding why there is a difference in size for a CSV file with the same content
Situation:
I run a macro to format an excel file, and save the formatted excel file as a .xlsx, the file size is 37 KB. I copy the content and save it into a new file, 30 KB.
Issue:
I want to know ...
3
votes
2
answers
10k
views
Formatting date in excel for csv upload
I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy.
Is there a way to ...
3
votes
0
answers
761
views
How to setup a CSV web datasource
In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
2
votes
0
answers
765
views
Loading UTF8 CSV files generated on a Mac into Excel on Windows: does not recognize encoding
When I generate a UTF8 CSV file in Excel (or some other way) on Windows and then open it n Excel, I expect it to ask me to choose the right encoding.
I got a UTF8 CSV file that was generated on a Mac. ...
2
votes
0
answers
644
views
Open Colon delimited file from command line in Excel
I want to create a shortcut or a command to open a file that uses a colon : as a delimiter in excel.
I know via the UI I can
click "From Text/CSV"
select a file
click Import
select a ...
2
votes
0
answers
50
views
open csv as utf8 without creating a query
I often need to open utf-8 encoded csv files in Excel (365).
I open them using Power Query (get data - from text/csv) where I can specify encoding, and it's generally fine.
However sometimes I need to ...
2
votes
0
answers
42
views
Import csv file in excel scrambles characters
I'm trying to import a csv file that I created myself out of a python script. I'm struggling with encoding. The csv file is encoded in utf-8 with unix style line endings. TI"m on a german macos ...
2
votes
0
answers
444
views
How to copy multi-line text from LibreOffice Calc WITH quotes
I've been searching and found this question... How to copy multi-line text from Excel without quotes? ...which is almost exactly the opposite problem I have.
I am using LibreOffice Calc and I have ...
2
votes
2
answers
5k
views
Why does LibreOffice Calc change CSV file Character Set?
I have a .csv file export (actually printed to csv file) made on a Windows 10 machine. Working in Libreoffice Calc on Archlinux, Why can Calc open a file using settings Character Set: Western Europe (...
2
votes
0
answers
2k
views
Is it possible to make Excel auto-filter case sensitive?
I have a CSV file I opened with Excel 2013 because I wanted to find errors in a specific column.
Here is an extract of data:
"ID";"LANGUAGE";"TYPE";"NAME";"ACTIVE";"CITY";"POSTAL_CODE";"...
2
votes
1
answer
18k
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 ...
2
votes
1
answer
778
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 ...
2
votes
0
answers
2k
views
What's the most convenient way to edit multi-card vcard files (.vcf)?
I have my contacts exported to a VCF file (a vCard) file. But they're partially messed up for reasons I won't go into. I'd like to edit them, making some changes to individual entries and some changes ...
2
votes
0
answers
1k
views
PowerShell Script to Rename - Copy - Move
I am trying to write a PowerShell script to do the following.
step 1
Rename files in source (FTP folders) directories with it's "current_name_datetime.csv" as per a source file "Source_list.csv" ...
2
votes
1
answer
1k
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 ***...
2
votes
0
answers
89
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 ...
2
votes
0
answers
804
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 ...
2
votes
0
answers
353
views
Why is libre office calc inserting a ' at the beginning of the cell?
This is the most ridiculous thing i've encountered.. I've imported a csv, I end up with nice neat clean rows of numbers, no formatting, nothing weird, no " or ' left over, just numbers. When I go to ...
2
votes
0
answers
2k
views
Get rid of warning for external data connection
In Excel 2011 for Mac, I'm using an external data link to collect data from a CSV file generated by a third party application. The CSV is continuously filled, so I want to update the data every time I ...
2
votes
2
answers
4k
views
Import-CSV with powershell using a variable path
I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work.
$path = "C:\Users\Admin\Desktop\TestFolder\file.txt"
Import-CSV -...
2
votes
1
answer
645
views
read excel sheet into jagged array
I am a programmer but recently new to both powershell and vba. I found this simple but effective command in powershell to read in a csv file and you can then immediately access "columns" by their ...
2
votes
1
answer
907
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 ...
2
votes
3
answers
3k
views
Change line endings and delimiter format (permanently) when saving to CSV from Excel
I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to ","
Is there ...
2
votes
2
answers
7k
views
How can I convert PDF bank statements to a Excel or CSV file?
I am just doing my UK tax return (Yes I have left it until the last minute). My bank (Nationwide) will only let me download the last 15 months of transactions as a CSV file, but will let me download ...
1
vote
1
answer
832
views
How to create a line break in Anki when importing from a csv file?
While creating a deck for Anki using the import functionality from csv, I've run into an issue getting the line breaks to function properly.
Here is the situation:
This is for the front card
It is ...
1
vote
0
answers
567
views
How to convert list of SBOMs to one CSV file?
I have the ability to create multiple SBOMs for many projects in Synopsys Black Duck Hub. They can be in the SPDX or CycloneDX SBOM standards in a JSON, YAML, RDF, or tag:value formats.
Is there a ...
1
vote
1
answer
116
views
Failure to convert JSON to CSV file
I need to extract a particular anti-virus product scan results from a JSON file and list the elements in csv format for further processing. JSON file sample as below:
Contents of a file scanresults....
1
vote
1
answer
500
views
Using REGEX only, copy last (delimited) word to every comma separated value?
I have a series of lines with arbitrary number of comma separated values, and then a hash marked comment. The challenge is, using only PCRE2 regex for use in PERL, to do the following:
Store the ...
1
vote
1
answer
641
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
1
vote
2
answers
1k
views
Export Excel sheet as CSV, with regional settings
I want to export an excel sheet as CSV, with powershell. The issue I have is that the regional settings are not respected. They say to use semicolon as delimiter, but comma is used instead. If I ...
1
vote
0
answers
244
views
Copying a file from a linux embedded system to local machine connected by a Serial connection
I am connected to my embedded system by serial connection to my laptop(windows), and using puTTy I booted it up. It is collecting data and making a .csv file of the collected data. I would like to get ...
1
vote
0
answers
557
views
Use Microsoft Excel to import and refresh data from only some columns of a CSV
I have a CSV that's 100+ MB, so it takes a long time to load.
In Microsoft Excel for Mac Version 16, I'd like to use the "Get data" or a similar functionality to load data from that CSV into ...
1
vote
0
answers
242
views
Concatenate dynamic date time with text in CSV file
Requirement: I have an excel file (a CSV) having a column - "Error -today's date & Time" (now()) to be picked every time Windows Task Scheduler batch file is picking this file. The ...
1
vote
1
answer
315
views
Why MS Excel doesnt render CSV file correctly
I have a CSV file with following contents:
timestamp, post_header, post_content
2021-12-05 16:11:31.138993,Pista Software | Test,"...<long multiline text>..."
2021-12-05 16:11:31....
1
vote
0
answers
2k
views
Excel 2019 default encoding for csv files
Problem
I'm using Excel 2019 and I have this .csv file(Multiple language) which is in UTF-8 encoding and when I try to open the file, Excel opens it in ASCII encoding — the english characters and ...
1
vote
0
answers
268
views
How to specify output file cell format when using ssconvert --merge-to to create ODS file from multiple CSVs?
I successfully converted a series of .csv files into a single .ods spreadsheet file, but I had a minor formatting problem: all cells with date contents ended up with date and time format. Command used:...
1
vote
0
answers
52
views
Awk stopping printing at "
I'm making an awk script to convert a csv of aliases into a shell script to apply them, but I'm having an issue where awk seems to be stopping at a " in the second field. The command I'm running ...
1
vote
0
answers
256
views
secure file copy (scp) back and forth from remote line to Windows
Need to learn more about scp but I was able to transfer an entire directory (registry_configs) of CSV files from a remote linux machine ([email protected]) to my Windows 10 environment with this:
scp -...
1
vote
0
answers
177
views
Jira -- export tempo timesheet (grid view) to Excel
Jira: How do you export tempo timesheet (grid view) to Excel -- either .csv or an ordinary excel file.
I am using Microsoft Edge browser, and there is no easy link available (such as Export).
I ...
1
vote
0
answers
281
views
Excel intermittently opens blank excel and CSV files
I have a python script that reads info from MongoDB into a file. It can output either Excel or CSV files.
For some reason when I open the files it either opens as a blank document or showing the ...
1
vote
0
answers
522
views
Automating Excel to save file as CSV and run live updates
For starters - I am raw and have limited skills, thus the guidance here is important to me.
We have to supply data to a 3rd party in CSV format. The data must be updated at frequent intervals with a ...
1
vote
1
answer
670
views
Merge 3 .csv into one file with different number of columns
I have 3 .csv files and I want to merge them together to one .csv file which can be in R or Matlab.
The files are:
1597 obs of 167 variables;
160 obs of 167 variables;
533 obs of 146 variables
I ...
1
vote
0
answers
4k
views
Loading new data from a CSV file into an Excel table
I have an Excel spreadsheet which I made by
starting with a CSV file
converting the data into a table
adding some columns to the table in which various computations happen
saving the file as .xlsx
...
1
vote
0
answers
173
views
Excel - Manual Column(s) Beside Imported Data
In excel, how do you properly mix 'manual' data and imported data in a sheet / data range?
Requirement
For context, my particular use case is a sort of bare-bones data "triage" tool in excel.
Ideal ...
1
vote
2
answers
3k
views
Batch file to remove double quotes from csv
My file is tab separated file(TSV) with 5 columns
I have local drive path on my first column but each image name from path contains double quotes.
Path
C:\Users\magoo\"flower.jpg"
C:\Users\magoo\"...
1
vote
0
answers
24
views
Re-use An Import-Mapping of a CSV into SQL Azure DB using SSMS
In https://stackoverflow.com/questions/12503430/import-csv-into-sql-azure-database-using-ssms/35876305#35876305 one solution was to save the import dtsx so as to reuse. However, I cannot find how to "...